(数据库原理课件）Chapter7 Logical Database Design教学教材.pptVIP

Database Design. School of software * Database Design. School of software Chapter 7 Logical Database Design Summary 任课教师：何婧 hejing@ynu.edu.cn Database Design. School of software Objectives Overview of logical database design Step1: create and check ER model Step2: map ER model to tables Merge ER model Database Design. School of software 7.1 Overview of logical database design case 7.3 Map ER model to tables For each entity in ER model, create a table that includes all the entity’s simple attributes. For composite attributes, include only the simple attributes. Where possible, identify the column(s) that make up the primary key in each table. 7.3 Map ER model to tables 1 n 1 n 1 n 1 n 1 n 1 n 1 n 1 1 Database Design. School of software *:* Recursive Relationship Exhibit 5-7: Bill-of Materials ER Diagram As with all many-to-many relationships, a many-to-many recursive relationship is represented with an associative table. In this case, however, the associative table is linked back to the same table (PRODUCT), with both halves of its primary key being foreign keys from the PRODUCT table. Database Design. School of software *:* Recursive Relationship Exhibit 5-8: Bill-of-Materials Database Tables 1:1 binary relationships Consider how to create tables to represent the following participation constraints: Mandatory participation on both sides of 1:1 relationship Mandatory participation on one side of 1:1 relationship Optional participation on both sides of 1:1 relationship. Mandatory participation on both sides of 1:1 relationship Mandatory participation on one side of a 1:1 relationship Mandatory participation on one side of a 1:1 relationship Mandatory participation on one side of a 1:1 relationship (2nd Example) Mandatory participation on one side of a 1:1 relationship (2nd Example) Optional participation on both sides of a 1:1 relationship Optional participation on both sides of a 1:1 relationship – (a) ER diagram; (b) as tables *