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

Join tables, and calculate aggregate sales for each product

I need to find what 11 products are the best sellers (the width, height, depth, item name, product id, sales, gross margin), using the attached database. The query needs to

List the relational notation for each normal form

List the relational notation for each normal form (e.g. Invoice (abc, def, ghi): When your done creating the ERD in Visio submit your completed Visio file to me for grading

Find the average size of the airports in california

Find the average size of the airports in California that have been open since 1935. Describe the four steps in the transfer of data from disk to primary memory. Describe how a

Analyze the fundamentals of pki

Analyze the fundamentals of PKI, and determine the primary ways in which its features and functions could benefit your organization and its information security department.

Retrieve the data from a database using subqueries and joins

Write SQL statements that will retrieve the following data from a database, using Subqueries and Joins. Using the Northwind database, write a SQL SELECT statement that will re

Define the relationships between entities

You will design a database for CTU, which includes three entities (tables): Students, Faculty, and Classes. Note a class refers to a particular class section. For example,

What purpose of sequence diagrams and communication diagrams

What size do you think a project needs to be in order to require project management? Discuss this question for project management in general and for each of the project-plan

Display the name astext location x and y values of each pet

CMIS 320: Make the menagerieGIS database using petGIS.sql- Display the name, astext location, X and Y values of each pet. Display the pets with their location displayed in sta


Write a Review

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