Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Development For Dummies

Authors: Allen G. Taylor

1st Edition

978-0764507526

More Books

Students also viewed these Databases questions

Question

What is the basis for Security Concerns in Cloud Computing?

Answered: 1 week ago

Question

Describe the three main Cloud Computing Environments.

Answered: 1 week ago