Course list http://www.c-jump.com/bcc/

SQL Database Midterm Project

1. Testing the College Database
2. Requirements
3. How to Submit

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)

   

Requirements

1. 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.

2. Insert 4 or more records into the Student table.

3. 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.

4. Add a few (4 or more) records into the Course table.

5. Add one more record to the Department table.

6. Insert a chairperson record for the new department into the Instructor table.

7. Go back to the Department record and update the ChairID field.

8. 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.

9. Add 1-2 sections for every course. At least 2 courses should have more than one section.

10. Enroll each one of the students in 2 or more sections.

11. For every table in the database, type in and save the corresponding DROP TABLE query.

     

How to Submit

• Make sure you save everything and close Access program entirely before submitting the homework.

• For the best results, add your database file to a ZIP archive prior to submitting. For example, on most systems you should be able to

  • Open Windows Explorer

  • Locate the College db file

  • Right-click the db file icon and click "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.

• Submit your ZIP file via attachment emailed to your instructor:
  Igor Kholodov Igor.Kholodov@bristolcc.edu

• Use proper email subject line:

          CIT122 Midterm Lastname, Firstname
  

• It's okay to use yahoo, gmail, or any other webmail account.

• As a general rule, your email must contain your last name (mandatory!) and first name (or at least the first name initial.)