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

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) ACTOR MOVIE Movie ID ActorID Has Role In Title First Name Language LastName Uses Subtitles O MOVIE (MovieID, Title, Language, Subtitles) ACTOR (ActorlD. FirstName, LastName) MOVIE ACTOR (MovieID, ActorID O MOVIE (MovielD, Title, Language, Subtitles) ACTOR (ActorlD, FirstName, LastName) O MOVIE (MovieID, Title, Language, Subtitles) ACTOR (ActorlD, FirstName, LastName) MOVIE ACTOR (Movie D. Actor D MOVIE (MovielD, Title, Language, Subtitles) ls this correct? lf not please say ACTOR (ActorlD. First Name, Last Name) which one? explain MOVIE ACTOR (Movie D, ActorD O MOVIE (MovielD, Title, Language, Subtitles) ACTOR (ActorlD. First Name, Last Name O MOVIE (MovieID, Title, Language, Subtitles) ACTOR (ActorlD, FirstName, LastName) MOVIE ACTOR (MovieID, Actor D

Explanation / Answer

Question 1:

The answer is C. Both MovieID and ActorID should be italics as both of them are foreign keys.

MOVIE(MovieID, Title,Language,Subtitles)

ACTOR(ActorID,FirstName,LastName)

MOVIE_ACTOR(MovieID,ActorID)

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

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