Scenario

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.

Instructions for the Database Design Diagram

Use any drawing package or any other application you know such as Visio, Word, PowerPoint, or another tool to create the Database Design Diagram. Otherwise, you may draw the diagram by hand with a pen and paper. If you draw the diagram by hand, then take one or more pictures of the diagram with your cell phone or laptop camera, place the images into a Word document, and submit the document. Otherwise, if you use software to create the Database Design Diagram, then take one or more screen captures of the diagram, place the screen captures into a Word document, and submit the document. Submissions that are not in $.$doc or $.$docx format will not be graded.

Include the following in the document:

Draw the entities of the database and the attributes of each entity, based on your research and$/$or common knowledge of a college and the information tracked by a college.

Create the appropriate relationships between each entity within the diagram.

Describe any assumptions that you had to make about the business rules in order to create the diagram and the associated relationships.

This course requires the use of Strayer Writing Standards $($SWS$).$ The library is your home for SWS assistance, including citations and formatting. Please refer to the Library site for all support. Check with your professor for any additional instructions.

The specific course learning outcome associated with this assignment is:

Draw a database design diagram that depicts the attributes and relationships of the entities.