Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Suppose we want to create an E-R diagram to represent the following information: Students take exams held on certain dates (day, month, year). Each exam

image text in transcribed
Suppose we want to create an E-R diagram to represent the following information: Students take exams held on certain dates (day, month, year). Each exam has a name, total points for that exam, and the points that a student received. Each exam is associated with a course, and a course has an ID and a title. 1. What are the entity sets for the above information? For each entity set, state its name, attributes, and the primary key. 2. What are the relationship sets for the above information. For each relationship, state the entities that participate in the relationship and its degree. Also state the attributes for each relationship, if any. 3. Suppose a student can take each exam multiple times on different dates, and the data about each attempt -- date when the exam was taken, and the points earned by the student, must also be stored. How will the entity and relationship sets change to support this requirement

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_2

Step: 3

blur-text-image_3

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

Computer Aided Database Design

Authors: Antonio Albano, Valeria De Antonellis, A. Di Leva

1st Edition

0444877355, 978-0444877352

More Books

Students also viewed these Databases questions