Is this ERD and the following creating tables screen shot of how I am creating the tables in 3NF. If not what following changes should i be making. I insert data into the media table: INSERT INTO MEDIA VALUES(11, 'MOVIE', 'ZOMBIELAND'); I insert the data into the movies table like this: INSERT INTO MOVIES VALUES(11, 'ZOMBIELAND', 'COMEDY', 2009, 86, 'RUBEN FLEISCHER', 'MOVIE'); Is this correct in third normal form. Do i have a dependancy designing the database like this?
Is this ERD and the following creating tables screen shot of how I am creating the tables in 3NF. If not what following changes should i be making. I insert data into the media table: INSERT INTO MEDIA VALUES(11, 'MOVIE', 'ZOMBIELAND'); I insert the data into the movies table like this: INSERT INTO MOVIES VALUES(11, 'ZOMBIELAND', 'COMEDY', 2009, 86, 'RUBEN FLEISCHER', 'MOVIE'); Is this correct in third normal form. Do i have a dependancy designing the database like this?
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
Related questions
Question
100%
Is this ERD and the following creating tables screen shot of how I am creating the tables in 3NF. If not what following changes should i be making. I insert data into the media table:
INSERT INTO MEDIA
VALUES(11, 'MOVIE', 'ZOMBIELAND');
I insert the data into the movies table like this:
INSERT INTO MOVIES
VALUES(11, 'ZOMBIELAND', 'COMEDY', 2009, 86, 'RUBEN FLEISCHER', 'MOVIE');
Is this correct in third normal form. Do i have a dependancy designing the
Transcribed Image Text:CREATE TABLE MEDIA (
MEDIA_ID INTEGER(10) PRIMARY KEY,
MEDIA_TYPE VARCHAR(255),
MEDIA_NAME VARCHAR(255)
);
CREATE TABLE MOVIES (
MOVIE_ID INTEGER(10) PRIMARY KEY,
MOVIE_NAME VARCHAR(255),
MOVIE_GENRE VARCHAR(255),
MOVIE_YEAR INTEGER(4),
MOVIE_LENGTH INTEGER(10),
MOVIE_DIRECTOR VARCHAR (255),
MOVIE_MEDIA_TYPE VARCHAR(255),
FOREIGN KEY (MOVIE_ID) REFERENCES MEDIA (MEDIA_ID)
);
CREATE TABLE TV (
TVSHOW_ID INTEGER(10) PRIMARY KEY,
TVSHOW_NAME VARCHAR (255),
TVSHOW_GENRE VARCHAR(255),
TVSHOW_YEAR INTEGER(4),
TVSHOW_SEASONS INTEGER(3),
TVSHOW_CREATOR VARCHAR(255),
TV_MEDIA_TYPE VARCHAR(255),
FOREIGN KEY (TVSHOW_ID) REFERENCES MEDIA (MEDIA_ID)
);
CREATE TABLE MUSIC (
MUSIC_ID INTEGER(10) PRIMARY KEY,
MUSIC_NAME VARCHAR(255),
MUSIC_ARTIST VARCHAR(255),
MUSIC_ALBUM VARCHAR (255),
MUSIC_GENRE VARCHAR(255),
MUSIC_YEAR INTEGER(4),
MUSIC_LENGTH VARCHAR(255),
MUSIC_MEDIA_TYPE VARCHAR(255),
FOREIGN KEY (MUSIC_ID) REFERENCES MEDIA (MEDIA_ID)
);
Transcribed Image Text:media
MEDIA_ID INT
HO MEDIA_TYPE VARCHAR(255)
O MEDIA_NAME VARCHAR(255)
Indexes
movies
MOVIE_ID INT
O MOVIE_NAME VARCHAR(255)
O MOVIE_GENRE VARCHAR(255)
MOVIE_YEAR INT
O MOVIE_LENGTH INT
O MOVIE_DIRECTOR VARCHAR(255)
O MOVIE_MEDIA_TYPE VARCHAR(255)
tv
TVSHOW_ID INT
OTVSHOW_NAME VARCHAR(255)
Indexes
OTVSHOW_GENRE VARCHAR(255)
O TVSHOW_YEAR INT
OTVSHOW_SEASONS INT
OTVSHOW_CREATOR VARCHAR(255)
OTV_MEDIA_TYPE VARCHAR(255)
Indexes
I music
MUSIC_ID INT
O MUSIC_NAME VARCHAR (255)
O MUSIC_ARTIST VARCHAR (255)
O MUSIC_ALBUM VARCHAR(255)
O MUSIC_GENRE VARCHAR(255)
O MUSIC_YEAR INT
O MUSIC_LENGTH VARCHAR(255)
O MUSIC_MEDIATYPE VARCHAR(255)
Indexes
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 4 images
Knowledge Booster
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.Recommended textbooks for you
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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education