Develop a logical data model based on the following requirements: • Refinement of the conceptual model - including a refined Enhanced Entity-Relationship (EER) diagram. • Derivation of relations from the refined conceptual model. • Validation of logical model using normalization to BCNF. • Validation of logical model against corresponding user transactions. • Definition of integrity constraints including: - Primary key constraints. - Referential Integrity (foreign key) constraints. - Entity integrity (NULL and default value) constraints. - Alternate key constraints. - General constraints if any. Entities Airplane Model Technician Expertise Traffic Controller Medical Examination Union Test Testing Event Relationships Airplane is of Model (1:M) Technician has Expertise in Model (M:M) Traffic Controller undergoes Medical Examination (1:1) Employee belongs to Union (1:1) Airplane is Tested using Test (M:M) Testing Event records Airplane, Technician, and Test (M:M:M) Attributes Airplane Registration Number (PK) Model Model Number (PK) Capacity Weight Technician SSN (PK) Name Address Phone Number Salary Expertise SSN (PK) Model Number (PK) Traffic Controller SSN (PK) Date of Most Recent Exam Union Membership Number (PK) Test FAA Test Number (PK) Name Maximum Possible Score Testing Event Date (PK) Hours Score Specialization/Generalization None

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

Concept explainers

Question

100%

Develop a logical data model based on the following requirements:
• Refinement of the conceptual model - including a refined Enhanced Entity-Relationship (EER) diagram.
• Derivation of relations from the refined conceptual model.
• Validation of logical model using normalization to BCNF.
• Validation of logical model against corresponding user transactions.
• Definition of integrity constraints including:
- Primary key constraints.
- Referential Integrity (foreign key) constraints.
- Entity integrity (NULL and default value) constraints.
- Alternate key constraints.
- General constraints if any.

Entities

Airplane
Model
Technician
Expertise
Traffic Controller
Medical Examination
Union
Test
Testing Event

Relationships

Airplane is of Model (1:M)
Technician has Expertise in Model (M:M)
Traffic Controller undergoes Medical Examination (1:1)
Employee belongs to Union (1:1)
Airplane is Tested using Test (M:M)
Testing Event records Airplane, Technician, and Test (M:M:M)

Attributes

Airplane
- Registration Number (PK)
Model
- Model Number (PK)
- Capacity
- Weight
Technician
- SSN (PK)
- Name
- Address
- Phone Number
- Salary
Expertise
- SSN (PK)
- Model Number (PK)
Traffic Controller
- SSN (PK)
- Date of Most Recent Exam
Union
- Membership Number (PK)
Test
- FAA Test Number (PK)
- Name
- Maximum Possible Score
Testing Event
- Date (PK)
- Hours
- Score

Specialization/Generalization None

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 5 steps with 1 images

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