Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Problem1. Air Mauritius Ltd publishes a weekly flight log report, which tracks each aircraft and the number of hours which were flown by an individual pilot in each aircraft. A separate report is prepared for each pilot and is employed to monitor flight proficiency for the two types of aircrafts (Fixed Wing and Rotary Wing) which a pilot might be qualified to fly. The following business rules apply to this report. Pilots may be assigned to fly different aircraft each day by the flight-scheduling manager. Each aircraft has a single crew chief permanently assigned to perform maintenance on the aircraft, although a crew chief might crew more than one aircraft. An aircraft number identifies each aircraft. There are several aircraft in fleet. An aircraft number is unique, independent of aircraft type. Pilots are identified by their flying-license-number and crew chief by employee-id.

Additional information:

All aircraft have seating-capacity data. Fixed wing aircraft have number-of-engine data and Rotary aircraft have speed-of-blade data.

Required:

problem1. Identify the entities in this situation.

problem2. Draw an ER diagram of the entities to comprise their relationships and any attributes identified.

problem3. Accommodate the ER diagram in its equivalent relational schema.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M96115

Have any Question? 


Related Questions in DBMS

Question - databasesuse database software such as microsoft

Question - Databases Use database software such as Microsoft Access or LibreOffice Base to perform the following actions. (Refer to Workshops 9 & 10 for help.) A. Create a new database. Add tables based on the design of ...

Data analysis projectyou have contracted with a local

Data Analysis Project You have contracted with a local school district to help them decide whether to use an interactive computer program or a standard chapter from a textbook to teach students to use fractions. The scho ...

Task - overview of business casealive amp boating aampb is

Task - Overview of business case: Alive & Boating (A&B) is a small start-up company that sells small boats in Wagga. A&B keeps its models in several showrooms across the city. At this stage customers cannot view the avai ...

Enterprisebim projectgoal - to enable students to

Enterprise/BIM Project Goal - To enable students to experience the process of building a non-trivial database-backed web application. Tasks 1. Choose any area that interests you - this does not necessarily have to be abo ...

Use sql management studio to create a database called

Use SQL Management Studio to create a database called ITCO630_P1.MDF. Be sure to store the database in a location that you will remember. Add the following tables and data to the database. Use the appropriate field types ...

Question 1use the tables below to answer the following

Question 1: Use the tables below to answer the following questions: customerid customerid firstname lastname city state 10101 John Gray Lynden Washington 10298 Leroy Brown Pinetop Arizona 10299 Elroy Keller Snoqualmie Wa ...

Projectinstructionsfor the purpose of grading the project

Project Instructions: For the purpose of grading the project you are required to perform the following tasks: Instructions 1 Open the start file Day Spa that you recently downloaded then Save the workbook as Lastname_Fir ...

Assignmentdeliverablesall files are located in the

Assignment Deliverables All files are located in the subdirectory of the project. The project should function as specified: When you visit the Personnel form page (frmPersonnel.aspx), a record should be saved in the tblU ...

Hotel reservationsproject descriptionthe main portion of

Hotel Reservations Project Description: The main portion of the resort is the hotel. The hotel wants to store information about hotel guests, reservations, and rooms. You will design tables, import data from Access and E ...

Lab manualin this lab you will learn how to use ddl and

Lab Manual In this lab you will learn how to use DDL and Oracle Enterprise server to create user accounts, modify, monitor and delete them. You will take the first look at object permissions in Oracle. The last assignmen ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro