We need to design a database to save information about Airline Company Database. Here is the gathered information: -An airplane has a registration number, a type and localization. Every airplane type is described by his name (Boeing 747, Airbus A340...), his weight, his capacity and his action zone. - A technician of the company is characterized by a name, an identifier (ID), an address, a phone number, a salary, and he is expert on one type of airplane or more during a given period (start date and end date). - A pilot has the same attributes as the technician, in addition to number of years of experience. - Every airplane must pass a number of functional tests. - Every test has a number as identifier, a name and a value. We need to save the date and the state of every test. - Every flight is commanded by only one pilot and concerns a specific airplane. A flight has a departure city, an arrival city, a departure time, and an arrival time.

We need to design a database to save information about Airline Company Database. Here is the gathered information: -An airplane has a registration number, a type and localization. Every airplane type is described by his name (Boeing 747, Airbus A340...), his weight, his capacity and his action zone. - A technician of the company is characterized by a name, an identifier (ID), an address, a phone number, a salary, and he is expert on one type of airplane or more during a given period (start date and end date). - A pilot has the same attributes as the technician, in addition to number of years of experience. - Every airplane must pass a number of functional tests. - Every test has a number as identifier, a name and a value. We need to save the date and the state of every test. - Every flight is commanded by only one pilot and concerns a specific airplane. A flight has a departure city, an arrival city, a departure time, and an arrival time.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Suppose you are asked to design a club database system based on the following information. Each student has a unique student id, a name, and an email; each club has a unique club id, a name, a contact telephone number, and has exactly one student as its president. Each student can serve as a president in at most one of the clubs, although he/she can be the members of several clubs. Clubs organize activities and students can participate in any of them. Each activity is described by a unique activity id, a place, a date, a time and those clubs that organize it. If an activity is organized by more than one club, different clubs might contribute different activity fees.QuestionDraw an E-R diagram for the system according to the above description.
Suppose we have a database for an university. The requirements are as follows: • Professors have an SSN, a name, an age, a rank, and a research specialty. • Projects have a project number, a sponsor name (e.g., NSF), a starting date, an ending date, and a budget. • Graduate students have an SSN, a name, an age, and a degree program (e.g., M.S. or Ph.D.). • Each project is managed by one professor (known as the project’s principal investigator). • Each project is worked on by one or more professors (known as the project’s co-investigators). • Professors can manage and/or work on multiple projects. • Each project is worked on by one or more graduate students (known as the project’s research assistants). • When graduate students work on a project, a professor must supervise their work on the project. Graduate students can work on multiple projects, in which case they will have a (potentially different) supervisor for each one. The FDs for the above requirements are given as, • PSSN →…
Consider a MOVIE database in which data is recorded about the movie industry. The data requirements are summarized as follows:  Each movie is identified by title and year of release. Each movie has a length in minutes. Each has a production company, and each is classified under one or more genres (such as horror, action, drama, and so forth).  Each movie has one or more directors and one or more actors appear in it. Each movie also has a plot outline. Finally, each movie has zero or more quotable quotes, each of which is spoken by a particular actor appearing in the movie.  Actors are identified by name and date of birth and appear in one or more movies. Each actor has a role in the movie.  Directors are also identified by name and date of birth and direct one or more movies. It is possible for a director to act in a movie (including one that he or she may also direct).  Production companies are identified by name and each has an address. A production company produces one or more…
Draw an E-R diagram for the description below. Suppose that you are asked to model a database including all pharmaceutical companies, their drugs, and all pharmacies. Each pharmaceutical company is identified by its name and has a phone number. For each drug, the trade name (e.g., Acetaminophen) and formula must be recorded. Each drug is sold by only one pharmaceutical company, and the trade name identifies a drug uniquely from among the products of that company. If a pharmaceutical company stops production, we do not need to keep track of its products any longer. Each pharmacy has an identifier name, address, and phone number. Each pharmacy sells several drugs. A drug could be sold at several pharmacies, and the price could vary from one pharmacy to another.
You have been assign to design a database for Apartment Rental Management System. That is the information you received: Everything starts with an offer of apartments for rent. It is therefore necessary to identify all the buildings held by the company, as well as all the apartments within each of these buildings. We distinguish the building by its address and each of the apartments by its apartment number in the building. When a tenant is accepted, a lease is signed (only one tenant can sign the lease), which determines the amount of the monthly rent, as well as the start and end date of the tenancy. When advertising the apartments, the rent requested is also indicated. The tenants choose an apartment according to the number of rooms and according to the services included, which can be the same from one apartment to another. In order to satisfy the banker, the value of the buildings and their year of construction are preserved, making it possible to compare the rents demanded with the…
ASSESSMENT 02 1. You are required to design and implement a database system for a pharmacy shop with only one branch. The following is the description from the manager, Mr. Seth Akoto. "here, medicines that require prescriptions are sold only to people that have prescriptions. It is the pharmacy attendant that serves customers when they enter the pharmacy. Usually, people walk in and either give the prescription or mention the medicine they wish to purchase. The worker then searches to see if the medicine is in stock. If in stock, worker accepts payment from customer and gives the medicine and a receipt to the customer.“ 1. Determine all the entities from the description given by Mr. Akoto. 2. Assuming Mr. Akoto only wants a database system that would keep records of medicine{name of medicine, amount in grams in stock} and purchases{medicine bought, amount in grams bought, who attended to customer, when it was sold, contact and name of customer that bought the medicine} a. Draw and ER…
A bank provides services to customers. The banks is identified by its code and has a name and an address. The bank has several branches. A branch is identified by its code that is unique for a given bank. The branch name and address are also stored in the database. Customers deal with the bank through the bank branches. So, a customer belongs to a specific bank branch. Customers either open bank accounts (CURRENT, SAVINGS, etc.) or receive bank loans (DIRECT, INDIRECT, etc.) from the bank. The bank stores customer info namely: EID, name, phone, and address. The bank also keeps track of customers’ loans and accounts. Information stored about loans include loan no, amount, and type. Account information stored is account no, balance, and type. The address information stored for any entity includes street number, street name, PO Box, city, and emirate. Draw an ER diagram representing the needed database.
Scenario 1: A privately owned company that sells industrial kitchen equipment needs to set-up a database for their employees. The company has vastly expanded over the last couple of years and needs to keep track of its employees’ salaries. The salaries are worked out according to the position of the person in the department that they work in. Each department has certain facilities, for example the director’s department has a smoking balcony, the factory has a water cooler e.t.c. Each position has the same salary, regardless of the department. For example, a manager in the factory has the same salary as the manager of the IT department. Each employee is uniquely identified by their employee’s ID number. The CEO would also like to know how many positions in each department there are, as well as the name of the branch each employee works for. Each branch must have the information of the country it is situated in. Question 1: Draw a complete entity relationship diagram with all…
You are required to design and implement a database system for a pharmacy shop with only one branch. The following is the description from the manager, Mr. Seth Akoto. “here, medicines that require prescriptions are sold only to people that have prescriptions. It is the pharmacy attendant that serves customers when they enter the pharmacy. Usually, people walk in and either give the prescription or mention the medicine they wish to purchase. The worker then searches to see if the medicine is in stock. If in stock, worker accepts payment from customer and gives the medicine and a receipt to the customer. “ 1. Determine all the entities from the description given by Mr. Akoto. 2. Assuming Mr. Akoto only wants a database system that would keep records of medicine{name of medicine, amount in grams in stock} and purchases{medicine bought, amount in grams bought, who attended to customer, when it was sold, contact and name of customer that bought the medicine} a. Draw and ER diagram with…
Consider a MOVIE database in which data is recorded about the movie industry. The data requirements are summarized as follows: -- Each movie is identified by title and year of release. Each movie has a length in minutes and a rating (e.g., G, PG, or R). Each has a production company, and each is classified under one or more genres(such as horror, action, drama, and so forth). Each movie has one or more directors and one or more actors appear in it. Each movie also has a plot outline. Finally, each movie has zero or more quotable quotes, each of which is spoken by a particular actor appearing in the movie. An actor may have multiple quotes from one movie. -- Actors are identified by name and date of birth and appear in one or more movies. Each actor has a role in the movie, i.e., the character he or she plays. -- Directors are also identified by name and date of birth and direct one or more movies. -- Production companies are identified by name and each has an address. A production…
The problems for this chapter use a database for a simple department store that sells items to customers and wants to keep track of the invoices, the selling price (if an item is on sale), and the sales tax (7%) to be collected on some items. Every customer and invoice are assigned unique numbers. All items have a Universal Product Code (UPC) number and bar-code assigned to each unique item. Food and non-carbonated beverages are not taxed, but clothing, home goods, and most other items are. The structure of the tables is described in the following crows foot ERD:
The problems for this chapter use a database for a simple department store that sells items to customers and wants to keep track of the invoices, the selling price (if an item is on sale), and the sales tax (7%) to be collected on some items. Every customer and invoice are assigned unique numbers. All items have a Universal Product Code (UPC) number and bar-code assigned to each unique item. Food and non-carbonated beverages are not taxed, but clothing, home goods, and most other items are.