Reference no: EM13877563
Chapter case from book "Systems Analysis and Design".
Chapter Case- Scenic Routes
Scenic Routes operates a bus company that specializes in travelling on secondary roads, rather than Interstate highways. Their slogan is: "It Takes a Little Longer, But It's Scenic." The firm needs to update its passenger reservation system.
Background
Data items must include reservation number, Route Number, Date, Origin, Destinations, Departure Time, Arrival Time, Passenger Name, and Seat Number. For example, Route 97 leaves Monroe, VA, daily at 8:00 A.M. and arrives in Spencer, VA, 100 miles away, at 11:00 A.M. Scenic wants to use an alphabetic reservation code, similar to the codes that airlines use.
Tasks-
1. Identify the entities and their relationships. Then create an ERD for the reservations system.
2. Create 3NF table designs for the system.
3. For each of the entities identified, design tables and identify the possible candidate keys, the primary key, a probable foreign key, and potential secondary keys.
4. Use sample data to populate the fields for three records.
|
Medieval culture
: MEDIEVAL CULTURE, Write a five page essay paper. 12pt Font. Times new Roman. The paper is to cover Charlemagne, Regulated day in the monastery,Woman and the monastic life, Music and Monasticism, Rise of drama, Charlemagne's death/Legend
|
|
Record income taxes on may net income
: For each of the transactions prepare journal entries, using the date of the transaction as the reference. Calculate NGS's preliminary net income and net profit margin for the month. Which of the following best describes the adjustment(s) that will ha..
|
|
Solve the model for the equilibrium income
: Consider the following model of income determination: Y = C + I + G0 , C = C0 + bY D , I = I0 + iY T = tY - Solve the model for the equilibrium income. What is the model multiplier.
|
|
Consider manufacturing processes observed in itrs plant
: Consider the manufacturing processes observed in ITR's Ontario plant. What recommendations do you think Bryan and Kristen should make?
|
|
Create 3nf table designs for the system
: Identify the entities and their relationships. Then create an ERD for the reservations system. Create 3NF table designs for the system
|
|
Is the budget in this economy balanced
: Consider an open economy with the following consumption and tax functions: C = 5 + 0.75YD , T = 0.20Y Assume I0 = 100; G0 = 110; X0 = 90 and M0 = 105 - Find the equilibrium output.
|
|
Determine qcis preliminary net income
: Quick Cleaners, Inc. (QCI) has been in business for several years. It specializes in cleaning houses but has some small business clients as well. Prepare journal entries for the following transactions, which occurred during a recent month, and determ..
|
|
Determine the best option for cure-all inc
: For the sale of the patent, Cure-all would receive $300,000,000 now and $25,000,000 at the end of every year for the next five years. Determine the best option for Cure-all Inc.
|
|
Contrast and compare the supply chains
: 1. Contrast and compare the supply chains required for the private label eBags and those drop-shipped directly from the manufacturers. Answer in the context of the case. 2. If eBags were to enter the footwear business, what new supply chain managemen..
|