Question: Please help me solve question A, B and C, and explain why, thanks. Consider the following set of functional dependencies: EventID EventDate Event ID Event

 Please help me solve question A, B and C, and explain

Please help me solve question A, B and C, and explain why, thanks.

Consider the following set of functional dependencies: EventID EventDate Event ID Event Time Seat ID Seat Row Seat ID Section_ Number Customer _IDCustomer Name EventID + SeatID + CustomerID Reservation. Date Event. ID + SeatD + CustomerID ReservationTime - - - - - - - - [1 point] Develop a set of 3NF relations to represent the set of functional dependencies shown above. Use the following relation names: a. i. EVENT ii. SEAT iii. CUSTOMER iv. RESERVATION b. [1 point] Create an E-R diagram to represent the relations you created in part 2a, given the following requirements: i. An event can have zero to many reservations, while a reservation is for one (and only one) event. i. A reservation is made by one (and only one) customer, while a customer makes one to many reservations. ii. A reservation reserves one to 20 seats, while a seat can be reserved for zero to many reservations. You can use draw.io or a similar tool to design and export your diagram, then insert/paste the diagram image into this document. [1 point] Write a business rule (either domain or triggering operation) for an attribute in your diagram (include all domain or triggering operation elements). c

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 Databases Questions!