The Fly Right Aircraft Manufacture (FRAM) division of the Fly Right Company (FRC) performs all maintenance and production for FRC’s aircraft. Since FRAM has several employees each with specific roles, it is essential for FRAM to keep records about their employees.
FRAM has about 20 different type of employees, including mechanics, designers and engineers. Each employee is assigned a unique identification number. The company also has information about the name, date hired, address (including city, state, and zip), email address and type of each employee. Each engineer has a research area that must be kept tracked of.
Each mechanic is specialized in 2 possible areas and it is not unusual for a mechanic to have both specializations. Some mechanics are specialized in engine (EN) maintenance and are required to possess a clearance level which must be saved by FRAM.
Some mechanics are specialized in airframe (AF) maintenance and are required to take periodic refresher courses. FRAM tracks all course taken by each AF mechanic and store the completion date, certification (Y/N), and performance. Each course can have multiple AF mechanics enrolled at the same time and each AF mechanic can only enroll in one course at a time.