Question: 9 . 1 . ( a ) Discuss the correspondences between the ER model constructs and therelational model constructs. Show how each ER model construct

9.1.(a) Discuss the correspondences between the ER model constructs and therelational model constructs. Show how each ER model construct can bemapped to the relational model and discuss any alternative mappings.(b) Discuss the options for mapping EER model constructs to relations, andthe conditions under which each option could be used.9.7. Is it possible to successfully map a binary M:N relationship type withoutrequiringa new relation? Why or why not?(SnameOwner(PnameSHIPFigure 9.8KHOME PORTHISTORY1SHIP1PORTModelVinSidLatitude(0(0;)SHIP ATPORTAn ER schema for a SHIP_TRACKING database.SALEPrice)VEHICLEDateSALESPERSONTime_stampLongitudeNameTYPE1(1,1)INSsnONCARDateTimeSUV19.4. Figure 9.8 shows an ER schema for a database that can be used to keep track oftransport ships and their locations for maritime authorities. Map this schemainto a relational schema and specify all primary keys and foreign keys.TRUCKCUSTOMERType TonnageStart datePORT_VISIT(NameSHIP_TYPEEnd dateTonnageNameSEA/OCEAN/LAKEEngine _sizeNo_seatsSTATE/COUNTRYNameHullAddressState9.8. Consider the EER diagram in Figure 9.9 for a car dealer.CityContinent)StreetMap the EER schema into a set ofrelations. For the VEHICLE to CAR/TRUCK/SUVgeneralization, consider the four options presented in Section 9.2.1 and showthe relational schema design under each of those options.Figure 9.9EER diagram fora car dealer.MOVEMENT
9 . 1 . ( a ) Discuss the correspondences between

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!