EEN523 Fourth Assignment

Due Tuesday 13th April 1999

(This is really part 2 of the third assignment).

Implement in SQL the database that you designed for the previous assignment. It is quite likely that you will find you have to make small changes to the design. That's OK; just document them. If you make a major change, turn in a new ER diagram. We want a complete product at the end.

Remember that you each have a personal database, whose name is your own username. Don't try modifying the class database.

1. Turn in the SQL commands used to create the tables ansd any required indexes.

2. Turn in a not-too-large sample of the SQL commands you used to populate your tables with test data. You do not need to waste hours typing in a very large amount of test data, you can write a program that generates it randomly; just make sure the generated data is reasonably realistic. If you are not confident that you can do that, I'll make the C programs that I used to populate the airline database publicly available.

3. Think up a selection of reasonable queries to test your system. Include at least enough to test all of the relations (diamond shapes) that appeared in your ER diagram effectively. Write the queries in SQL and type them in. Turn in those queries and the results.

You do not need to write any programs for this assignment. That is the next stage.