Movie Theater Database: SQL Commands
Write the SQL Data Definition Language (DDL) commands to create the movie theater database based upon the below Entity Relationship Model (ERM). Be sure to include commands to create tables, fields, keys, and relationships. Write your commands in a Microsoft Word document. Your final submission will be a Microsoft Word document.
|
Movies
|
|
Movie ID
|
Movie Name
|
|
13762
|
Forrest Gump
|
|
17698
|
The Shawshank Redemption
|
|
19868
|
A Few Good Men
|
|
12987
|
The Godfather
|
|
Theaters
|
|
Theater_ID
|
Theater Name
|
|
103
|
Cine 20 West
|
|
105
|
Screen 12 North
|
|
107
|
Filmology 8
|
|
MovieTimes
|
|
Movie ID
|
Theater_ID
|
Movie Time
|
|
13762
|
103
|
7:00 PM 2/5/2013
|
|
17698
|
105
|
7:05 PM 3/6/2014
|
|
19868
|
103
|
9:00 PM 1/15/2015
|
|
12987
|
107
|
7:00 PM 2/14/2016
|