Construct an E-R diagram for a car insurance company whose customers own one or more cars each. Each car has associated with it zero to any number of recorded accidents. Each insurance policy covers one or more cars and has one or more premium payments associated with it. Each payment is for a particular period of time, and has an associated due date, and the date when the payment was received.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
(D Page view IA Read aloud
V Draw
6.20 Construct appropriate relation schemas for each of the E-R diagrams in:
a. Exercise 6.1.
b.
Exercise 6.2.
c.
Exercise 6.3.
d. Exercise 6.15.
Construct an E-R diagram for a car insurance company whose customers own
one or more cars each. Each car has associated with it zero to any number of
recorded accidents. Each insurance policy covers one or more cars and has one
6.1
or more premium payments associated with it. Each payment is for a particular
period of time, and has an associated due date, and the date when the payment
was received.
6.2 Consider a database that includes the entity sets student, course, and section
from the university schem, and that additionally records the marks that students
receive in different exams of different sections.
Construct an E-R diagram that models exams as entities and uses a ternary
relationship as part of the design.
a.
Construct an alternative E-R diagram that uses only a binary relationship
between student and section. Make sure that only one relationship exists
between a particular student and section pair, yet you can represent the
marks that a student gets in different exams.
b.
Design an E-R diagram for keeping track of the scoring statistics of your favorite
sports team. You should store the matches played, the scores in each match, the
players in each match, and individual player scoring statistics for each match.
Summary statistics should be modeled as derived attributes with an explanation
as to how they are computed.
6.3
Construct an E-R diagram for a hospital with a set of patients and a set of med-
ical doctors. Associate with each patient a log of the various tests and examina-
6.15
tions conducted.
W
hp
Transcribed Image Text:(D Page view IA Read aloud V Draw 6.20 Construct appropriate relation schemas for each of the E-R diagrams in: a. Exercise 6.1. b. Exercise 6.2. c. Exercise 6.3. d. Exercise 6.15. Construct an E-R diagram for a car insurance company whose customers own one or more cars each. Each car has associated with it zero to any number of recorded accidents. Each insurance policy covers one or more cars and has one 6.1 or more premium payments associated with it. Each payment is for a particular period of time, and has an associated due date, and the date when the payment was received. 6.2 Consider a database that includes the entity sets student, course, and section from the university schem, and that additionally records the marks that students receive in different exams of different sections. Construct an E-R diagram that models exams as entities and uses a ternary relationship as part of the design. a. Construct an alternative E-R diagram that uses only a binary relationship between student and section. Make sure that only one relationship exists between a particular student and section pair, yet you can represent the marks that a student gets in different exams. b. Design an E-R diagram for keeping track of the scoring statistics of your favorite sports team. You should store the matches played, the scores in each match, the players in each match, and individual player scoring statistics for each match. Summary statistics should be modeled as derived attributes with an explanation as to how they are computed. 6.3 Construct an E-R diagram for a hospital with a set of patients and a set of med- ical doctors. Associate with each patient a log of the various tests and examina- 6.15 tions conducted. W hp
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Requirement Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education