Movie mID title year director Gonewith the Wind 1939 Victor Fleming 1977 George Lucas The Sound of Music 1965 Robert Wise 1982 Steven Spielberg 101 102 Star Wars 103 104 E.T. 105 1997 James Cameron Titanic 106 Snow White 1937

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
Question

Create SQL tables with these charts

Movie
mID
title
year
dir ector
|
1939 Victor Fleming
1977 GeorgeLucas
101
Gonewith the Wind
102
Star Wars
The Sound of Music 1965 Robert Wise
1982 Steven Spielberg
1997 James Cameron
103
104
E.T.
105
Titanic
106
Snow White
1937
<null>
107
Avatar
2009 James Cameron
108 Raiders of the Lost Ark 1981 Steven Spielberg
Reviewer
Rating
rID mID stars ratingDate
201 101 2
rID
name
201 Sarah Martinez
22-JAN-11
201 101
202
Daniel Lewis
4
27-JAN-11
203 Brittany Harris
202 106
4
<null>
203 103 2
20-JAN-11
204 Mike Ander son
205 Chris Jackson
203 108
12-JAN-11
4
206 Elizabeth Thomas
203 108
2
30-JAN-11
207 James Cameron
204 101 3
09-JAN-11
205 103 3
208
Ashley White
27-JAN-11
205 104 2
22-JAN-11
205 108
<null>
4
206 107
206 106 5
207 107 5 20-JAN-11
3
15-JAN-11
19-JAN-11
208 104
3
02-JAN-11
Transcribed Image Text:Movie mID title year dir ector | 1939 Victor Fleming 1977 GeorgeLucas 101 Gonewith the Wind 102 Star Wars The Sound of Music 1965 Robert Wise 1982 Steven Spielberg 1997 James Cameron 103 104 E.T. 105 Titanic 106 Snow White 1937 <null> 107 Avatar 2009 James Cameron 108 Raiders of the Lost Ark 1981 Steven Spielberg Reviewer Rating rID mID stars ratingDate 201 101 2 rID name 201 Sarah Martinez 22-JAN-11 201 101 202 Daniel Lewis 4 27-JAN-11 203 Brittany Harris 202 106 4 <null> 203 103 2 20-JAN-11 204 Mike Ander son 205 Chris Jackson 203 108 12-JAN-11 4 206 Elizabeth Thomas 203 108 2 30-JAN-11 207 James Cameron 204 101 3 09-JAN-11 205 103 3 208 Ashley White 27-JAN-11 205 104 2 22-JAN-11 205 108 <null> 4 206 107 206 106 5 207 107 5 20-JAN-11 3 15-JAN-11 19-JAN-11 208 104 3 02-JAN-11
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Multiple table
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.
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