Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
a. Discuss some examples of semantics that cannot be enforced by the EER model;

a. Discuss some examples of semantics that cannot be enforced by the EER model;

Database Systems: Design, Implementation, & Management
Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter3: The Relational Database Model
Section: Chapter Questions
Problem 25P: Create the ERD. (Hint: Look at the table contents. You will discover that an AIRCRAFT can fly many...
See similar textbooks
icon
Related questions
Question

 Given the following EER model for an airline business: 

a. Discuss some examples of semantics that cannot be enforced by the EER
model;
b.  Map the model to a relational model representation. Discuss the possible
loss of semantics.
c. Clearly indicate the primary–foreign key relationships
and specify NOT NULL declarations where necessary. 

AIRPORT Name Location Belongs to Year of prod- uction Type (1.1) (0..n) PLANE 3 Letter Abbreviation (1..1) Number of seats ID (1..1) Employs PILOT (1..3) Is served by Is_assigned to (0..n) Destination (0..n) ID ID (0..n) EMPLOYEE STEWARD(ESS) m (1.n) Home Address FLIGHT Is_assigned to Departure (1.n) Date of Birth ID Is_valid for Name FLIGHT PLANNER CUSTOMER (1..m) ID Destination (1.1) (0..n) TICKET Buys Number of AirMiles Departure Price
Transcribed Image Text:AIRPORT Name Location Belongs to Year of prod- uction Type (1.1) (0..n) PLANE 3 Letter Abbreviation (1..1) Number of seats ID (1..1) Employs PILOT (1..3) Is served by Is_assigned to (0..n) Destination (0..n) ID ID (0..n) EMPLOYEE STEWARD(ESS) m (1.n) Home Address FLIGHT Is_assigned to Departure (1.n) Date of Birth ID Is_valid for Name FLIGHT PLANNER CUSTOMER (1..m) ID Destination (1.1) (0..n) TICKET Buys Number of AirMiles Departure Price
Expert Solution
steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Transitive relations
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 Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Systems Architecture
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
C++ for Engineers and Scientists
C++ for Engineers and Scientists
Computer Science
ISBN:
9781133187844
Author:
Bronson, Gary J.
Publisher:
Course Technology Ptr
New Perspectives on HTML5, CSS3, and JavaScript
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning
Programming with Microsoft Visual Basic 2017
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS