Question 1 2 pts Given the ERD below which of the following relational designs i

Question

Question 1 2 pts Given the ERD below which of the following relational designs is appropriate? (The primary key is underlined and the foreign key is in italics in the answers.) MOVIE ACTOR MovieID ActorID Has Role In Title FirstName Language Last Name Uses Subtitles O MOVIE (MovieID, Title, Language, Subtitles) ACTOR (Actor D. FirstName, LastName) MOVIE ACTOR (Moviel D, ActorID O MOVIE (MovieID, Title, Language, Subtitles) ACTOR (ActorlD, FirstName, LastName) O MOVIE Moviel D, Title, Language, Subtitles) ACTOR (ActorlD. FirstName, LastName) MOVIE ACTOR (Movjeto, ActorO) O MOVIE (Moviel D, Title, Language, Subtitles) ACTOR (Actor D. FirstName, LastName) MOVIE ACTOR (MoviefO, ActorID O MOVIE (MovieID, Title, Language, Subtitles) ACTOR (ActorlD, FirstName, LastName) O MOVIE (MovieID, Title, Language, Subtitles) ACTOR (ActorlD, FirstName, LastName) MOVIE ACTOR (Moviel D, ActorfD

Explanation / Answer

1)Movie(movieID,title,language ,subtitle)

Actor(Actor ID,first name ,last name)

Movie_Actor(ActorID,movieID)

Here movieID and actorID is the primary key

and movie ID is the foreign key.

3.the foreign key is a unique value and it must be in each and every row

4)person(personID,first name,last name)

Person_Relation(personid,relationid)

PersonID is the primary key.

Relation ID is the foreign key.

5)all foreign key must be unique and it must be I'm every row

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

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