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
Basic Data Relationships
11 other sections not shown
actor_name animal appear application attributes base chapter CHAR 15 CHAR 30 CHECK classification column constraints contains CREATE TABLE data dictionary data model database design DBMS delete dependency determine diagram document domain employee enter entity example exists Figure FOREIGN KEY given handle identifier indicate instance INTEGER intelligence Jane John Lasers Location logical look matching means modify Motors normal form Note null numb organization performance person person_ID PRIMARY KEY problem purchase query REFERENCES relation relational database relationship represent result retrieval rows rule schedule schema shipped single skill Smith species statements structure tank tion tool unique UPDATE varchar volunteer