Sketch object-oriented model for private airport database

Assignment Help Database Management System
Reference no: EM1367137

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. From the requirements for this database, the following information was collected. Each airplane has a registration number [Reg#], is of a particular plane type [OF-TYPE], and is stored in a particular hangar [STORED-IN]. Each plane type has a model number [Model], a capacity [Capacity], and a weight [Weight]. Each hangar has a number [Number], a capacity [Capacity], and a location [Location]. The database also keeps track of the owners of each plane [OWNS] and the employees who have maintained the plane [MAINTAIN]. Each relationship instance in OWNS relates an airplane to an owner and includes the purchase date [Pdate]. Each relationship instance in MAINTAIN relates an employee to a service record [SERVICE]. Each plane undergoes service many times; hence, it is related by [PLANE-SERVICE] to a number of service records. A service record includes as attributes the date of maintenance [Date], the number of hours spent on the work [Hours], and the type of work done [Workcode]. We use a weak entity type [SERVICE] to represent airplane service, because the airplane registration number is used to identify a service record. An owner is either a person or a corporation. Hence, we use a union category [OWNER] that is a subset of the union of corporation [CORPORATION] and person [PERSON] entity types. Both pilots [PILOT] and employees [EMPLOYEE] are subclasses of PERSON. Each pilot has specific attributes license number [Lic-Num] and restrictions [Restr]; each employee has specific attributes salary [Salary] and shift worked [Shift]. All person entities in the database have data kept on their social security number [Ssn], name [Name], address [Address], and telephone number [Phone]. For corporation entities, the data kept includes name [Name], address [Address], and telephone number [Phone]. The database also keeps track of the types of planes each pilot is authorized to fly [FLIES] and the types of planes each employee can do maintenance work on [WORKS-ON].

Reference no: EM1367137

Questions Cloud

Company-s interpretation of requirement of system : You have taken job with a software user who has contracted previous employer to develop a system for them. You discover that your company's interpretation of requirements is different from interpretation.
Various problems with infant health : Maternal smoking during pregnancy has been implicated in various problems with infant health.
Primary and secondary sites of the cancer : When presented with a medical record that states the patient's cancer has metastasized, what process do you use to determine the primary and secondary sites of the cancer?
Determining-interpreting elasticities of demand : Find out the own price elasticity of demand and state whether demand is elastic, inelastic or unitary elastic. Determine the income elasticity of demand state whether good X is normal or inferior
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.
Influence patient education in health care : Discuss in detail, older adult patient education issues and the influence patient education has in health care using the experiences this patients following interview.
Valuation of call option : A European Call Option on a non dividend paying stock where stock value is $40, the strike price is $40, the risk-free rate is 4 percent per annum, the volatility is 30 percent per annum,
Determining equilibrium prices and quantity : Lawn mowing services are supplied by host of individuals in suburb of Westbrook. Demand and supply conditions in the perfectly competitive domestic for lawn mowing services are:
Revenue maximizing : Assume your elasticity of demand for your parking lot spaces is -.05, and price is $20/day. If your MC is zero, and your capacity at 9 a.m. is 96% full over the last month, are you optimizing?

Reviews

Write a Review

 

Database Management System Questions & Answers

  Key value of fourth index record on top level

What is the key value of the 4th index record on the top level, assuming each index record points to the record with the highest key value in a block of the next level down?

  Write program to ask user to enter last name of customer

Write a program that will ask the user to enter the last names of our candidates in a class officer's president election and the number of votes received each candidate.

  Essay on data mining in warehouse architectures

Course: data mining. Require a 7 page essay on subjects: Warehouse Architectures: the paper requires to contain information about centralized, federated, and tiered data warehouse.

  Your task is to develop a database to support this activity

Your task is to develop a database to support this activity.Here is what you need to be able to provide Custom Auto Body in order to land your first consulting contract:

  Difference between obsolescent and redundant stocks

Difference between obsolescent and redundant stocks

  Create a function

Create a function that returns the day of the week for a specified date. Create a trigger that displays the message "Emp table updated" when an update to the employee table increases the employee's basic salary.

  Key functions of organization-map to strategic information

From information system point of view, we should take the key functions of organization and map them to strategic information. Do your companies follow this process or are steps skipped?

  Explain denormalized table in normal form

The DBA denormalized some of the data in the Premiere Products database to improve performance. Which field or fields cause the table to no longer be in third normal form? In which normal form is the denormalized table?

  Evaluate maximum rate at which data can be read from disk

What is the maximum rate at which data can be read from disk, assuming that we can only read data from one surface at a time? What is the average rotational latency?

  Write command to list all employees in descending order

Write a command to list all the employees hired in 2003 and 2004. Sort the rows by the hire_date column in descending order.

  Perform large number of client-server requests into database

A small business with 100 computer workstations is installing a new local area network. All of the users perform the usual operations of e-mail. State your reasoning. Draw a floor plan for each If possible, show both floor plans on one page.

  Explaining uses for views

Views are integral part of virtual private databases, yet views are utilized for many other reasons. Find out many other uses for views.

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