Question: As a database analyst / data modeler, you are hired as part of a team of analysts by a university to create a conceptual data

As a database analyst/data modeler, you are hired as part of a team of analysts by a university to create a conceptual data model of its student registration system. You decided to use a very common data modeling tool, an entity-relationship diagram (ERD). The model contains entities in the environment, the relationships or associations among those entities, and the attributes or properties of both the entities and their relationships. With your focus on the logical design of the data model, you are concentrating on the entities and their relationships at this moment during the analysis phase of the SDLC.(You are also allowing some relationships to remain many-to-many at this stage without further normalization.)Requirements 1.) Determine the data entities.During requirements analysis, you determined there are four main entities: students, instructors, schedules of students, and courses.
2.) Generate a list of potential entity pairings.
-Students to instructors
-Students to their schedules
-Instructors to courses
-Schedules of students to courses
-The current system does not include detailed instructor information (for example, instructor name) to be included on the schedule.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!