CIS 111 STUDY Learn Do Live /cis111study.com CIS 111 STUDY Learn Do Live /cis111study.com | Page 9

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, h ome,
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.
===================================================
CIS 111 Week 5 Lab 3 EasyPHP and MySQL Setup
FOR MORE CLASSES VISIT
www.cis111study.com
Lab 3: EasyPHP and MySQL Setup