This book contains examples for each step in the design process for several hy- pothetical business...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
This book contains examples for each step in the design process for several hy- pothetical business applications. One of these is Moon Launch Enterprise, which markets moon junkets to the business or vacationing traveler in the year 2010. Users want a system to support scheduling and managing Moon Launch space trips. We will expand the details of the enterprise as needed to support our design examples. Your first data modeling work session for this case study is with the passen- ger reservations agent of Moon Launch Enterprise. This agent is responsible for placing reservations for business and vacationing passengers. Of course, a given passenger can be a business passenger for some trips and a vacation pas- senger for others. The details follow. The sentences are numbered for easy ref- erence. 1. Passenger Information a. Moon Launch assigns all passengers identification numbers within their respective countries (e.g., in the United States, the identification number may be the Social Security number). The numbers used for each country vary in size and may include special characters (e.g.. So- cial Security number contains two hyphens). b. There may be a future need to record the passenger's age, in case Moon Launch Enterprise decides to offer special fares by age (e.g.. children's fares). For now, fares differ only on the basis of credit- rating discounts. C. Each passenger has a last name, first name, middle name (perhaps), and title (e.g., Mr., Mrs., Msr., Señor). d. Each passenger has a mailing address for tickets and a mailing address for billing. In the case of a business passenger, the mailing address for billing is place of business. The mailing address for tickets can be ei- ther personal residence or place of business. In the case of vacation passengers, both tickets and bills are mailed to personal residence. e. All passengers have credit ratings assigned to them by Moon Launch Enterprise. For a business passenger, the credit rating is that of the place of business. 2. Reservation Information a. The reservation agent records flight, method of payment (e.g., World Express Card), price of ticket, and entry date of the reservation. The agent also records his own Moon Launch employee identification number with the reservations. b. To calculate ticket prices, the agent checks each passenger's credit rat- ing and applies the following discounts to the base price: Credit rating Discount A - 20% - 10% 0% + 10% (Note: Credit Rating D is for undesirable passengers.) C. All seats are nonsmoking and have no windows. There is more information in this narrative than is needed for this step. However, never refuse input from a user! It may be useful in subsequent steps. BCD с O Moon Launch schedules four flights each day: two to the moon and two returning. One hundred seats are available on each flight. On average, 75 percent are booked. Another 10 percent are booked and canceled. Also, eight crew members attend each flight. □ Approximately 50 percent of the passengers on each flight are vacationing and fly Moon Launch an average of 1.05 times per year (round trip, of course). The rest are on business and fly Moon Launch an average of three times per year. Approximately 3000 passengers book both vacation and business trips within the same year. Moon Launch deals regularly with about 1000 businesses. From each, an average of six employees per year fly. Another 2000 companies are on file; their employees fly less regularly. Moon Launch uses four credit ratings: A, B, C, and D. This book contains examples for each step in the design process for several hy- pothetical business applications. One of these is Moon Launch Enterprise, which markets moon junkets to the business or vacationing traveler in the year 2010. Users want a system to support scheduling and managing Moon Launch space trips. We will expand the details of the enterprise as needed to support our design examples. Your first data modeling work session for this case study is with the passen- ger reservations agent of Moon Launch Enterprise. This agent is responsible for placing reservations for business and vacationing passengers. Of course, a given passenger can be a business passenger for some trips and a vacation pas- senger for others. The details follow. The sentences are numbered for easy ref- erence. 1. Passenger Information a. Moon Launch assigns all passengers identification numbers within their respective countries (e.g., in the United States, the identification number may be the Social Security number). The numbers used for each country vary in size and may include special characters (e.g.. So- cial Security number contains two hyphens). b. There may be a future need to record the passenger's age, in case Moon Launch Enterprise decides to offer special fares by age (e.g.. children's fares). For now, fares differ only on the basis of credit- rating discounts. C. Each passenger has a last name, first name, middle name (perhaps), and title (e.g., Mr., Mrs., Msr., Señor). d. Each passenger has a mailing address for tickets and a mailing address for billing. In the case of a business passenger, the mailing address for billing is place of business. The mailing address for tickets can be ei- ther personal residence or place of business. In the case of vacation passengers, both tickets and bills are mailed to personal residence. e. All passengers have credit ratings assigned to them by Moon Launch Enterprise. For a business passenger, the credit rating is that of the place of business. 2. Reservation Information a. The reservation agent records flight, method of payment (e.g., World Express Card), price of ticket, and entry date of the reservation. The agent also records his own Moon Launch employee identification number with the reservations. b. To calculate ticket prices, the agent checks each passenger's credit rat- ing and applies the following discounts to the base price: Credit rating Discount A - 20% - 10% 0% + 10% (Note: Credit Rating D is for undesirable passengers.) C. All seats are nonsmoking and have no windows. There is more information in this narrative than is needed for this step. However, never refuse input from a user! It may be useful in subsequent steps. BCD с O Moon Launch schedules four flights each day: two to the moon and two returning. One hundred seats are available on each flight. On average, 75 percent are booked. Another 10 percent are booked and canceled. Also, eight crew members attend each flight. □ Approximately 50 percent of the passengers on each flight are vacationing and fly Moon Launch an average of 1.05 times per year (round trip, of course). The rest are on business and fly Moon Launch an average of three times per year. Approximately 3000 passengers book both vacation and business trips within the same year. Moon Launch deals regularly with about 1000 businesses. From each, an average of six employees per year fly. Another 2000 companies are on file; their employees fly less regularly. Moon Launch uses four credit ratings: A, B, C, and D.
Expert Answer:
Answer rating: 100% (QA)
tblpassenger This is the table for the passenger this contains all the data about the passenger tblreservation is the main table for the reservation Here all the data about the reservation is stored a... View the full answer
Related Book For
Posted Date:
Students also viewed these marketing questions
-
In the design process for a child-restraint chair an engineer considers the following set of conditions: A 12-kg child is riding in the chair, which is securely fastened to the seat of an automobile...
-
What are the yield ratios for each step in the recruitment and selection process? What are the implications of these ratios for future hiring?
-
Identify the reagents appropriate for each step in the following syntheses: (a) (b) (c) (d) CH CH CH 0 HCCH-CH-CH-CH-CH - CHi (CHCH CCH3 CH-CCH-CH-CHCH-CH-_ CH(CH3)2 H(CH3)2...
-
The owner of a moving company typically has his most experienced manager predict the total number of labor hours that will be required to complete an upcoming move. This approach has proved useful in...
-
Nature's Own makes three types of wood flooring: Oak, Hickory, and Cherry. The company's tax rate is 40 percent. The following costs are expected for 2011: Per-square-yard expected selling prices are...
-
If competition places discipline on costs, motivating firms to innovate and find more cost-effective ways to produce, explain why in some markets a single firm without competitors will produce at a...
-
Tone Corporation has authorized 200,000 shares of $1 par value common stock, of which 160,000 are issued and 140,000 are outstanding. On May 15, the board of directors declared a cash dividend of...
-
Discuss the advantages and disadvantages of using divisional profit as the basis of incentive compensation for division managers compared to using company profit as the basis.
-
A colleague has reached out to you with an investment opportunity. They are giving you an opportunity to buy ownership in their company that has just completed its second year. Financial details...
-
Cherry Hill Glass Company employs a normal-costing system. The following information pertains to the year just ended. Total manufacturing costs were $1,250,000. Cost of goods manufactured was...
-
Given the formula A = P (1 + -) , compute A (rounded to two decimal places) if P = 10,000, r = 0.08, k = 2, and n = 12. O A 124,800.00
-
A 1 5 0 - mm - diameter shaft with a mass of 2 0 kg is rotating at 9 0 0 rpm . A pulley mounted on the shaft has a mass moment of inertia of 0 . 1 5 kg m 2 . If the shaft and the pulley coast to a...
-
4- Are these two code snippets different? Why or why not? if (show. funny) { System.out.println("This show is funny"); } else if (show.cartoon) { System.out.println("This is an animated show."); }...
-
Determine how economic indicators can explain economic fluctuations and growth, inflation, types of inflation, and how fiscal policy can be impacted by central banks.
-
Write a Python code WITHOUT USING NUMPY to generate a random matrix A of size m x n with m>n and calculate its Frobenius norm, II IIF. The entries of A must be of the form r.dddd (example 5.4316)....
-
When do you think you will stop working for pay? Do you think your level of spending and expenses will decrease when you retire? Why or why not? Does thinking about your future retirement make you...
-
Problem 3. Let ABC be a triangle. Let C' be the midpoint of theside AB. Let A' be a point on the side BC such that CA' = 2A'B.Let B' be a point on the line AC such that CB' = 4CA. Let M bethe point...
-
How can each of the elements in the physical work environment affect workers?
-
What policy did the not have here that they needed? In writing one, what should it include in order to be comprehensive?
-
Top management has called in a consultant for the area you work in. What action should you take to protect yourself and your interests?
-
The amount that will be accumulated in the future when a series of payments is invested and accrues interest until the future time. True/false
-
The amount that will be accumulated in the future when one amount is invested at the present time and accrues interest until the future time. True/false
-
Credit Terms You receive an invoice from a supplier for $5,000 on January 1 with terms 3/15, net 30. If you pay between January 1 and January 16, how much must you pay? If you pay after January 16,...
Study smarter with the SolutionInn App