Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 (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 forStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started