tasked with creating 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

tasked with creating 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. Each class that a student takes has 4 assignments. Each assignment is worth 100 points. The following entity tables have been composed:

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>