Question: Write a sql script, rentals.sql that builds a database of four tables: Customers, Movies, Games, and Rentals. Customers has fields of name, id, and credit

Write a sql script, rentals.sql that builds a database of four tables: Customers, Movies, Games, and Rentals. Customers has fields of 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 name and rentalcode. The script should populate the Movies and Games tables. The remaining tables will be populated with user input when the program runs.

Use the following movie and game information:

Write a sql script, rentals.sql that builds a database of four tables:

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

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!

*Lab 6 is there in case you don't know what "Lab 7" instructions are referring to when they say" Lab 6." Lab 7 is the one that needs to be done. Lab 7: Inserting and Updating Data OVERVIEW This lab...

Lab 7: Inserting and Updating Data OVERVIEW This lab provides you the opportunity to insert and update data with the use of SQL commands. The lab will utilize the FLIX2YOU problem, the current...

OVERVIEW This lab provides you the opportunity to create tables, primary keys and foreign keys with the use of SQL commands. The lab will utilize the FLIX2YOU problem. In the FLIX2YOU product...

This practice lab provides you the opportunity to create tables, primary keys and foreign keys with the use of SQL commands. The lab will utilize the FLIX2YOU problem. (In Microsoft SQL studio) In...

This lab provides you the opportunity to insert and update data with the use of SQL commands. The lab will utilize the FLIX2YOU problem, the current schema. In order to start this lab, you must have...

This SQL project in three Phases and the instruction as below: Instructions Follow the steps and let me know if you have any questions. The intent of the project is to create a project you can use in...

And Below is the script provided /* Modifications: (1) Removed DELETE FROM and RESEED commands from script; 1/3/13 by glh */ /* PLEASE READ THE INSTRUCTIONS FOR LAB # 7 BEFORE EXECUTING */ /* Insert...

OVERVIEW This lab provides you the opportunity to create tables, primary keys and foreign keys with the use of SQL commands. The lab will utilize the FLIX2YOU problem. In the FLIX2YOU product...

There are two problems due this week (each worth 35 points) as follows. Case 5-1David L. Miller: Portrait of a White-Collar Criminal (page 144). In comprehensive paragraphs, answerrequirements 1?6....

This practice lab provides you the opportunity to insert and update data with the use of SQL commands. The lab will utilize the FLIX2YOU problem, the current schema. In order to start this lab, you...

Hartl Enterprises issued ten $1,000 bonds on September 30, 2014, with a stated annual interest rate of 8 percent. These bonds will mature on October 1, 2024, and have an effective rate of 10 percent....

Mendota Foods sells a variety of food products around the world. The company engags directly with individuals with an Interest in cooking by offering ideas and recipes in various staff blogs and...

Which of the following statements is are true if the strong form efficient market hypothesis holds? 1 - Analyst can easily forecast stock price changes 2 - Financial markets are irrational 3 - stock...

5. Develop a scenario comparing two PH programs and involving the use of a CBA.

8-10 This project uses spreadsheet software to calculate anticipated annual losses from various security threats identified for a small company. Mercer Paints is a paint manufacturing company located...

8-8 Gifty is an online e-tailer for handmade gifts. Customers can purchase either via its Web site or via a mobile app. Prepare a security analysis for this Internet-based business. What kinds of...

8-16 Describe some of the weaknesses exploited by malware The IT sector is one of the key drivers of the European economy. It has been estimated that 60 percent of Europeans use the Internet...