Question: Create an ERD model representing the data above. Conceptual Data Modeling (ERD). Consider the following situation We need to keep track of students, the courses

 Create an ERD model representing the data above. Conceptual Data Modeling

Create an ERD model representing the data above.

Conceptual Data Modeling (ERD). Consider the following situation We need to keep track of students, the courses they are enrolled in, and the grades they are earning. Specifically, students are uniquely identified by a S# and we need to record each student's name. GPA the courses enrolled, and the grades earned. Students are allowed to major in multiple disciplines. Each discipline is identified by a code and has a description (e.g.. major code 17 identifies MIS). We need to keep track of each student's major(s). A course is offered in many sections (each identified by a section#) and we need to keep track of the meeting time (e.g., MWF 1:20-2:27), the room number (e.g., PH302). and the instructor of record for the section. Instructors are identified by their employee id and we need to keep track of the instructor's name, date of hire, and the classes they teach. Each section belongs to one course about which we need to record the course number (used to identify each course) along with the course name and its credit hours. An important goal of this database is to allow the production of Progress Report Cards such as shown below in addition to standard reports listing Roster of students for each section an instructor is responsible for. Give the ERD representing the logical data model that best captures database requirements for this scenario. Make sure to underline the primary key for each entity. Make sure to name each relationship. Make sure to indicate the 1-to-m or m-to-m nature of each relationship. Do not introduce attributes that the above design specification is not asking for

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 Databases Questions!