Assignment a4: Midterm Project -- Testing the College Database

Our midterm project is to create a "sandbox" database.
Upon completion of this assignment, each student will have a testing ground for the future assignments, which involve running SELECT queries against College Database tables.
To begin, create a new database as described in SQL 101 Homework or open an existing database. Be sure to save your file under a meaningful name, similar to "College.accdb" (or "College.mdb" if using Access 2003)

Follow step-by-step instructions outlined in the Database Implementation handout and create tables described by the College database model.
- Note: when instructed to insert records into a database table, you can write either a SQL INSERT query to do the work, or just open the table in datasheet view and enter the records by typing them in manually.
For every table in the database, type in and save the corresponding DROP TABLE query. (Do not run DROP TABLE queries. If you do, make sure you re-create your tables and populate them with data as described below.)
Insert 4 or more records into the Student table.
Insert additional periods into the Schedule table. Make it look more or less realistic with a few periods (2, 3, or more) available for at least three weekdays, Monday, Tuesday, and Wednesday.
Add a few (4 or more) records into the Course table.
Add one more record to the Department table.
Insert a chairperson record for the new department into the Instructor table.
Go back to the Department record and update the ChairID field.
Add a few more instructors to the Instructor table. Make sure that each department has:
- one chairperson
- two or more instructors
- each department should have at least one Adjunct instructor.
Add 1-2 sections for every course. At least 2 courses should have more than one section.
Enroll each one of the students in 2 or more sections.

Make sure you save everything and close Access program entirely before submitting the homework.
Submit your database file -- "accdb" (or "mdb" if you using Access 2003.) Consider placing your file into a ZIP archive and submitting the ZIP file. This might save space on your own drive: the ZIP file could be considerably smaller size. One way to create a ZIP file is to
- Open Windows Explorer
- Locate the College database file
- Right-click the db file icon and choose "Send To" -> "Compressed (zipped) folder."
- This will create a ZIP file in the same folder where the Access database file is stored on your computer.
To submit, open your browser and go to CIT-122 online website.
On the Main Menu, follow the link to Submit Homework, select Assignment a4, and upload your file.