Write SQL CREATE statements that will create a simple database consisting of three tables and their relationships.

Description

Write a series of three SQL statements to create a database consisting of the tables shown on page 71 of your text. A description of what needs to be included in the CREATE statements is given in problems 1 through 6 on that same page.

Note that you do NOT need to submit a relation diagram as described in Problem #4 although it may be helpful to draw one to give you a better idea of the required relationships.

Your output will consist of a text file containing three CREATE TABLE statements in format similar to that of the "CREATE TABLE Offering" example on page 52 of your text.

Note that these CREATE TABLE statements don't need to be specific to any DBMS, although those of you familiar with a DBMS can certainly use it to test them. The purpose of the assignment is to take a look at the SQL syntax required to create tables and relationships, without having to worry about learning how to use a DBMS environment.

Place the three CREATE TABLE statements in a single text file named CS2550A01.txt  and upload the file using the Assignment uploader.