Logical Design and ImplementationPhase
Due: April 15
For this portion of the project you may use either Access or MySQL.
Create the tables for the relations in your relational database. Make sure you define all domains as well as you can.
Link all tables by connecting foreign keys to primary keys. Be careful if you are using MySQL, not all engines allow foreign keys - pick one that does.
If you are using Access, hand in a CD/flash drive containing ONLY your database. This would include your saved queries.
If you are using MySQL, hand in a CD/flash drive containing ONLY a dump of your database. This dump will give the CREATE and INSERT commands to create your database.
For each relation give (this part has to be hard copy):
Choose any 8 queries from your original list. Implement these.
If you are using Access please save them as part of your database. It really helps if you name them Q1, Q7, etc. so that they match with your original query list.
If you are using MySQL, print screen shots showing your queries and the results of executing your queries. Include this as part of the hard copy portion that you turn in.