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:

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