E-Books →Database Design Using Entity–Relationship Diagrams (Foundations of Database Design)

Building on the success of the bestselling first and second editions, this accessible text includes a new chapter on the relational model and functional dependencies. It also includes expanded chapters on Enhanced Entity-Relationship (EER) diagrams and reverse mapping. It uses cutting-edge case studies and examples to help readers master database development basics and defines ER and EER diagramming in terms of requirements (end user requests) and specifications (designer feedback to those requests), facilitating agile database development. This bookDescribes a step-by-step approach for producing an ER diagram and developing a relational database from itContains exercises, examples, case studies, bibliographies, and summaries in each chapterDetails the rules for mapping ER diagrams to relational databasesExplains how to reverse engineer a relational database back to an entity-relationship modelIncludes grammar for the ER diagrams that can be presented back to the user, facilitating agile database developmentThe updated exercises and chapter summaries provide the real-world understanding needed to develop ER and EER diagrams, map them to relational databases, and test the resulting relational database. Complete with a wealth of additional exercises and examples throughout, this edition should be a basic component of any database course. Its comprehensive nature and easy-to-navigate structure make it a resource that students and professionals will turn to throughout their careers.