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.

• 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.