All mechanics are FRC employees. Not all employees are mechanics. Some mechanics are specialized in engine (EN) maintenance. Some mechanics are specialized in airframe (AF) maintenance. Some mechanics are specialized in avionics (AV) maintenance. (Avionics are the electronic components of an aircraft that are used in communication and navigation.) All mechanics take periodic refresher courses to stay current in their areas of expertise. FRC tracks all course taken by each mechanic?date, course type, certification (Y/N), and performance.
FRC keeps a history of the employment of all mechanics. The history includes the date hired, date promoted, date terminated, and so on. (Note: The "and so on" component is, of course, not a real-world requirement. Instead, it has been used here to limit the number of attributes you will show in your design.)
Given those requirements, create the Crow's Foot ERD segment.© BrainMass Inc. brainmass.com October 24, 2018, 10:56 pm ad1c9bdddf
This response provides guidelines on producing a data model segment on the Crow's Foot ERD segment.
Business Rules and Crow's Foot ERD
Use the attachment to complete the problem.
1. Identify each relationship type and write all of the business rules.
2.Create the basic Crow's Foot ERD.
http://faculty.washington.edu/blabob/sysan_w08/Docs/Data%20Models%20-%20Data%20Modeling.pdfView Full Posting Details