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 06:00
Which statistical function in a spreadsheet you to see how far each number varies, on average, from the average value of the list?
Answers: 2
question
Computers and Technology, 23.06.2019 21:20
For positive constants a and b, the force between two atoms in a molecule is given f(r) = −a r2 + b r3 , where r > 0 is the distance between the atoms. note: a and b are upper case letters. (a) find f '(r) = (b) find the critical point for f(r). r = (c) find f ''(r) = (d) find the value of r so that f ''(r) = 0.
Answers: 1
question
Computers and Technology, 24.06.2019 04:30
1. web and mobile applications allow users to be actively engaged in an online activity. a true b false 2. some examples of business applications purposes are to collaborate, share files, meet virtually in real-time, and accept payments. a true b false 3. an education application would most likely do which of the following? a allow users to watch popular movies and tv shows b connect users with social and business contacts c confirm users' travel plans d teach users a new language 4. a uniform resource locator (url) is how the internet knows where to take users when an address is typed into a browser. a true b false 5. deon is required to provide the citation information for his sources. what type of information should he collect from his sources? a author name, title, date of publication, date of access, url b connections to background information c interesting facts and statistics d notes on important information
Answers: 1
question
Computers and Technology, 24.06.2019 14:30
Two students are discussing electricity that has a frequency of 60 hz. student a says that this type of electricity is referred to as ac. student b says that in this type of electricity, the electrons flow in only one direction. which of the following statements is correct? a. only student a is correct b. only student b is correct c. both of the two students are correct d. neither of the two students is correct
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, 23.04.2021 01:20
question
Mathematics, 23.04.2021 01:20
question
Physics, 23.04.2021 01:20
question
Spanish, 23.04.2021 01:20