The following tables provide a very small portion of the data that will be kept in the database. The data needs to be inserted into the database for testing purposes. Write the INSERT commands necessary to place the following data in the tables that were created in item #1. Make sure there are no errors when the script is executed. If it does, you will automatically get a zero for this item.
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
The following tables provide a very small portion of the data that will be kept in the
![DETAILRENTAL
RENT
VID NUM
DETAIL FEE
DETAIL DUEDATE
DETAIL RETURNDATE
DETAIL
NUM
DAILYLATEFEE
1001
34342
2
04-MAR-16
02-MAR-16
1001
61353
04-MAR-16
03-MAR-16
1002
59237
3.5
04-MAR-16
04-MAR-16
1003
54325
3.5
04-MAR-16
09 MAR-16
3
06-MAR-16
06-MAR-16
1003
61369
2
09-MAR-16
1
1003
61388
09-MAR-16
1004
44392
3.5
05-MAR-16
07-MAR-16
1004
34367
3.5
05-MAR-16
07-MAR-16
3
1004
34341
2
07-MAR-16
07-MAR-16
1
1005
34342
2
07-MAR-16
0S-MAR-16
1005
44397
3.5
05-MAR-16
05-MAR-16
3.
1006
34366
3.5
05-MAR-16
04-MAR-16
1006
61367
07-MAR-16
1007
34368
3.5
05-MAR-16
1008
34369
3.5
05-MAR-16
05-MAR-16
3.
1009
54324
3.5
05-MAR-16
1001
34366
3.5
04-MAR-16
02-MAR-16
3.
VIDEO
VID NUM
VID INDATE
MOVIE NUM
54321
18-JUN-15
1234
54324
18-JUN-15
1234
54325
18-JUN-15
1234
34341
22-JAN-14
1235
34342
22-JAN-14
1235
34366
02-MAR-16
1236
34367
02-MAR-16
1236
34368
02-MAR-16
1236
34369
02-MAR-16
1236
44392
21-оСТ-15
1237
44397
21-OCT-15
1237
59237
14-FEB-16
1237
61388
25-JAN-14
1239
28-JAN-13
28-JAN-13
61353
1245
61354
1245
61367
30-JUL-15
1246
61369
30-JUL-15
1246](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F61b6351a-082d-46cc-8971-bc300a8a8cb9%2F60d22286-5207-4e91-b8c3-0e3e3b76f9c8%2Foxfph0c_processed.png&w=3840&q=75)
![MEMBERSHIP
MEM
MEM
MEM
LNAME
MEM STREET
MEM CITY MEM
STATE
MEM
ZIP
MEM
NUM
FNAME
BALANCE
Dawson
Knight
Melendez
Mcclain
Parks
Tami
2632 Takli Circle
Norene
Flatgap
788 East 145th Avenue Quebeck
102
TN
37136
11
103
Curt
4025 Cornell Court
KY
41219
104
Jamal
TN
38579
105
Iva
6045 Musket Ball Circle Summit
KY
42783
15
Germantown TN
Columbia
Lly
Greeneville
Counce
2789 East Cook Avenue Murfreesboro TN
Heiskell
Williston
106
Miranda
4469 Maxwell Place
38183
107
Rosario
Eliott
7578 Danner Avenue
TN
38402
4390 Evergreen Street
1711 Elm Street
4524 Southwind Cecle
Mattie
KY
Guy
Ochoa
Rosales
Mann
Trujilo
Gonzales
108
40740
109
Clint
TN
37745
10
Lewis
Stacy
Luis
110
TN
38326
111
37132
8.
7267 Melvin Avenue
6430 Vasili Drive
112
TN
37754
3
113
Minnie
TN
38076
RENTAL
RENT NUM
RENT DATE
MEM NUM
1001
01-MAR-16
103
1002
01-MAR-16
105
1003
02-MAR-16
102
1004
02-MAR-16
110
1005
02-MAR-16
111
1006
02-MAR-16
107
1007
02-MAR-16
104
1008
03-MAR-16
105
1009
03-MAR-16
111
MOVIE
MOVIE MOVIE TITLE
MOVIE YEAR
MOVIE COST MOVIE GENRE PRICE CODE
NUM
The Cesar Family Christmas 2014
Smokey Mountain Widife 2011
Richard Goodhope
Beatnik Fever
Constant Companion
Where Hope Dies
Time to Burn
What He Doesn't Know
39.95
FAMILY
1234
1235
59 95
ACTION
1
1236
2015
59.95
DRAMA
1237
2014
29.95
COMEDY
1238
2015
89.95
DRAMA
1239
2005
25.49
DRAMA
2012
45.49
58.29
1245
ACTION
1246
2013
COMEDY
1
PRICE
PRICE_CODE
PRICE DESCRIPTION
PRICE RENTFEE
PRICE DAILYLATEFEE
Standard
2
2
New Release
3.5
3
Discount
1.5
4
Weekly Special](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F61b6351a-082d-46cc-8971-bc300a8a8cb9%2F60d22286-5207-4e91-b8c3-0e3e3b76f9c8%2Fa4hpfcf_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![New Perspectives on HTML5, CSS3, and JavaScript](https://www.bartleby.com/isbn_cover_images/9781305503922/9781305503922_smallCoverImage.gif)
![New Perspectives on HTML5, CSS3, and JavaScript](https://www.bartleby.com/isbn_cover_images/9781305503922/9781305503922_smallCoverImage.gif)