数据模型指导(英文).pdfVIP

Guide To Data Modeling Advisor Major Student Major = { MajorCode + Desc } Advisor = { StudentNo + MajorCode + Advisor } Student = { StudentNo + Name + Address } Major Table Advisor Table MajorCode Desc StudentNo MajorCode Advisor BA Business 6634413 BA Franklin ENG Engineering 6634413 PHY Leung PHY Physics 8743232 BA Franklin 9659844 BA Adams Student Table 9659844 ENG Quale StudentNo Name Address 9659844 PHY Olsen 6634413 Burrows 123 Main 8743232 Brown 710 Terry 8851000 Welch 4610 17th 9243255 Jones 1701 46th 9659844 Smith 833 Talbert William E. Burrows Copyright ©1999 William E. Burrows Guide To Data Modeling Table of Contents Entity-Relationship Diagrams Entities and Attributes 1 Relationships 2 Cardinality 2 One-to-One 2 One-to-Many 3 Many-to-Many 4 Alternative ED Diagram Symbols 5 Example ER D