车辆e-r图.docVIP

7 CHAPTER DatabaseDesignandtheE-R Model PracticeExercises 7.1 Answer: TheE-RdiagramisshowninFigure 7.1.Paymentsaremodeled asweakentitiessincetheyarerelatedtoaspeci?cpolicy. Note that the participation of accident in the relationship participated is not total, since it is possible that there is an accident report where the participatingcarisunknown. customer car 1..* 1..1 policy c u s to m e r _ id n a m e owns covers license_no m o d e l policy_id a d d r e s s p a rtic ip a te d payment accident p r e m i u m _ p a y m e n t report_id d a t e p a y m e n t _ n o d u e _ d a t e place a m o u n t received _ o n Figure7.1 E-Rdiagramforacarinsurancecompany. 1  2 Chapter7 DatabaseDesignandtheE-RModel marks student section course student_id exam_marks sec_course course_id title sec_id semester year name dept_name tot_cred credits exam exam_id name place time Figure7.2 E-Rdiagramformarksdatabase. {exam_marks exam_id marks } student section course student_id name exam_marks sec_course course_id title sec_id semester year dept_name tot_cred credits Figure7.3 AnotherE-Rdiagramformarksdatabase. 7.2 Answer: Note:thenameoftherelationshipcourseofferingneedstobe changedtosection. a. TheE-RdiagramisshowninFigure 7.2.Notethatanalterantiveisto modelexaminationsasweakentitiesrelatedtoasection,ratherthan as a strong entity. The marks relationship would then be a binary relationship between student and exam, without directly involving section. b. The E-R diagram is shown in Figure 7.3. Note that here we have not modeled the name, place and time of the exam as part of the relationshipattributes.Doingsowouldresultinduplicationofthe information,onceperstudent,andwewouldnotbeabletorecord this information without an associated student. If we wish to rep- resent this information, we would need to retain a separate entity correspondingtoeachexam.  Exercises 3 score match player match_id date player_id played stadium opponent own_score opp_score