Menu
support@nursinghomework.org
+1 714-215-3097

(Solved) : Write Sql Script Rentalssql Builds Database Four Tables Customers Movies Games Rentals Cus Q35578580

Write a sql script, rentals.sql that builds a database of fourtables: Customers, Movies, Games, and Rentals. Customers has fieldsof name, id, and credit card. Movies has fields of title,rentalcode, price, type and isavailable. Games has fields of title,rentalcode, price, type and isavailable. Rentals has fields nameand rentalcode. The script should populate the Movies and Gamestables. The remaining tables will be populated with user input whenthe program runs.

Use the following movie and game information:

Rental Data: Movie,Titanic,1A,4.99,BLURAY Movie,Star Wars,2C,5.99,DVD Game,Warcraft,5D,3.99,PLAYSTATION Game Tomb Raider,12F,

Rental Data: Movie,Titanic,1A,4.99,BLURAY Movie,Star Wars,2C,5.99,DVD Game,Warcraft,5D,3.99,PLAYSTATION Game Tomb Raider,12F,3.59 NINTENDO Movie,Raiders of the Lost Ark,12T,1.79,BLURAY Movie,Split,8R,2.59,BLURAY Game Call of Duty,2G,5.99,XBOX Movie,Sixth Sense,4D,3.25,DVD Game.Lego Jurassic World,9Q,2.25,PLAYSTATION Movie,Avengers,9Y,1.59,DVD Game,Fallout,7W,1.49,NINTENDO Movie,Titanic,1AD,4.99,DVD Movie Sixth Sense,4DB,3.25,BLURAY Show transcribed image text Rental Data: Movie,Titanic,1A,4.99,BLURAY Movie,Star Wars,2C,5.99,DVD Game,Warcraft,5D,3.99,PLAYSTATION Game Tomb Raider,12F,3.59 NINTENDO Movie,Raiders of the Lost Ark,12T,1.79,BLURAY Movie,Split,8R,2.59,BLURAY Game Call of Duty,2G,5.99,XBOX Movie,Sixth Sense,4D,3.25,DVD Game.Lego Jurassic World,9Q,2.25,PLAYSTATION Movie,Avengers,9Y,1.59,DVD Game,Fallout,7W,1.49,NINTENDO Movie,Titanic,1AD,4.99,DVD Movie Sixth Sense,4DB,3.25,BLURAY

Leave a Reply

Your email address will not be published. Required fields are marked *