subject

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: .

a. The Aircraft Maintenance department performs all maintenance for company's aircraft. The company classifies its' employees as Mechanics, Administrators, or Staff.
b. 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 for mechanics, the position for administrators, and the hourly rate for staff must be recorded. For mechanics performing engine maintenance, the date of their last refresher course must be recorded.
c. For mechanics performing airframe maintenance, the number of years of experience must be recorded.
d.. 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.
e. Each employee generates a record in the YEARS table that keeps track of the total number of years an employee worked for the company.
f. The table also includes the "COMMENT field where any additional information may be recorded. One record is related to . one employee only

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 23.06.2019 01:00
Write the command that can be used to answer the following questions. (hint: try each out on the system to check your results.) a. find all files on the system that have the word test" as part of their filename. b. search the path variable for the pathname to the awk command. c. find all files in the /usr directory and subdirectories that are larger than 50 kilobytes in size. d. find all files in the /usr directory and subdirectories that are less than 70 kilobytes in size. e. find all files in the / directory and subdirectories that are symbolic links. f. find all files in the /var directory and subdirectories that were accessed less than 60 minutes ago. g. find all files in the /var directory and subdirectories that were accessed less than six days ago. h. find all files in the /home directory and subdirectories that are empty. i. find all files in the /etc directory and subdirectories that are owned by the group bin."
Answers: 1
question
Computers and Technology, 23.06.2019 09:00
Which best describes the role or restriction enzymes in the analysis of edna a. to break dna into fragments that vary in size so they can be sorted and analyzed b. to amplify small amounts of dna and generate large amounts of dna for analysis c. to purify samples of dna obtained from the environment so they can be analyzed d. to sort different sizes of dna fragments into a banding pattern that can be analyzed
Answers: 1
question
Computers and Technology, 23.06.2019 16:00
Kenny works with an it company. his company is about to launch new software in the market. he has to ensure that this new software is functional and meets all of the quality standards set up at the planning stage. which job profile is kenny likely to have? kenny is likely to have the job profile of a blank .
Answers: 2
question
Computers and Technology, 24.06.2019 00:00
Which tool could be used to display only rows containing presidents who served two terms
Answers: 3
You know the right answer?
Given the information below, create the fully labeled Crow's Foot ERD using a specialization hierarc...
Questions
question
Mathematics, 15.04.2021 01:00
question
Mathematics, 15.04.2021 01:00
question
Mathematics, 15.04.2021 01:00
question
Mathematics, 15.04.2021 01:00
question
Mathematics, 15.04.2021 01:00
question
Mathematics, 15.04.2021 01:00
question
Mathematics, 15.04.2021 01:00
Questions on the website: 13722363