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.

I want you to design a relational database. For students who know someone else in the course, I want you to setup a group to discuss it with (max four per group). The group can submit the design. I will get back to you if I see a problem and you can then resubmit. For students who do not know someone else in the class I am your group. Send me your thoughts and I will get back to you. Students can also try to establish a discussion on the board.

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.