Solution-Produce a data model segment that reflects

Produce a data model segment that reflects business rules

Assignment Help Database Management System

Reference no: EM131685269

Question: 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. Others are specialized in airframe (AF) maintenance or 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 courses taken by each mechanic-date, course type, certification (Y/N), and performance.

• FRC keeps an employment history of all mechanics. The history includes the date hired, date promoted, and date terminated.

Given those requirements, create the Crow's Foot ERD segment.

Reference no: EM131685269

Questions Cloud

Explain the issues and roles of human resources management : Explain issues and roles of human resources management and systems development to healthcare professionals.

Describe the specialization hierarchy : Given the following business scenario, create a Crow's Foot ERD using a specialization hierarchy if appropriate. Two-Bit Drilling Company keeps information.

What creatures direct him to the tunnel : Gilgamesh must run through a tunnel of darkness and emerge before the sun rises. What creatures direct him to the tunnel?

Do short-term drawbacks justify long-term goals : Consider the ultimate impact the environment has had on the economy. Do short-term drawbacks justify long-term goals, If there is a conflict

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

Density of fluids that is required to separate aluminum : What is the density of fluids that is required to separate aluminum, glass, and plastics into individual components

Do you think there is a segment of our population : Do you think there is a segment of our population that wants McDonalds to be the hamburger and french fry chain and not the new

Why is public opinion important in modern politics : Why is public opinion important in modern politics? Describe the various ways that public opinion is formed. How have your opinions been shaped?

Explain the role of diversity in the development of the arts : How art, in the context of the social justice movements of the 20th century, challenged and shaped American society.

User Account

All Pages

Produce a data model segment that reflects business rules

Reference no: EM131685269

Reference no: EM131685269

Questions Cloud

Reviews

Write a Review

Database Management System Questions & Answers

Knowledge and data warehousing

Design a database schema

Entity-relationship diagram

Implement a database of courses and students for a school

Prepare the e-r diagram for the movie database

Design relation schemas for the entire database

Prepare the relational schema for database

Data modeling and normalization

Use cases perform a requirements analysis for the case study

Knowledge and data warehousing

Stack and queue data structure

Practice on topic of normalization

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT