CIS 363 Lab Assignement #2

Due: 2/10/2010 by end of lab at 8:50PM.

Think about a database to represent a typical college registration system.  You have students, teachers, classes available, classes registered by students.  

Identify all the tables necessary to represent college registration.  Also identify all the relationships, remember you have one to one, one to many and many to many.  

Write and turn in all the CREATE TABLE commands to create the above tables and relationships.

Refer back to the Doctor/Patient sample for reference