Database diagram Solution

Suppose a local college has tasked you to develop a database that they want:

-For each student, the college needs to track the student ID, student names, addresses, start date, phone numbers and types (such as mobile, home, work), email addresses and types (such as personal, school, work), gender and birth date

-For each course, the college needs to track the course ID, course name, department, quarter offered, sections and instructor teaching each course.

-For each instructor, the college needs to track the instructor ID, name, addresses, phone numbers and types (such as mobile, home, work), email addresses and types (such as personal, school, work), gender, birth date and the courses that each instructor is qualified to teach.

-Additionally, the college needs to track the final grades for each student after each course has completed.

Use Microsoft Visio in which you create the database diagram with the entities and attributes that the scenario identified (ie- college tracking students, courses and instructors) and create the appropriate relationships between each entity within the diagram. 

In addition, discuss the degree to which you believe the Visio diagram reflects the database design. Also describe any assumptions that you had to make about the business rules in order to create the Visio diagram and the associated relationships.