Represent this database as a collection of relational tables. Include primary an

Question

Represent this database as a collection of relational tables. Include primary and foreign keys. Do not specify data types for columns or write SQL commands.

Borrow date FID DVDID Star Actor Name Friends 1 DVD's Name Borrows Number Title Return Date Entity E1 Friends, Key K1 : FID, Attribute A1 Name, Attribute A2: Number Entity E2 DVD's, Key K2: DVDID, Attribute A5 Star Actor Name, Attribute A6: Title Relationship R1: Borrows, Attribute A3: Return date, Attribute A4: Borrow Date Cardinality2: Cardinality1: one to many, many to one

Explanation / Answer

Friends(Fid, Name, Number)

DVD’s(DVDID, StarActorName, Title)

Borrows(Fid, DVDID, BorrowDate, Return Date)

Fid is the primary key of Friends table.

DVDID is the primary key of DVD’s table.

Fid and DVDID are primary keys of Borrows table.

Fid and DVDID are the foreign keys of Borrows table. Fid refers to Fid of Friends table and DVDID refers to the DVDID of DVD’s table.

Related Questions

Navigate

• Browse (All)
• Browse R
• Subjects

---

---

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