Question
Complete the EliteVideo startup Case Project numbers; using Visual Studio From figure 7.65 on page 312 (creating the database based on the figure P7.65 (pg.
Complete the EliteVideo startup Case Project numbers; using Visual Studio
From figure 7.65 on page 312 (creating the database based on the figure P7.65 (pg. 311- 314)
Write the SQL code to CREATE database, CREATE Tables (MEMEBERSHIP, RENTAL, DETAILRENTAL, PRICE, MOVIE, AND VIDEO).
Write the code to Insert the data into the tables.
Execute the program. Take screenshots of all data in tables (use SELECT * name of the tables)
Below is the code that I tried to run, I keep getting an error. Maybe you guys can figure it out. Also I have a pdf of the tables but could not upload
You can see the problem on Database Systems (11th Edition) by Coronel pages pg 312-314
SQL Homework
Complete the EliteVideo startup Case Project numbers; using Visual Studio
From figure 7.65 on page 312 (creating the database based on the figure P7.65 (pg. 311- 314)
Write the SQL code to CREATE database, CREATE Tables (MEMEBERSHIP, RENTAL, DETAILRENTAL, PRICE, MOVIE, AND VIDEO).
Write the code to Insert the data into the tables.
Execute the program. Take screenshots of all data in tables (use SELECT * name of the tables)
CREATE TABLE MEMBERSHIP(
MEM_NUM INT NOT NULL,
MEM_FNAME VARCHAR(30),
MEM_LNAME VARCHAR(30),
MEM_STREET VARCHAR(30),
MEM_CITY VARCHAR(30),
MEM_STATE CHAR(2),
MEM_ZIP CHAR(5),
MEM_BALANCE VARCHAR(30),
PRIMARY KEY(MEM_NUM)
);
CREATE TABLE DETAILRENTAL(
RENT_NUM INT NOT NULL,
VID_NUM INT NOT NULL,
DETAIL_FEE DECIMAL (10,2),
DETAIL_DUEDATE DATE ,
DETAIL_RETURNDATE DATE,
DETAIL_DAILYLATEFEE DEC (10,2),
FOREIGN KEY(RENT_NUM) REFERENCES RENTAL,
FOREIGN KEY (VID_NUM) REFERENCES VIDEO
);
CREATE TABLE VIDEO(
VID_NUM INT NOT NULL ,
VID_INDATE DATE,
MOVIE_NUM INT
PRIMARY KEY (VID_NUM),
FOREIGN KEY (MOVIE_NUM) REFERENCES MOVIE
);
CREATE TABLE RENTAL(
RENT_NUM INT NOT NULL ,
RENT_DATE DATE,
MEM_NUM INT NOT NULL,
PRIMARY KEY (RENT_NUM),
FOREIGN KEY (MEM_NUM) REFERENCES MEMBERSHIP
);
CREATE TABLE PRICE(
PRICE_CODE INT NOT NULL ,
PRICE_DESCRIPTION VARCHAR(50),
PRICE_RENTFEE INT,
PRICE_DAILYLATEFEE DECIMAL(10,2),
PRIMARY KEY (PRICE_CODE)
);
CREATE TABLE MOVIE(
MOVIE_NUM INT NOT NULL ,
MOVIE_TITLE VARCHAR(50),
MOVIE_YEAR SMALLINT ,
MOVIE_COST DECIMAL (8,2),
MOVIE_GENRE CHAR(30),
PRICE_CODE INT NOT NULL,
PRIMARY KEY (MOVIE_NUM),
FOREIGN KEY (PRICE_CODE) REFERENCES PRICE
);
INSERT INTO MEMBERSHIP VALUES(102, 'Tami', 'Dawson', '2632 Takli Circle', 'Norene' ,'TN' ,37136, 11 ),
INSERT INTO MEMBERSHIP VALUES(103, 'Curt', 'Knight', '4025 Cornell Court' ,'Flatgap', 'KY', 41219, 6 ),
INSERT INTO MEMBERSHIP VALUES(104, 'Jamal', 'Melendez', '788 East 145th Avenue', 'Quebeck', 'TN', 38579, 0 ),
INSERT INTO MEMBERSHIP VALUES(105, 'Iva', 'Mcclain', '6045 Musket Ball Circle', 'Summit', 'KY', 42783, 15),
INSERT INTO MEMBERSHIP VALUES(106, 'Miranda', 'Parks', '4469 Maxwell Place', 'Germantown', 'TN', 38183, 0 ),
INSERT INTO MEMBERSHIP VALUES(107, 'Rosario', 'Elliott' ,'7578 Danner Avenue' ,'Columbia', 'TN' ,38402, 5 ),
INSERT INTO MEMBERSHIP VALUES(108, 'Mattie', 'Guy', '4390 Evergreen Street', 'Lily', 'KY', 40740, 0 ),
INSERT INTO MEMBERSHIP VALUES(109, 'Clint', 'Ochoa' ,'1711 Elm Street Greeneville', 'TN', 37745, 10) ,
INSERT INTO MEMBERSHIP VALUES(110, 'Lewis', 'Rosales', '4524 Southwind Circle Counce', 'TN', 38326 ,0 ),
INSERT INTO MEMBERSHIP VALUES(111, 'Stacy', 'Mann', '2789 East Cook Avenue',' Murfreesboro' ,'TN', 37132, 8 ),
INSERT INTO MEMBERSHIP VALUES(112, 'Luis', 'Trujillo', '7267 Melvin Avenue',' Heiskell' ,'TN', 37754 ,3 ),
INSERT INTO MEMBERSHIP VALUES(113, 'Minnie', 'Gonzales', '6430 Vasili Drive', 'Williston' ,'TN', 38076 ,0),
INSERT INTO RENTAL VALUES(1001,' 01-MAR-09', 103 ),
INSERT INTO RENTAL VALUES(1002, '01-MAR-09', 105),
INSERT INTO RENTAL VALUES(1003, '02-MAR-09' ,102 ),
INSERT INTO RENTAL VALUES(1004,' 02-MAR-09' ,110 ),
INSERT INTO RENTAL VALUES(1005, '02-MAR-09' ,111),
INSERT INTO RENTAL VALUES(1006, '02-MAR-09' ,107 ),
INSERT INTO RENTAL VALUES(1007, '02-MAR-09', 104),
INSERT INTO RENTAL VALUES(1008, '03-MAR-09' ,105 ),
INSERT INTO RENTAL VALUES((1009, '03-MAR-09', 111),
'
INSERT INTO DETAILRENTAL VALUES (1001, 34342, 2, ' 04-MAR-09', '02-MAR-09', 1 ),
INSERT INTO DETAILRENTAL VALUES (1001, 61353, 2, ' 04-MAR-09 ', '03-MAR-09 ', 1 ),
INSERT INTO DETAILRENTAL VALUES (1002, 59237, 3.5, '04-MAR-09 ' , '04-MAR-09 ', 3 ),
INSERT INTO DETAILRENTAL VALUES (1003 , 54325, 3.5 ,'04-MAR-09', ' '09-MAR-09', 3 ),
INSERT INTO DETAILRENTAL VALUES (1003 , 61369 ,2, '06-MAR-09', '09-MAR-09', 1 ),
INSERT INTO DETAILRENTAL VALUES (1003, 61388, 0, '06-MAR-09 ', '09-MAR-09 ', 1 ),
INSERT INTO DETAILRENTAL VALUES (1004, 44392, 3.5, '05-MAR-09', '07-MAR-09', 3 ),
INSERT INTO DETAILRENTAL VALUES (1004, 34367, 3.5 , '05-MAR-09', '07-MAR-09', 3 ),
INSERT INTO DETAILRENTAL VALUES (1004, 34341, 2, '07-MAR-09', '07-MAR-09', 1 ),
INSERT INTO DETAILRENTAL VALUES (1005 , 34342, 2 , '07-MAR-09', '05-MAR-09', 1 ),
INSERT INTO DETAILRENTAL VALUES (1005 , 44397, 3.5, '05-MAR-09', '05-MAR-09', 3 ),
INSERT INTO DETAILRENTAL VALUES (1006 , 34366 ,3.5 , '05-MAR-09', '04-MAR-09', 3 ),
INSERT INTO DETAILRENTAL VALUES (1006 , 61367, 2, '07-MAR-09', 'NULL', 1 ),
INSERT INTO DETAILRENTAL VALUES (1007, 34368 ,3.5, '05-MAR-09' , 'NULL', 3 ),
INSERT INTO DETAILRENTAL VALUES (1008, 34369, 3.5, '05-MAR-09', '05-MAR-09', 3 ),
INSERT INTO DETAILRENTAL VALUES (1009, 54324, 3.5, '05-MAR-09', 'NULL', 3 ),
INSERT INTO DETAILRENTAL VALUES (1001, 34366, 3.5 , '04-MAR-09', '02-MAR-09', 3),
INSERT INTO VIDEO VALUES ( 54321, 18-JUN-08, 1234),
INSERT INTO VIDEO VALUES ( 54324 , 18-JUN-08, 1234),
INSERT INTO VIDEO VALUES ( 54325 , 18-JUN-08, 1234),
INSERT INTO VIDEO VALUES ( 34341 , 22-JAN-07 , 1235 ),
INSERT INTO VIDEO VALUES ( 34342 , 22-JAN-07 , 1235 ),
INSERT INTO VIDEO VALUES ( 34366 , 02-MAR-09, 1236) ,
INSERT INTO VIDEO VALUES ( 34367 , 02-MAR-09 , 1236 ),
INSERT INTO VIDEO VALUES ( 34368 , 02-MAR-09, 1236 ),
INSERT INTO VIDEO VALUES ( 34369 , 02-MAR-09, 1236 ),
INSERT INTO VIDEO VALUES ( 44392 , 21-OCT-08 , 1237 ),
INSERT INTO VIDEO VALUES ( 44397 , 21-OCT-08 , 1237 ),
INSERT INTO VIDEO VALUES ( 59237, 14-FEB-09 , 1237 ),
INSERT INTO VIDEO VALUES ( 61388 , 25-JAN-07 , 1239 ),
INSERT INTO VIDEO VALUES ( 61353 , 28-JAN-06 , 1245 ),
INSERT INTO VIDEO VALUES ( 61354 , 28-JAN-06 , 1245 ),
INSERT INTO VIDEO VALUES ( 61367 , 30-JUL-08 , 1246 ),
INSERT INTO VIDEO VALUES ( 61369 , 30-JUL-08 , 1246),
INSERT INTO MOVIE VALUES (1234,The Cesar Family Christmas, 2011, 39.95, FAMILY, 2 ),
INSERT INTO MOVIE VALUES (1235 ,Smokey Mountain Wildlife,2008, 59.95, ACTION,1 ),
INSERT INTO MOVIE VALUES (1236 ,Richard Goodhope ,2012, 59.95, DRAMA, 2 ),
INSERT INTO MOVIE VALUES (1237, Beatnik Fever, 2011, 29.95, COMEDY,2 ),
INSERT INTO MOVIE VALUES (1238 ,Constant Companion, 2012 ,89.95, DRAMA,2 ),
INSERT INTO MOVIE VALUES (1239 ,Where Hope Dies ,2002, 25.49 ,DRAMA, 3 ),
INSERT INTO MOVIE VALUES (1245, Time to Burn ,2009 ,45.49, ACTION,1 ),
INSERT INTO MOVIE VALUES (1246, What He Doesn't Know ,2010 ,58.29, COMEDY,1),
INSERT INTO PRICE VALUES (1, Standard , 2 , 1 ),
INSERT INTO PRICE VALUES (2 ,New Release, 3.5 , 3),
INSERT INTO PRICE VALUES (3 ,Discount , 1.5 , 1 ),
INSERT INTO PRICE VALUES (4 ,Weekly Special, 1 , .5),
CREATE TABLE MEMBERSHIP(
MEM_NUM INT NOT NULL,
MEM_FNAME VARCHAR(30),
MEM_LNAME VARCHAR(30),
MEM_STREET VARCHAR(30),
MEM_CITY VARCHAR(30),
MEM_STATE CHAR(2),
MEM_ZIP CHAR(5),
MEM_BALANCE VARCHAR(30),
PRIMARY KEY(MEM_NUM)
);
CREATE TABLE DETAILRENTAL(
RENT_NUM INT NOT NULL,
VID_NUM INT NOT NULL,
DETAIL_FEE DECIMAL (10,2),
DETAIL_DUEDATE DATE ,
DETAIL_RETURNDATE DATE,
DETAIL_DAILYLATEFEE DEC (10,2),
FOREIGN KEY(RENT_NUM) REFERENCES RENTAL,
FOREIGN KEY (VID_NUM) REFERENCES VIDEO
);
CREATE TABLE VIDEO(
VID_NUM INT NOT NULL ,
VID_INDATE DATE,
MOVIE_NUM INT
PRIMARY KEY (VID_NUM),
FOREIGN KEY (MOVIE_NUM) REFERENCES MOVIE
);
CREATE TABLE RENTAL(
RENT_NUM INT NOT NULL ,
RENT_DATE DATE,
MEM_NUM INT NOT NULL,
PRIMARY KEY (RENT_NUM),
FOREIGN KEY (MEM_NUM) REFERENCES MEMBERSHIP
);
CREATE TABLE PRICE(
PRICE_CODE INT NOT NULL ,
PRICE_DESCRIPTION VARCHAR(50),
PRICE_RENTFEE INT,
PRICE_DAILYLATEFEE DECIMAL(10,2),
PRIMARY KEY (PRICE_CODE)
);
CREATE TABLE MOVIE(
MOVIE_NUM INT NOT NULL ,
MOVIE_TITLE VARCHAR(50),
MOVIE_YEAR SMALLINT ,
MOVIE_COST DECIMAL (8,2),
MOVIE_GENRE CHAR(30),
PRICE_CODE INT NOT NULL,
PRIMARY KEY (MOVIE_NUM),
FOREIGN KEY (PRICE_CODE) REFERENCES PRICE
);
INSERT INTO MEMBERSHIP VALUES(102, 'Tami', 'Dawson', '2632 Takli Circle', 'Norene' ,'TN' ,37136, 11 ),
INSERT INTO MEMBERSHIP VALUES(103, 'Curt', 'Knight', '4025 Cornell Court' ,'Flatgap', 'KY', 41219, 6 ),
INSERT INTO MEMBERSHIP VALUES(104, 'Jamal', 'Melendez', '788 East 145th Avenue', 'Quebeck', 'TN', 38579, 0 ),
INSERT INTO MEMBERSHIP VALUES(105, 'Iva', 'Mcclain', '6045 Musket Ball Circle', 'Summit', 'KY', 42783, 15),
INSERT INTO MEMBERSHIP VALUES(106, 'Miranda', 'Parks', '4469 Maxwell Place', 'Germantown', 'TN', 38183, 0 ),
INSERT INTO MEMBERSHIP VALUES(107, 'Rosario', 'Elliott' ,'7578 Danner Avenue' ,'Columbia', 'TN' ,38402, 5 ),
INSERT INTO MEMBERSHIP VALUES(108, 'Mattie', 'Guy', '4390 Evergreen Street', 'Lily', 'KY', 40740, 0 ),
INSERT INTO MEMBERSHIP VALUES(109, 'Clint', 'Ochoa' ,'1711 Elm Street Greeneville', 'TN', 37745, 10) ,
INSERT INTO MEMBERSHIP VALUES(110, 'Lewis', 'Rosales', '4524 Southwind Circle Counce', 'TN', 38326 ,0 ),
INSERT INTO MEMBERSHIP VALUES(111, 'Stacy', 'Mann', '2789 East Cook Avenue',' Murfreesboro' ,'TN', 37132, 8 ),
INSERT INTO MEMBERSHIP VALUES(112, 'Luis', 'Trujillo', '7267 Melvin Avenue',' Heiskell' ,'TN', 37754 ,3 ),
INSERT INTO MEMBERSHIP VALUES(113, 'Minnie', 'Gonzales', '6430 Vasili Drive', 'Williston' ,'TN', 38076 ,0),
INSERT INTO RENTAL VALUES(1001,' 01-MAR-09', 103 ),
INSERT INTO RENTAL VALUES(1002, '01-MAR-09', 105),
INSERT INTO RENTAL VALUES(1003, '02-MAR-09' ,102 ),
INSERT INTO RENTAL VALUES(1004,' 02-MAR-09' ,110 ),
INSERT INTO RENTAL VALUES(1005, '02-MAR-09' ,111),
INSERT INTO RENTAL VALUES(1006, '02-MAR-09' ,107 ),
INSERT INTO RENTAL VALUES(1007, '02-MAR-09', 104),
INSERT INTO RENTAL VALUES(1008, '03-MAR-09' ,105 ),
INSERT INTO RENTAL VALUES((1009, '03-MAR-09', 111),
'
INSERT INTO DETAILRENTAL VALUES (1001, 34342, 2, ' 04-MAR-09', '02-MAR-09', 1 ),
INSERT INTO DETAILRENTAL VALUES (1001, 61353, 2, ' 04-MAR-09 ', '03-MAR-09 ', 1 ),
INSERT INTO DETAILRENTAL VALUES (1002, 59237, 3.5, '04-MAR-09 ' , '04-MAR-09 ', 3 ),
INSERT INTO DETAILRENTAL VALUES (1003 , 54325, 3.5 ,'04-MAR-09', ' '09-MAR-09', 3 ),
INSERT INTO DETAILRENTAL VALUES (1003 , 61369 ,2, '06-MAR-09', '09-MAR-09', 1 ),
INSERT INTO DETAILRENTAL VALUES (1003, 61388, 0, '06-MAR-09 ', '09-MAR-09 ', 1 ),
INSERT INTO DETAILRENTAL VALUES (1004, 44392, 3.5, '05-MAR-09', '07-MAR-09', 3 ),
INSERT INTO DETAILRENTAL VALUES (1004, 34367, 3.5 , '05-MAR-09', '07-MAR-09', 3 ),
INSERT INTO DETAILRENTAL VALUES (1004, 34341, 2, '07-MAR-09', '07-MAR-09', 1 ),
INSERT INTO DETAILRENTAL VALUES (1005 , 34342, 2 , '07-MAR-09', '05-MAR-09', 1 ),
INSERT INTO DETAILRENTAL VALUES (1005 , 44397, 3.5, '05-MAR-09', '05-MAR-09', 3 ),
INSERT INTO DETAILRENTAL VALUES (1006 , 34366 ,3.5 , '05-MAR-09', '04-MAR-09', 3 ),
INSERT INTO DETAILRENTAL VALUES (1006 , 61367, 2, '07-MAR-09', 'NULL', 1 ),
INSERT INTO DETAILRENTAL VALUES (1007, 34368 ,3.5, '05-MAR-09' , 'NULL', 3 ),
INSERT INTO DETAILRENTAL VALUES (1008, 34369, 3.5, '05-MAR-09', '05-MAR-09', 3 ),
INSERT INTO DETAILRENTAL VALUES (1009, 54324, 3.5, '05-MAR-09', 'NULL', 3 ),
INSERT INTO DETAILRENTAL VALUES (1001, 34366, 3.5 , '04-MAR-09', '02-MAR-09', 3),
INSERT INTO VIDEO VALUES ( 54321, 18-JUN-08, 1234),
INSERT INTO VIDEO VALUES ( 54324 , 18-JUN-08, 1234),
INSERT INTO VIDEO VALUES ( 54325 , 18-JUN-08, 1234),
INSERT INTO VIDEO VALUES ( 34341 , 22-JAN-07 , 1235 ),
INSERT INTO VIDEO VALUES ( 34342 , 22-JAN-07 , 1235 ),
INSERT INTO VIDEO VALUES ( 34366 , 02-MAR-09, 1236) ,
INSERT INTO VIDEO VALUES ( 34367 , 02-MAR-09 , 1236 ),
INSERT INTO VIDEO VALUES ( 34368 , 02-MAR-09, 1236 ),
INSERT INTO VIDEO VALUES ( 34369 , 02-MAR-09, 1236 ),
INSERT INTO VIDEO VALUES ( 44392 , 21-OCT-08 , 1237 ),
INSERT INTO VIDEO VALUES ( 44397 , 21-OCT-08 , 1237 ),
INSERT INTO VIDEO VALUES ( 59237, 14-FEB-09 , 1237 ),
INSERT INTO VIDEO VALUES ( 61388 , 25-JAN-07 , 1239 ),
INSERT INTO VIDEO VALUES ( 61353 , 28-JAN-06 , 1245 ),
INSERT INTO VIDEO VALUES ( 61354 , 28-JAN-06 , 1245 ),
INSERT INTO VIDEO VALUES ( 61367 , 30-JUL-08 , 1246 ),
INSERT INTO VIDEO VALUES ( 61369 , 30-JUL-08 , 1246),
INSERT INTO MOVIE VALUES (1234,The Cesar Family Christmas, 2011, 39.95, FAMILY, 2 ),
INSERT INTO MOVIE VALUES (1235 ,Smokey Mountain Wildlife,2008, 59.95, ACTION,1 ),
INSERT INTO MOVIE VALUES (1236 ,Richard Goodhope ,2012, 59.95, DRAMA, 2 ),
INSERT INTO MOVIE VALUES (1237, Beatnik Fever, 2011, 29.95, COMEDY,2 ),
INSERT INTO MOVIE VALUES (1238 ,Constant Companion, 2012 ,89.95, DRAMA,2 ),
INSERT INTO MOVIE VALUES (1239 ,Where Hope Dies ,2002, 25.49 ,DRAMA, 3 ),
INSERT INTO MOVIE VALUES (1245, Time to Burn ,2009 ,45.49, ACTION,1 ),
INSERT INTO MOVIE VALUES (1246, What He Doesn't Know ,2010 ,58.29, COMEDY,1),
INSERT INTO PRICE VALUES (1, Standard , 2 , 1 ),
INSERT INTO PRICE VALUES (2 ,New Release, 3.5 , 3),
INSERT INTO PRICE VALUES (3 ,Discount , 1.5 , 1 ),
INSERT INTO PRICE VALUES (4 ,Weekly Special, 1 , .5),
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started