Given the following EER model for an airline business: a. Discuss some examples of semantics that cannot be enforced by the EERmodel;b. Map the model to a relational model representation. Discuss the possibleloss of semantics. c. Clearly indicate the primary–foreign key relationshipsand specify NOT NULL declarations where necessary. AIRPORTNameLocationBelongs toYear ofprod-uctionType(1.1)(0..n)PLANE3 LetterAbbreviation(1..1)Number ofseatsID(1..1)EmploysPILOT(1..3)Is served byIs_assigned to(0..n)Destination(0..n)IDID(0..n)EMPLOYEESTEWARD(ESS)m(1.n)HomeAddressFLIGHTIs_assigned toDeparture(1.n)Date ofBirthIDIs_valid forNameFLIGHT PLANNERCUSTOMER(1..m)IDDestination(1.1)(0..n)TICKETBuysNumberofAirMilesDeparturePrice

The Enhanced Entity Relationship model is primarily an extension based on the ER model. It provides…

Answered: a. Discuss some examples of semantics…

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

See similar textbooks

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

Expert Solution

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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