A mini project: Design a database application in a university based on the specifications below. You are required to:

1. Do all the database designs starting from the conceptual level.
2. Construct the corresponding simplified university database using Microsoft Access 97 that reflects the corresponding relational schema with keys and relationships (foreign keys) defined.
3. Enter some sample data into the database.
4. Write a simple program in C/C++ to generate a transcript of students by using the ODBC interface. The input of such program is the social security number of the student, and the output is a transcript report (a txt file), including: the SSN and name of the student, the student's major department, all the courses the student has taken and the final grade for each course enrollment.

The transcript report can be in the format (or other appropriate format):
SSN of the STUDENT: XXXXXXX
Name of the STUDENT:  XXXXXX
COURSES       Grade
XXXXXX        XX
XXXXXX        XX
XXXXXX        XX
...                    ...

While XXXX stands for the possible information of certain student.
 

Make sure your design includes at least the following information: Students, Courses, Instructors, Assignments, Departments, Textbooks, and Classrooms.
1.  Each student has a social security number and a name, and s/he should major in one and only one department.
2.  Each instructor has a social security number and a name, and s/he can work in different departments in parallel.
3.  Each department has a name and may offer a set of courses.
4.  A TA is both a student and an instructor.
5.  Each course can be handled by more than one instructors including TA.
6.  Each assignment has an assignment number and the due date. However, the number is unique only within one particular course.
7.  For each student-assignment pair a grade is recorded.
8.  The students are allowed to take many courses, and each course can be taken by many students. For each student-course pair a grade is recorded.
9.  Each Course has a unique course number and a course name, and it is assigned only one classroom and only one textbook.
10. There is a need to record the name, publisher and the published year of a textbook in the database.
11. The classroom is identified by the building and the room number.

Please hand in:
1. A hardcopy of the document describing your design. The document should at least include: E-R diagram, Relational Schema and proper constraints.
2. A floppy disk with a Microsoft Access database file ( *.mdb) with some sample data entered.
3. Please use the your SSN as the file name (xxx_xx_xxxx.mdb).
4. Please also include your C/C++ file in the floppy disk as well as a sample transcript report (in txt format) that matches the data stored in your sample database.
5. Please use your SSN as the file name (xxx_xx_xxxx.cpp or xxx_xx_xxxx.txt)
6. Please don't forget to have your SSN written on the hardcopy document.