(数据库原理课件）Chapter2 The StayHome Case study知识介绍.pptVIP

HeJing, School of Software * Step 2.4 Check business rules Consider the following types of business rules: required data, column domain constraints, entity integrity, multiplicity, referential integrity, other business rules. HeJing, School of Software * Step 2.4 Check business rules - referential integrity There are two issues regarding foreign keys Are nulls allowed for the foreign key? How do you ensure referential integrity? HeJing, School of Software * How do you ensure referential integrity? Consider the following six cases. Case 1: Insert record into child table Case 2: Delete record from child table Case 3: Update foreign key of child record Case 4: Insert record into parent table Case 5: Delete record from parent table Case 6: Update primary key of parent record There are several strategies to consider for Case 5 HeJing, School of Software * Case 5: Delete record from parent table Strategies to consider include: NO ACTION CASCADE SET NULL SET DEFAULT NO CHECK HeJing, School of Software * Referential integrity constraints for the tables HeJing, School of Software * Step 2.5 Review logical database design with users To ensure that the logical database design is a true representation of the data requirements of an organization (or part of the organization) to be supported by the database. HeJing, School of Software * Advanced logical database design This part of methodology is about what to do when creating a reasonably complex database system with several user views and you have chosen to manage these user views (wholly or partly) using the view integration approach. HeJing, School of Software * Multiplicity constraints for relationships HeJing, School of Software * Adding multiplicity constraints to ER diagram 检查扇形陷阱与深坑陷阱 HeJing, School of Software * document HeJing, School of Software * Step 1.3 Identify and associate attributes with entities or relationships Attributes can be identified where noun or noun phrase is a property, qual