Answered step by step
Verified Expert Solution
Question
1 Approved Answer
QUESTION 1 Given the information below, create the fully labeled Crow's Foot ERD using a specialization hierarchy where appropriate (use Visio). The ERD must contain
QUESTION 1 Given the information below, create the fully labeled Crow's Foot ERD using a specialization hierarchy where appropriate (use Visio). The ERD must contain all primary keys, foreign keys, and main attributes. Business rules are defined as follows: The Aircraft Maintenance department performs al maintenance for company's aircraft. The company classifies its' employees as Mechanics, Administrators, or Staff . For each employee, the company wants to keep track of his/her ID, first and last name, and salary. In addition, some employees have different attributes. The list of such attributes includes but is not limited to the following: the classification level fo r administrators, and r mechanics, the position fo the hourly rate for staff must be recorded. * For mechanics performing engine maintenance, the date of their last refresher course must be recorded. For mechanics perform the number of years of experience must be recorded. ing airframe maintenance, For mechanics performing avionics maintenance (avionics are the electronic components of an aircraft that are used in communication and navigation), the access level must be recorded. Each employee generates a record in the YEARS table that keeps track of the total number of years an employee worked for the company. The table also includes the "COMMENT" field where any additional information may be recorded. One record is related to one employee only
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started