CIS 111 Week 4 Lab 2 Modifying a Database Design in Visio CIS 111 Week 4 Lab 2 Modifying a Database Design i | Page 2

For each course, the college needs to track the course ID, course name, department, quarters
offered, sections, and instructor teaching each course.
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.
Section 1 of your assignment must follow these formatting requirements:
Submit the Visio diagram as a Visio file.
Section 2: Design Summary
(Microsoft Word or equivalent)
Write a one to two (1-2) page paper in which you:
Discuss the degree to which you believe the Visio diagram reflects the database design.
Describe any assumptions that you had to make about the business rules to in order to create
the Visio diagram and the associated relationships.
Section 2 of your assignment must follow these formatting requirements: