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