preview

StudyModeUpload

Better Essays
Open Document

Homework Assignment #4 Problems #65 - #94 from page 311. Please provide your answer after each problem and submit the file with your answers through Blackboard. EliteVideo is a startup company providing concierge DVD kiosk service in upscale neighborhoods. EliteVideo can own several copies (VIDEO) of each movie (MOVIE). For example, the store may have 10 copies of the movie “Twist in the Wind”. “Twist in the Wind” would be one MOVIE and each copy would be a VIDEO. A rental transaction (RENTAL) involves one or more videos being rented to a member (MEMBERSHIP). A video can be rented many times over its lifetime, therefore, there is a M:N relationship between RENTAL and VIDEO. DETAILRENTAL is the bridge table to resolve this …show more content…

ES(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 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 Feaver',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 VIDEO VALUES(54321,'18-JUN-12',1234); INSERT INTO VIDEO VALUES(54324,'18-JUN-12',1234); INSERT INTO VIDEO VALUES(54325,'18-JUN-11',1234); INSERT INTO VIDEO VALUES(34341,'22-JAN-11',1235); INSERT INTO VIDEO VALUES(34342,'22-JAN-11',1235); INSERT INTO VIDEO VALUES(34366,'02-MAR-13',1236); INSERT INTO VIDEO VALUES(34367,'02-MAR-13',1236); INSERT INTO VIDEO

Get Access
Related
Get Access