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

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
icon
Concept explainers
Question
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
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)
Transcribed Image 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)
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Query Syntax
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education