Identify 7 mistakes by giving a number (e.g., 1, 2). Clearly explain each mistake and what should be the correct answer. An example is given below by naming the first mistake as number 1 (pointed by the arrow).

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
100%

A rail transport company wishes to hold details of train services, stations and operators. Details include the following:

 

Trains: A train has a unique id code, a collection of days it runs on (Monday, Sunday etc.), and the

number of carriages it has. Each train must have at least one driver but can have many drivers that can drive it, and a driver may drive many trains. Each driver is identified by an employee number and a name. A train is designated as either an InterCity or District train though other types of train are possible. Each train must have an operator and not more than one operator. Each operator has a name and a phone number. The operator can operate many trains (or none at all!)

 

Stations: A station has a name and the number of platforms it has. All stations are classified as either

Main or District only. There are no other types of stations.

 

Timetable: A train has a number of stops at a station during its journey. It never visits the same

station twice on the same journey. At each stop, the arrival and departure times are recorded. A station

has many trains passing through it, often arriving at the same time, and a train visits many stations.

 

A new database designer has made a first attempt at an EER schema, shown in Figure 1, but there are

at least 10 mistakes. Examples of mistakes include incorrect cardinality and participation in relations, missing or incorrectattributes, and incorrect constraints (e.g., disjoint, partial).

 

Identify 7 mistakes by giving a number (e.g., 1, 2). Clearly explain each mistake and what should be the correct answer. An example is given below by naming the first mistake as number 1 (pointed by the arrow).

 

Example: (1) Optional participation is incorrect: all trains must have at least one driver – so, minimum cardinality or participation must be mandatory ‘1

 

Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Maintenance
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
  • SEE MORE 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