I want you to design this database and get my check off for it before you implement it in Access. This week is design only! Please send me a document at my email address.

The college needs to set up a database to contain information about students.  The information they need is as follows:

Student id number

Student name

Student address

Student GPA

Student major code

Major name

Advisor to major

Course id number (one for each course the student has taken or is taken)

For each course: (in addition to the course id number )

• Course name
• Number of credits for course
• Semester and year the student took the course
• Grade student got in the course

If you think I am missing something, you may add it and tell me your reason.

Design the normalized database.  You should tell me what tables you are going to use, what the key is on each table (remember a key can be made up of multiple fields), and how the tables can be related to each other so I can get data from multiple tables.