Airplane PK SerialID Model Capacity MaintenanceDate Crew PK EmployeelD PK,FK FlightID FlightHours Reservations PK FK FlightID...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Airplane PK SerialID Model Capacity MaintenanceDate Crew PK EmployeelD PK,FK FlightID FlightHours Reservations PK FK FlightID FK CustomerID FK PaymentID Date ReservationID Schedule PK FlightDate CrewAssignment Remaining Capacity Terrific Airlines - Flight PK FlightID FK AirplanelD FlightHours Departure Time FlightDuration Flight Date Maintenance |PK| MaintenancelD FK SerialID FK EmployeelD Description Date - Route PK RouteID Origin Destination EstDeparture EstArrival Employee PK EmployeelD Name PhoneNumber Job Title Customer PK CustomerlD Name PhoneNumber - Payment PK PaymentID FK CustomerID 3. Create a data dictionary that lists at least each of the tables, the columns, their domains and any other constraints that apply. (15 marks) Airplane PK SerialID Model Capacity MaintenanceDate Crew PK EmployeelD PK,FK FlightID FlightHours Reservations PK FK FlightID FK CustomerID FK PaymentID Date ReservationID Schedule PK FlightDate CrewAssignment Remaining Capacity Terrific Airlines - Flight PK FlightID FK AirplanelD FlightHours Departure Time FlightDuration Flight Date Maintenance |PK| MaintenancelD FK SerialID FK EmployeelD Description Date - Route PK RouteID Origin Destination EstDeparture EstArrival Employee PK EmployeelD Name PhoneNumber Job Title Customer PK CustomerlD Name PhoneNumber - Payment PK PaymentID FK CustomerID 3. Create a data dictionary that lists at least each of the tables, the columns, their domains and any other constraints that apply. (15 marks)
Expert Answer:
Related Book For
Fundamentals Of Database Systems
ISBN: 9780133970777
7th Edition
Authors: Ramez Elmasri, Shamkant Navathe
Posted Date:
Students also viewed these databases questions
-
You are a manager at Asda. You have been given the demand data for the past 10 weeks for swim rings for children. You decide to run three different types of forecasting methods on the data to see...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
The Roto Plastics Company (RPC) produces bins and other containers for the sanitation industry using environmentally friendly composite materials. At the beginning of the year the plant had the...
-
The roller coaster in Figure P6.36 starts with a velocity of 15 m/s. One of the riders is a small girl of mass 30 kg. Find her apparent weight when the roller coaster is at locations B and C. At...
-
Jan has two jobs during 2012. One employer withheld and paid FICA taxes on $66,600 of Jan's salary, and the other employer withheld and paid FICA taxes on $44,400 in salary paid to Jan. Calculate the...
-
How could I Identify and describe the segmentation of the workforce in a hospital setting (drawing up our study of how to differentiate employee groups depending on their drivers, such as flexible...
-
In some instances, a temporary restraining order can be granted ex parte (i.e., without notice to the other side) until a hearing for a preliminary injunction can be held. Further investigate CCP 527...
-
(a) As a source of long-term financing, what are the major advantages of bonds over common stock? (b) What are the major disadvantages in using bonds for long-term financing?
-
Consider a bond portfolio, which has the following characteristics: Initial size of the portfolio: 200 AUD Defaults in the first year: 10 AUD Bonds maturing at the end of the first year: 15 AUD...
-
Create a Budget Analysis Report for the month of September, to include creating a Master Budget, and calculating the variance analyses between Actuals versus the Flexible Budget and versus the Master...
-
review the organizational chart for the company of Nissan and try to retrieve as much background information as possible on the top level positions, like the CEO, CIO, COO, etc. Is the organizational...
-
Consider two hypersonic wind tunnels with the same reservoir temperature of \(3000 \mathrm{~K}\) in air. (a) One tunnel has a test-section Mach number of 10. Calculate the flow velocity in the test...
-
The following diagram shows desired aggregate expenditure for the economy of Sunset Island. The \(A E\) curve assumes a net tax rate \((t)\) of 10 percent, autonomous exports of \(\$ 25 \) billion,...
-
Prepare a balanced scorecard for Mdecins Sans Frontires (http://doctorswithoutborders.org).
-
Find the supremum and infimum limits for each sequence given below. a. \(x_{n}=(-1)^{n}\left(1+n^{-1}ight)\) b. \(x_{n}=(-1)^{n}\) c. \(x_{n}=(-1)^{n} n\) d. \(x_{n}=n^{2} \sin ^{2}\left(\frac{1}{2}...
-
Fill in the blanks to make the following statements correct. a. In the simple macro model of the previous two chapters, the price level was _______ to the model. In the macro model of this chapter,...
-
11. Which of these objects has smallest radius? a. A 1.2 solar mass white dwarf b. A o.6 solar mass white dwarf c. Jupiter 12. What would happen if the Sun suddenly becomes a black hole without...
-
In the circuit shown in Figure 4, a battery supplies a constant voltage of 40 V, the inductance is 2 H, the resistance is 10, and l(0) = 0. (a) Find l(t). (b) Find the current after 0.1s.
-
Suppose that we have a hash file of fixed-length records, and suppose that overflow is handled by chaining. Outline algorithms for insertion, deletion, and modification of a file record. State any...
-
Specify all the inclusion dependencies for the relational schema in Figure 5.5. Figure 5.5 MPLOYEE Fname Minit Lname Ssn Address Sex Salary Super_ssn Dno Bdate DEPARTMENT Dname Dnumber Mgr_ssn...
-
Describe the three phases of the ARIES recovery method.
-
What is ISO 9000 registration, and how does it relate to total quality?
-
What is meant by the statement We are bound to a short-term focus?
-
The executives of ABC Inc. want to pursue ISO 9000 registration and let that suffice for the companys overall quality system. John Adams, ABCs vice president for quality, disagrees. Adams believes...
Study smarter with the SolutionInn App