Suppose you are given the form below. Assume that a video cannot be rented twice

Question

Suppose you are given the form below. Assume that a video cannot be rented twice on one receipt. Show your work

Database question

Suppose you are given the form below. Assume that a video cannot be rented twice on one receipt. Show your work. (14 points) 7. Moore Videos Name: Lindsey Moore Receipt: 68395 Date: 9/1/08 City, ST: Ann Arbor, MI Person ID: 226 Phone: 734 668-4385 Video Information ID 325 Shrek 548 Remember the Titans H 6437 The Replacement Killers H Total Name Type Days Date Due Cost 9/2/08 3.00 9/3/08 2.50 9/3/08 2.50 8.00 1. Write the 1NF relation 2. Write the 2NF relations. Identify the identifiers of these relations 3. Identify any transitive dependencies 4. Write the 3NF relations

Explanation / Answer

1. 1NF

VideoRental(VideoID,PersonID,PersonName,PersonPhone,RecieptDate,PersonCity, ReceiptNo, VideoName, VideoType,RentDays, VideoCost, RentDueDate)

2. 2NF and identifiers

Functional Dependencies:

VideoID -> VideoName,VideoType,VideoCost

PersonID -> PersonName,PersonPhone,PersonCity

ReceiptNo -> ReceiptDate,RentDueDate,RentDays,PersonID

relations in 2NF

VIDEO(VideoID, VideoName,VideoType,VideoCost)

PERSON(PersonID, PersonName,PersonPhone,PersonCity)

RENTAL(ReceiptNo , PersonID,ReceiptDate,RentDueDate,RentDays)

underlined are identifiers.

3. Transitive Dependencies

RecepitNo -> VideoID ( a video cannot be rented twice on a one receipt)

4. 3NF relations

VIDEO(VideoID, VideoName,VideoType,VideoCost)

PERSON(PersonID, PersonName,PersonPhone,PersonCity)

RENTALPERSON(ReceiptNo,PersonID , ReceiptDate,RentDueDate,RentDays)

RENTVIDEO(ReceiptNo,VideoID)

underlined are primary keys and italicised are foreign keys.

Do ask if any doubt. Please upvote.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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