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....
-
What are some of the other names for the activity statement?
-
Refer to E5-31A and E5-32A. Assume the Woodson Dairy Forming Department has the following costs per equivalent unit (EU) on its own production cost report for the month of January: Cost per EU...
-
Battonkill Company, operating at full capacity, sold 112,800 units at a price of $150 per unit during 2010. Its income statement for 2010 is as follows: The division of costs between fixed and...
-
6. For which of following reversible reaction the degree of dissociation or association depends upon the value of temperature but NOT on value of pressure? (a) N2(g)+3H2(g)2NH3(g) (b) N2O4(g) 2NO2(g)...
-
The hub of the wheel can be attached to the axle either with negative offset (left) or with positive offset (right). If the tire is subjected to both a normal and radial load as shown, determine the...
-
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...
-
Assume the same facts as in Exercise 20-23, except that Road Warrior now uses a backflush costing system with the following two trigger points: Purchase of direct materials. Sale of finished goods....
-
The accumulated earnings tax is a penalty intended to encourage distributions to shareholders. What would be considered "accumulated taxable income" for the year?
-
If the owner sells a fully-occupied rental property, how will the tenants' security deposits be treated at closing? If the owner sells a fully-occupied rental property, how will the tenants' security...
-
Which financial statement is the most confusing to you and what tool/resource/website could you use as a resource to understand it better? Should all employees of a company have access to financial...
-
Critically consider the internal and external ways in which a healthcare business can raise finance if it has a new product available with a Net Present Value of 100m Bahraini Dinar
-
Consider the basic Solow model with population growth where the depreciation rate 8 is between 0 and 1, and where population evolves according to: Lt+1 = (1 +n)Lt Assume the usual Cobb-Douglas...
-
Mappings from a vector space to the real numbers are sometimes called funetionals.3 Determine whether the transformations in Problems a to c are linear functionals from C[0. I] to R. a. b. c. T( f) =...
-
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...
-
Badgersize Company has the following information for its Forming Department for the month of August Work in Process Inventory, August 1: 20,000 units Direct materials: 100% complete Conversion: 20%...
-
Question 2 Listed below are costs found in various organizations. For each cost item, indicate whether it would be variable or fixed with respect to the number of units produced and sold, and then...
-
Degree 4 polynomial with zeros x = 2 (multiplicity 2), x=3+2i, and x=3-2i and f(0)=-26
Study smarter with the SolutionInn App