Question: Below are the SQL commands to create another table of movies and to insert 2 records. CREATE TABLE movies (id INT NOT NULL PRIMARY KEY,

 Below are the SQL commands to create another table of movies

Below are the SQL commands to create another table of movies and to insert 2 records. CREATE TABLE movies (id INT NOT NULL PRIMARY KEY, name VARCHAR(50), star1 VARCHAR(20), star2 VARCHAR(20), star3 VARCHAR(20)); INSERT INTO movies (id, name, stari, star2) VALUES (1, 'Zombies', 'Meg Donnely', 'Milo Manheim'); INSERT INTO movies (id, name, stari, star2, star3) VALUES (2, 'Finding Nemo', 'Nemo', 'Dory', 'Marlin'); Is the table in First Normal Form (1NF)? If not in 1NF, explain ALL the reasons why it is not in 1NF. Edit View Insert Format Tools Table

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!