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...
-
Back Mountain Industries (BMI) has two divisions: East and West. BMI has a cost-of-capital of 15%. Selected financial information (in thousands of dollars) for the first year of business follows: a...
-
Acme Movers charges $100 plus $30 per hour to move a household across town. Hank's Movers charges $55 per hour. For what lengths of time does it cost less to hire Hank's Movers?
-
Presented below are the financial statements of two companies that are identical in every respect except the method of valuing their inventories. The method of valuing inventory is LIFO for the LIFO...
-
The shareholders' equity section of Superior Corporations balance sheet as of December 31, 2015, is as follows: The following events occurred during 2016: Jan. 5 10,000 shares of authorized and...
-
2.27 (suite) a) Dpouillez ces donnes suivant une distribution de frquences absolues dont la limite infrieure de la premire classe est 40, et dont l'amplitude de chaque classe est de 12. Indiquez...
-
For the circuit shown in Fig. P1.78, first evaluate Ti (s) = Vi (s)/Vs (s) and the corresponding cutoff (corner) frequency. Second, evaluate To (s) = Vo (s)/Vi (s) and the corresponding cutoff...
-
How do you calculate the total cost of cost B at a 40% utilization with a variable cost per hour of $12.64
-
How can it be argued that, since Reconstruction, criminal law has been defined and used against racialized groups in the U.S.?Cite case examples
-
20. Creative Ammo currently makes and sells 5.7 x 28 bullets (3 pts) Information related to its revenue and costs are listed below: Sales Variable costs Fixed costs $ 15,151.15 $ 10,100.10 3,333.32...
-
In the context of NoSQL databases, elucidate the trade-offs between different consistency models, such as eventual consistency, strong consistency, and causal consistency, with regard to scalability,...
-
Why is knowing (or estimating) the product demand so crucial for a firm? What are the differences between estimating and forecasting demand? Peer Post: The importance of knowing product demand in...
-
Explain how structural fatigue can be pilot induced. In your response, briefly explain some classical field evidence that "might" distinguish between progressive and instantaneous fatigue and the...
-
1-3 Final Project Milestone One: Company Case Study Selection Submit the name of the company you have chosen to use as a comparative model for your Final Project. Answer the first question of the...
-
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?
-
Graham Inc. acquired all of the outstanding shares of Mahoney Inc. through an exchange of common shares. The aggregate fair value of the Graham shares distributed to the Mahoney shareholders was...
-
After an intense period of negotiation, Global Enterprises Corporation TA 2, 3 agreed to purchase all of the outstanding common shares of The Carlton Corporation. The agreed-upon price was \($294\)...
-
Aussie Steaks Inc. operates a chain of steak restaurants in the United States. On January 1, 2015, the company had \($500\) million in assets. On January 1, 2015, the company acquired 25 percent of...
Study smarter with the SolutionInn App