Question
The FlyRight Aircraft Manufacture (FRAM) division of the FlyRight Company (FRC) performs all maintenance and production for FRC's aircraft. Since FRAM has several employees, it
The FlyRight Aircraft Manufacture (FRAM) division of the FlyRight Company (FRC) performs all maintenance and production for FRC's aircraft. Since FRAM has several employees, it is essential for FRAM to keep records about their employees.
FRAM has about 20 different type of employees, including mechanics, designers, and engineers. When needed, FRAM may ask an employee to fulfill more than one role.
Each employee is assigned a unique identification number. The company also has information about the name, date hired, address (composed of street, city, state, and zip), email address and type of each employee.
Each engineer has a research area that must be kept tracked of. Some mechanics are required to take periodic refresher courses. FRAM tracks all courses taken by each mechanic and store the completion date and course name. Each course must have multiple mechanics enrolled at the same time and each mechanic can only enroll in one course at a time.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started