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, 21.06.2019 21:00
Analyze the following code. int x = 1; while (0 < x) & & (x < 100) system.out.println(x++); a. the loop runs forever. b. the code does not compile because the loop body is not in the braces. c. the code does not compile because (0 < x) & & (x < 100) is not enclosed in a pair of parentheses. d. the numbers 1 to 99 are displayed. e. the numbers 2 to 100 are displayed.
Answers: 3
question
Computers and Technology, 23.06.2019 09:30
Write a function called checkfactor that takes two arrays of positive numbers, firstnumberrow and secondnumberrow. checkfactor checks if the first entry in firstnumberrow is divisible by the first entry in secondnumberrow, and performs the same operation on the next array elements until all entries have been checked. all the numbers are positive and the number of entries in the arrays are the same. the function should return the identified divisible numbers in two row arrays named firstdivisible and seconddivisible.restrictions: branches or loops should not be used. the code must use the internal mod and logical functions.hint: the mod function should be used to determine if two numbers are divisible. ex: for num1 and num2 if mod(num1,num2) is 0, then the two numbers are divisible.this is matlab
Answers: 2
question
Computers and Technology, 24.06.2019 22:30
To include a watermark or page border on a word document, you will first need to navigate to the tab. file home insert design
Answers: 1
question
Computers and Technology, 25.06.2019 06:20
Horseback riders, bicyclists, and skateboarders the rules of right-of-way when they use the road ?
Answers: 1
You know the right answer?
Given the information below, create the fully labeled Crow's Foot ERD using a specialization hierarc...
Questions
question
Mathematics, 02.02.2021 19:30
question
Mathematics, 02.02.2021 19:30
question
Mathematics, 02.02.2021 19:30
question
World Languages, 02.02.2021 19:30
question
Mathematics, 02.02.2021 19:30
Questions on the website: 13722361