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 analystdata 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 entityrelationship 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 SDLCYou are also allowing some relationships to remain manytomany at this stage without further normalization.Requirements Determine the data entities.During requirements analysis, you determined there are four main entities: students, instructors, schedules of students, and courses.
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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
