This assignment contains two ( 2 ) Sections : Visio Diagram and Design Summary . You must submit both sections as separate files in order to complete this assignment .
Use “ Appendix A : Designing Databases with Visio Professional : A Tutorial ,” located in the online course shell to help you complete Section 1 : Visio Database Design . ( Note : This tutorial focuses on the use of Microsoft Visio . Open source applications are not covered in Appendix A ; however , the use of open source applications within labs is permitted .)
Use the scenario from Assignment 1 : Business Rules and Data Models to complete the lab :
Suppose a local college has tasked you to develop a database that will keep track of students and the courses that they have taken . In addition to tracking the students and courses , the client wants the database to keep track of the instructors teaching each of the courses .
Section 1 : Visio Diagram ( Microsoft Visio or equivalent )
1 . Use Microsoft Visio ( or open source equivalent ) in which you :
1 . Create a database diagram with the entities and attributes that the scenario identified ( i . e ., a college tracking students , courses , and instructors ).
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 )