大型数据库设计ch03课程.pptVIP

Chapter Premise We have received one or more tables of existing data The data is to be stored in a new database QUESTION: Should the data be stored as received, or should it be transformed for storage? How Many Tables? A Strange Table But first … We need to understand: The relational model Relational model terminology The Relational Model Introduced in 1970 Created by E.F. Codd He was an IBM engineer The model used mathematics known as “relational algebra” Now the standard model for commercial DBMS products Important Relational Model Terms Entity Relation Functional Dependency Determinant Ca