Explore BrainMass
Share

Crow's Foot ERD

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

The FlyRight Aircraft Maintenance (FRAM) division of the FlyRight Company (FRC) performs all maintenance for FRC's aircraft. Produce a data model segment that reflects the following business rules:

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
https://brainmass.com/computer-science/performance-of-systems/crow-s-foot-erd-175923

Solution Summary

This response provides guidelines on producing a data model segment on the Crow's Foot ERD segment.

$2.19
See Also This Related BrainMass Solution

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.

Examples here:

http://faculty.washington.edu/blabob/sysan_w08/Docs/Data%20Models%20-%20Data%20Modeling.pdf

View Full Posting Details