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
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 Systems: Design, Implementation, & Management
11th Edition
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:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Chapter5: Advanced Data Modeling
Section: Chapter Questions
Problem 8RQ: According to the data model, is it required that every entity instance in the PRODUCT table be...
Related questions
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 1 images
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.Recommended textbooks for you
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
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