Relational Database Design Clearly Explained
The majority of database systems being installed today are based on the relational database model. Unfortunately, relational database design is one of the most misunderstood aspects of computing. Part of the problem comes from popular literature that describes a relational database as anything that has "relationships between files." And those who do understand that a relational database is really nothing more than a collection of two-dimensional tables are caught between good design and the performance of the database. They are often unaware of the side-effects of many of their poor design decisions.
What people are saying - Write a review
We haven't found any reviews in the usual places.
Entities and Data Relationships
The Relational Data Model
10 other sections not shown
002 John Doe 003 Jane Smith 004 John Smith 006 John Jones ALTER TABLE application program aquarium attributes base tables birthdate candidate keys catalog CHAR 15 CHAR 30 column composite entity constraints customer number customer_ID customer_numb data dictionary data flow diagram data model data store data type database design DBMS DBMSs delete distributor domain employee example Figure FOREIGN KEY fourth normal form handle ID number identifier instance of entity INTEGER inventory item number item_numb KEY person_ID Lasers Only database many-to-many relationships merchandise item Mighty-Mite Motors model_numb normal form null numb order number order_numb phone number PRIMARY KEY problem query REFERENCES referential integrity relational database repeating groups retrieval rows schedule schema second normal form shipped species species_numb SQL statements tank tank_numb temporary table third normal form tion tool unique UPDATE varchar 30 volunteer weak entity