CIS 111 STUDY Extraordinary Life/cis111study.com CIS 111 STUDY Extraordinary Life/cis111study.com | Page 9

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

=================================================== CIS 111 Week 5 Lab 3 EasyPHP and MySQL Setup FOR MORE CLASSES VISIT www . cis111study . com

Lab 3 : EasyPHP and MySQL Setup