Database Design Using Entity-Relationship Diagrams
Search in google:
Entity-relationship (E-R) diagrams are time-tested models for database development well-known for their usefulness in mapping out clear database designs. Also commonly known is how difficult it is to master them. With this comprehensive guide, database designers and developers can quickly learn all the ins and outs of E-R diagramming to become expert database designers. Because E-R diagrams are so fundamental to database design, this book is also an indispensable text for teaching computer science students the basics of database development. Database Design Using Entity-Relationship Diagrams clarifies E-R diagramming by defining it in terms of requirements (end user requests) and specifications (designer feedback to those requests). The book explains how open communication between designers and end users is critical to developing usable, easy-to-understand E-R diagrams that model both requirements and specifications. The authors explain, in an intuitive, informal manner, how to develop an E-R diagram, how to map it to a database, and how the resulting database can be tested. This definitive guide is a basic component for any database course, and is also an invaluable reference that database professionals can use throughout their careers.introbul>Features
PrefaceAcknowledgmentsIntroduction1The Software Engineering Process and Relational Databases12The Basic ER Diagram: A Data Modeling Schema233Beyond the First Entity Diagram534Extending Relationships/Structural Constraints735The Weak Entity1156Further Extensions for ER Diagrams with Binary Relationships1337Ternary and Higher-Order ER Diagrams1658Generalizations and Specializations1879Relational Mapping and Reverse-Engineering ER Diagrams20510A Brief Overview of the Barker/Oracle-Like Model219Glossary233Index237
![SQL Queries for Mere Mortals: A Hands-on Guide to Data Manipulation in SQL [For Mere Mortals Series]](/application/data/covers/44/31/9780321444431.jpg "SQL Queries for Mere Mortals: A Hands-on Guide to Data Manipulation in SQL [For Mere Mortals Series]")
