Each technician is an expert on one or more plane model

Assignment Help Database Management System
Reference no: EM13507593

1.A company database needs to store information about employees (iden-ti?ed by ssn, with salary and phone as attributes), departments (identi?ed by dno, with dname and budget as attributes), and children of employees (with name and age as attributes). Employees work in departments; each department is managed by an employee; a child must be identi?ed uniquely by name when the parent (who is an employee; assume that only one parent works for the company) is known. We are not interested in information about a child once the parent leaves the company.

Draw an ER diagram that captures this information.

2.Computer Sciences Department frequent ?iers have been complaining to Dane County Airport o?cials about the poor organization at the airport. As a result, the o?cials decided that all information related to the airport should be organized using a DBMS, and you have been hired to design the database. Your ?rst task is to organize the information about all the airplanes stationed and maintained at the airport. The relevant information is as follows:

Every airplane has a registration number, and each airplane is of a speci?c model.

The airport accommodates a number of airplane models, and each model is iden-ti?ed by a model number (e.g., DC-10) and has a capacity and a weight.

A number of technicians work at the airport. You need to store the name, SSN, address, phone number, and salary of each technician.

Each technician is an expert on one or more plane model(s), and his or her exper-tise may overlap with that of other technicians. This information about technicians must also be recorded.

Tra?c controllers must have an annual medical examination. For each tra?c controller, you must store the date of the most recent exam.

All airport employees (including technicians) belong to a union. You must store the union membership number of each employee. You can assume that each employee is uniquely identi?ed by a social security number.

The airport has a number of tests that are used periodically to ensure that air-planes are still airworthy. Each test has a Federal Aviation Administration (FAA) test number, a name, and a maximum possible score.

The FAA requires the airport to keep track of each time a given airplane is tested by a given technician using a given test. For each testing event, the information needed is the date, the number of hours the technician spent doing the test, and the score the airplane received on the test.

1. Draw an ER diagram for the airport database. Be sure to indicate the various attributes of each entity and relationship set; also specify the key and participation constraints for each relationship set. Specify any necessary overlap and covering constraints as well (in English).

2. The FAA passes a regulation that tests on a plane must be conducted by a tech-nician who is an expert on that model. How would you express this constraint in the ER diagram? If you cannot express it, explain brie?y.

Reference no: EM13507593

Questions Cloud

Explain the relationship between er diagrams and uml : Explain the following terms brie?y: UML, use case diagrams, statechart dia-grams, class diagrams, database diagrams, component diagrams, and deployment diagrams.
Estimate the wavelength of the standing wave : A standing wave has been created on a string of length 1.5m. The frequency of the wave is 25Hz. What is the wavelength of the standing wave
Prepare a pension worksheet for the pension plan in 2012 : Prepare a pension worksheet for the pension plan in 2012 and prepare any journal entries related to the pension plan that would be needed at December 31, 2012.
Calculate the current in the loop : A 2cm x 2cm square loop of wire in the xy plane with resistance .010 ohms has one edge parallel to a long straight wire. What is the current in the loop
Each technician is an expert on one or more plane model : Each technician is an expert on one or more plane model(s), and his or her exper-tise may overlap with that of other technicians. This information about technicians must also be recorded.
Prepare a mutli-step income statement : Prepare the journal entries for Latest Fashions for the transactions listed, assuming that Latest Fashions uses a perpetual inventory system and prepare a mutli-step income statement
Explain sample of the compound decomposes in 54 min : What is the half-life of a compound if 60. percent of a given sample of the compound decomposes in 54 min
Find his resultant displacement from camp : A hiker starts at his camp and moves the following distances while exploring his surroundings: 60.0 m north, 2.95 102 m east, Find his resultant displacement from camp
Determine the angular speed of the earth : It takes 23 hours 56 minutes and 4 seconds for the earth to make one revolution (mean sidereal day). What is the angular speed of the earth

Reviews

Write a Review

Database Management System Questions & Answers

  Draw the e/r diagrams for the business rules

Draw the E/R diagrams for the business rules

  List the price of the item called back scratcher

List the first and last names of any customers who have bought all of the items. (This does not need to be as part of a single purchase).

  Consider the eer diagram for a car dealer in the figure

consider the eer diagram for a car dealer in the figure below. map the eer schema into a set of relations. for the

  To analyse and comprehend a provided er diagram

Display the item id and the difference between the default price and cost (ITECH5006 - together with a percentage markup) of all products.

  Sketch object-oriented model for private airport database

Sketch an object-oriented model for a small private airport database that is used to keep track of airplanes, their owners, airport employees, and pilots.

  Create relational schema of database in 3nf

A Relational schema of your database in 3NF, clearly indicating attributes, the data type of each attribute, primary and foreign keys, candidate keys, and which attributes are nullable, giving reasons. List any assumptions you need to make.

  Explain the datawarehouse and data mining concepts

There are six major types of information systems which organisations use in their operations. Discuss how these information systems support managers in their decision making role Explain the datawarehouse and data mining concepts using appropria..

  Metropolis toys metropolis toys is an independent

metropolis toys metropolis toys is an independent family-owned manufacturer of wooden toys. the toys are designed by

  Draw at a context diagram and a level-0 diagram

Draw at a context diagram and a level-0 diagram. In drawing these diagrams, if you discover that the narrative is incomplete, make up reasonable explanations to complete the story. Provide these extra explanations along with the diagrams.

  Explain turing and von neumann models

Write a 2 page research paper (excluding the title page) on the Turing and von Neumann models. Compare and contrast each and discuss which model is better and why.

  Explain normalistion and data entry screen

Visualise the computer data entry screens that could be used to capture data for the following business events in Mike's business.

  Create microsoft access database

Create a Microsoft Access database. Create the tables, fi elds, data types, and primary key(s) for the database. Create the relationship(s) needed between the tables.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd