CIS 111 STUDY Great Stories/cis111study.com CIS 111 STUDY Great Stories/cis111study.com | Page 13

For each instructor, the college needs to track the instructor ID,
name, address, 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.
Section 1: Modified Visio Diagram
(Microsoft Visio or equivalent)
Use Microsoft Visio (or open source equivalent) in which you:
Modify the database diagram from Lab 1 with the entities and
attributes that the scenario identified (i.e., a college tracking
students, courses, and instructors).
Create the appropriate relationships between each entity within the
diagram.
===================================================