11. The MovieTicket relation keeps data about the movie tickets bought by custom

Question

11. The MovieTicket relation keeps data about the movie tickets bought by customers. MovieTicket MovielD MovieTitle ShowlD ShowDay ShowTime CustomerID CustomerName TicketNo BuyDate 1/1/2013 12 PM 1/1/201312 PM 1/1/2013| 12 PM 1/1/2013| 12 PM 1/2/20132 PM 1/2/20132 PM 1/3/2013 6 PM 1/3/2013 6 PM 12/31/2012 12/31/2012 1/1/2013 1/1/2013 1/1/2013 1/2/2013 1/2/2013 1/3/2013 a. Identify the functional dependencies in the relation. Is this relation in INF, 2NF, 3NF, and BCNF, and why? If not, show your steps of performing the normalization to transform the relation into 1NF, 2NF, 3NF, and BCNF. Show all referential integrity constraints in the relational model that results from the normalization. b.

Explanation / Answer

Functional dependencies:

movieID->MovieTitle;

ShowID->ShowDay;

ShowID->ShowTime;

CustomerID->CustomerName;

For this relation (MovieID,ShowID,CustomerID) is the key, there are partial dependencies so it is not in 1NF (all are single valued attributes),

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.