Create the database to store information for a university of your choosing. After initial design meetings with your client, the following business rules have been determined. A student has a name, a birth date, and gender.
You must track the date the student started at the university and his or her current GPA, as well as be able to inactivate him or her without deleting information.
For advising purposes, store the student's background/bio information. This is like a little story.
An advisor has a name and an e-mail address.
Students are assigned to one advisor, but one advisor may service multiple students.
A class has a class code, name, and description.
You need to indicate the specific classes a student is taking/has taken at the university. Track the date the student started a specific class and the grade earned in that class