Question: ER model: According to the ER model given above, answer either yes or no to the following questions: RENTAL (a) (b) (c) Does every member

ER model: According to the ER model given above, answer either yes or no to the following questions: RENTAL (a) (b) (c) Does every member have a rental activity? Has every car ever been rented? Is the relationship between Location and Rental modelled as a many to many relationship? Are there any other possible types of car? (1 mark) (1 mark) CarType From Dropor (1 mark) (1 mark) (d) LocatonNane Convert the ER model given in Part A into a set of relations that satisfy Third Normal Form (3NF). You do not need to show your workings. You do not need to justify that they are in 3NF at this stage. You do not need to show sample data. Just show your relations. You should write you r relations in either format shown below Student (StudentID StudentName, DateOfBirth) Enrolment (EnrolmentID, StudentID, DateOfEnrolment) or. Student (StudentID, StudentName, DateOfBirth) Enrolment (EnrolmenuD, StudentID. DateOfEnrolment) Foreign key (StudentiD) references Student ER model: According to the ER model given above, answer either yes or no to the following questions: RENTAL (a) (b) (c) Does every member have a rental activity? Has every car ever been rented? Is the relationship between Location and Rental modelled as a many to many relationship? Are there any other possible types of car? (1 mark) (1 mark) CarType From Dropor (1 mark) (1 mark) (d) LocatonNane Convert the ER model given in Part A into a set of relations that satisfy Third Normal Form (3NF). You do not need to show your workings. You do not need to justify that they are in 3NF at this stage. You do not need to show sample data. Just show your relations. You should write you r relations in either format shown below Student (StudentID StudentName, DateOfBirth) Enrolment (EnrolmentID, StudentID, DateOfEnrolment) or. Student (StudentID, StudentName, DateOfBirth) Enrolment (EnrolmenuD, StudentID. DateOfEnrolment) Foreign key (StudentiD) references Student
Step by Step Solution
There are 3 Steps involved in it
Based on the ER model provided lets address each question Questions a Does every member have a renta... View full answer
Get step-by-step solutions from verified subject matter experts
