Consider the ER diagram in Figure 3.21, which shows a simplified schema for an airline reservations system.
Question:
Consider the ER diagram in Figure 3.21, which shows a simplified schema for an airline reservations system. Extract from the ER diagram the requirements and constraints that produced this schema. Try to be as precise as possible in your requirements and constraints specification.
Figure 3.21
Transcribed Image Text:
Airport code City Name State DEPARTURE_ AIRPORT Leg no AIRPORT Scheduled_dep_time Scheduled_arr_time FLIGHT LEG N M ARRIVAL_ CAN_ AIRPORT Instances LEGS LAND N. Number Type_nameMax_seats INSTANCE OF Company Airline FLIGHT AIRPLANE_ Arr_time Weekdays TYPE DEPARTS N ARRIVES Restrictions FARES Dep_time Amount TYPE N. Code FARE Airplane id Total_no_of_seats No of_avail_seats Date AIRPLANE ASSIGNED LEG INSTANCE Customer_name Cphone Seat no RESERVATION Notes: A LEG (segment) is a nonstop portion of a flight. A LEG_INSTANCE is a particular occurrence of a LEG on a particular date. SEAT Figure 3.21 An ER diagram for an AIRLINE database schema.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 87% (8 reviews)
Answered By
Asim farooq
I have done MS finance and expertise in the field of Accounting, finance, cost accounting, security analysis and portfolio management and management, MS office is at my fingertips, I want my client to take advantage of my practical knowledge. I have been mentoring my client on a freelancer website from last two years, Currently I am working in Telecom company as a financial analyst and before that working as an accountant with Pepsi for one year. I also join a nonprofit organization as a finance assistant to my job duties are making payment to client after tax calculation, I have started my professional career from teaching I was teaching to a master's level student for two years in the evening.
My Expert Service
Financial accounting, Financial management, Cost accounting, Human resource management, Business communication and report writing. Financial accounting : • Journal entries • Financial statements including balance sheet, Profit & Loss account, Cash flow statement • Adjustment entries • Ratio analysis • Accounting concepts • Single entry accounting • Double entry accounting • Bills of exchange • Bank reconciliation statements Cost accounting : • Budgeting • Job order costing • Process costing • Cost of goods sold Financial management : • Capital budgeting • Net Present Value (NPV) • Internal Rate of Return (IRR) • Payback period • Discounted cash flows • Financial analysis • Capital assets pricing model • Simple interest, Compound interest & annuities
4.40+
65+ Reviews
86+ Question Solved
Related Book For
Fundamentals Of Database Systems
ISBN: 9780133970777
7th Edition
Authors: Ramez Elmasri, Shamkant Navathe
Question Posted:
Students also viewed these Computer science questions
-
Consider the ER diagram of Figure 7.20, which shows a simplified schema for an airline reservations system. Extract from the ER diagram the requirements and constraints that resulted in this schema....
-
Consider the ER diagram in Figure 7.22. Assume that an employee may work in up to two departments or may not be assigned to any department. Assume that each department must have one and may have up...
-
Consider the ER diagram in Figure 7.23. Assume that a course may or may not use a textbook, but that a text by definition is a book that is used in some course. A course may not use more than five...
-
You are the VP of Human Resources for a company with 250 employees. You have both outside sales representatives and inside sales representatives that work primarily by phone. James is an outside...
-
Complete this table by placing an X in the correct column for each item. Will Be Temporary Permanent Closed Example: Accounts Receivable 1. Income Summary 2. Jen Rich, Capital 3. Salary Expense 4....
-
The following table consists of training data from an employee database. The data have been generalized. For example, " 31 ... 35" for age represents the age range of 31 to 35 . For a given row...
-
Lisinipril is a drug designed to lower blood pressure. In a clinical trial of Lisinipril, blood pressure levels of subjects are measured before and after they have been treated with the drug....
-
Louisiana Timber Company currently has 5 million shares of stock outstanding and will report earnings of $9 million in the current year. The company is considering the issuance of 1 million...
-
Consider a frictionless piston-cylinder system which contains a gas. The corresponding pressure (P) and volume (V) data is available in Table Q.2. for the gas while it is expanding against the...
-
Each student is required to identify individual attributes of interest to them from a sample of 30 respondents (at least) that can provide information about themselves on any two variables that you...
-
Consider Figure 1.2. a. If the name of the CS (Computer Science) Department changes to CSSE (Computer Science and Software Engineering) Department and the corresponding prefix for the course number...
-
Define the following terms as they apply to the relational model of data: domain, attribute, n-tuple, relation schema, relation state, degree of a relation, relational database schema, and relational...
-
How might the production volume variance encourage excess production?
-
Ayala Properties Corporation ("Ayala"), a real estate developer, turned to ABC Corporation ("ABC'') to build its condominium project in Pasig City. In the midst of construction, ABC's president...
-
Under the deferral method, how is restricted investment income recorded in the financial statements?
-
Question. 1). How do societies create effective and resilient institutions, such as governments?
-
Pepperdine University's Graziadio School of Business and Management (GSBM) is one of the largest business schools in the country and has the third largest part-time MBA program.The school also...
-
Penny wants to earn a 55% profit on her home of 20 years. She has a loan amount of $160,000, and will pay closing costs of $1,900. What should she sell the home for?
-
(a) Count the elements of unsaturation in the three structures shown above (parsalmide, ethynyl estradiol, and dynemicin A). (b) Draw structural formulas of at least two alkynes of each molecular...
-
How do the principles of (a) Physical controls and (b) Documentation controls apply to cash disbursements?
-
In SQL, specify the following queries on the database specified in Figure 3.5 using the concept of nested queries and the concepts described in this chapter. a. Retrieve the names of all employees...
-
Show the result of each of the sample queries in Section 6.5 as it would apply to the database state in Figure 3.6.
-
Specify the following queries on the COMPANY relational database schema shown in Figure 3.5, using the relational operators discussed in this chapter. Also show the result of each query as it would...
-
Suppose in the drawing that I = 12 = 59.9 A and that the separation between the wires is 0.0345 m. By applying an external magnetic field (created by a source other than the wires) it is possible to...
-
The flash on a camera is provided by a capacitor discharging through a flashlamp. Suppose in your camera the capacitor is charged by a 9.00 V battery, and the discharge takes 6.10 s. If the average...
-
The cannon on a battleship can fire a shell a maximum distance of43.9km. (a)Calculate the initial velocity of the shell in meters per second. (Enter the magnitude.) m/s (b)What maximum height in...
Study smarter with the SolutionInn App