Genre GenreMovie ID INTEGER PF* Genre_ID PF* Movie_ID INTEGER Name VARCHAR2 INTEGER Genre_PK (ID) GenreMovie_PK (Genre_ID, Movie 太 GenreMovie_Genre_FK (Genre_ID GenreMovie_Movie_FK (Movie_ID) Movie...



What is the highest normal form (NF) for table "Person"





Select one:


a. 2NF

b. 1NF

c. 4NF

d. The table is not in any NF

e. 3NF



Genre<br>GenreMovie<br>ID<br>INTEGER<br>PF* Genre_ID<br>PF* Movie_ID<br>INTEGER<br>Name<br>VARCHAR2<br>INTEGER<br>Genre_PK (ID)<br>GenreMovie_PK (Genre_ID, Movie<br>太<br>GenreMovie_Genre_FK (Genre_ID<br>GenreMovie_Movie_FK (Movie_ID)<br>Movie<br>Person<br>ID<br>INTEGER<br>ID<br>INTEGER<br>Name<br>VARCHAR2<br>FirstName<br>VARCHAR2<br>Length<br>ProductionCompany<br>ProductionCompany_Street<br>ProductionCompany_City<br>INTEGER<br>LastName<br>UNKNOWN<br>VARCHAR2<br>Pseudonyms<br>VARCHAR2<br>VARCHAR2<br>Person_PK (ID)<br>VARCHAR2<br>Movie_PK (ID)<br>Cast<br>PF * Movie_ID<br>Director_ID<br>KPF* Actor_ID<br>INTEGER<br>INTEGER<br>INTEGER<br>Role<br>VARCHAR2<br>Acting_PK (Movie_ID, Actor_ID)<br>Cast_Actor_FK (Actor_ID)<br>Cast Director FK (Director_ID)<br>Cast_Movie_FK (Movie_ID)<br>

Extracted text: Genre GenreMovie ID INTEGER PF* Genre_ID PF* Movie_ID INTEGER Name VARCHAR2 INTEGER Genre_PK (ID) GenreMovie_PK (Genre_ID, Movie 太 GenreMovie_Genre_FK (Genre_ID GenreMovie_Movie_FK (Movie_ID) Movie Person ID INTEGER ID INTEGER Name VARCHAR2 FirstName VARCHAR2 Length ProductionCompany ProductionCompany_Street ProductionCompany_City INTEGER LastName UNKNOWN VARCHAR2 Pseudonyms VARCHAR2 VARCHAR2 Person_PK (ID) VARCHAR2 Movie_PK (ID) Cast PF * Movie_ID Director_ID KPF* Actor_ID INTEGER INTEGER INTEGER Role VARCHAR2 Acting_PK (Movie_ID, Actor_ID) Cast_Actor_FK (Actor_ID) Cast Director FK (Director_ID) Cast_Movie_FK (Movie_ID)

Jun 11, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here