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.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
icon
Concept explainers
Question
100%

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.

 

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
Transcribed Image Text: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
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
Transcribed Image Text: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
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Query Syntax
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education