Writing SQL tables.

Consider the relational database described in Tables 1- 3. The bold attribute(s) is the primary key for a table.

Make sure you include the primary key and foreign key constraints. Put check constraints on the following three attributes: Rating (between 0 and 10), Length (greater than 0), ReleaseDate (after 1/1/1900).

Table 1: Theatres

Name | City | State | Zip | Phone

Table 2: Movies

Title | Rating | Length | ReleaseDate

Table 3: ShownAt

TheatreName | MovieTitle