niverse604 Hi please help to create ERD diagram not handrawn but using online tools please include legends
Fantastic news! We've Found the answer you've been seeking!
Question:
niverse604
Hi please help to create ERD diagram not handrawn but using online tools please include legends
Transcribed Image Text:
Question 5: Conceptual Design (25 marks) "Tours Now" is a new family-owned business offering transport options for coach (Bus) tours in the Perth metropolitan area and selected regional areas. Tours Now has experienced significant growth in recent months due to a growing customer base from all different types. As the business expands its operations and services, they have recognized the need for an efficient relational database to keep track of their fleet, sales, vehicle maintenance, and information about passengers and staffing. ToursNow prides itself as having an extensive tour selection option which are available for charter 24 hours a day, seven days a week. More specific notes about Tours Now are listed below: Information about a route includes a unique code, its departing depot, its destination, and estimated departure and arrival times. To reduce costs, Tours Now only has non-stop charter tours with a single origin and destination. Tours are timetabled for a route on one or more dates with a Bus and staff assigned to each Tour, and the available seats (i.e., seats not taken) noted. In a staff deployment, the staff ID and the Role are recorded. It is a business requirement that the number of hours that Tour staff (i.e., Driver, Tour Guide, Tour Coordinator, etc...) are on a Tour must be noted. There is no such requirement for non-tour staff (e.g., maintenance crew, admin officers, operations staff, etc..). Buses have a registration number (rego), make, model, year, a capacity (number of passengers the bus can accommodate), and a scheduled- maintenance date. Question 5: Conceptual Design (25 marks) "Tours Now" is a new family-owned business offering transport options for coach (Bus) tours in the Perth metropolitan area and selected regional areas. Tours Now has experienced significant growth in recent months due to a growing customer base from all different types. As the business expands its operations and services, they have recognized the need for an efficient relational database to keep track of their fleet, sales, vehicle maintenance, and information about passengers and staffing. ToursNow prides itself as having an extensive tour selection option which are available for charter 24 hours a day, seven days a week. More specific notes about Tours Now are listed below: Information about a route includes a unique code, its departing depot, its destination, and estimated departure and arrival times. To reduce costs, Tours Now only has non-stop charter tours with a single origin and destination. Tours are timetabled for a route on one or more dates with a Bus and staff assigned to each Tour, and the available seats (i.e., seats not taken) noted. In a staff deployment, the staff ID and the Role are recorded. It is a business requirement that the number of hours that Tour staff (i.e., Driver, Tour Guide, Tour Coordinator, etc...) are on a Tour must be noted. There is no such requirement for non-tour staff (e.g., maintenance crew, admin officers, operations staff, etc..). Buses have a registration number (rego), make, model, year, a capacity (number of passengers the bus can accommodate), and a scheduled- maintenance date.
Expert Answer:
Related Book For
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George
Posted Date:
Students also viewed these databases questions
-
(All answers were generated using 1,000 trials and native Excel functionality.) Galaxy Co. sells virtual reality (VR) goggles targeted to customers who like to play video games. Galaxy procures each...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Midge is a 10% limited partner in Wild Catter, an oil and gas drilling partnership. She received her partnership interest in exchange for a $10,000 investment in the partnership. The balance in her...
-
The following is intended to explore what kinds of income-demand relationships are logically possible. A: For each of the following, indicate whether the relationship is possible or not and explain:...
-
The Swift Meal has two restaurants that are open 24 hours a day. Fixed costs for the two restaurants together total $ 456,000 per year. Service varies from a cup of coffee to full meals. The average...
-
Investment recommendation (Learning Objective 4) Take the role of an investment analyst at A. G. Edwards. It is your job to recommend investments for your client. The only data you have are the ratio...
-
You run a chain of movie theaters, so you commission a marketing study that categorizes your potential customers into 10 equal-sized groups according to what theyre willing to pay for a movie ($10,...
-
Consider each part below independently. ( Ignore income taxes in your calculations. ) Use the built - in PV functions for these calculations. Enter P V ( n ; i ) in a value box to calculate the...
-
ABC Company produces a chemical. At the start of the year, they had the following cost information: Direct material: (10 pounds @ $1.60) $16.00 Direct labor: (0.75 hours @ $18.00) $13.50 Variable...
-
Why does the direct write - off method of accounting for bad debts usually fail to match revenues and expenses? Why does the Bad Debts Expense account usually not have the same adjusted balance as...
-
You own a casino. Mike (who is head of games development for the casino) proposes a new game whereby the player to throw a 6-sided die and a 12-sided die and the sum of the dice is considered. [4]...
-
To demonstrate the power of our statuses over our behavior, look at Milgram's Obedience Study Why did the study participants continue to administer electric shocks? What would you have done? A study...
-
It is given that the volume of a size 5 football is larger than that of a size 4 football by 72.8%. a) find the ratio of the radius of the size 5 football to that of the size 4 football. b) find the...
-
You are considering an investment in Fields and Struthers, Inc., and want to evaluate the firm s free cash flow. From the income statement, you see that Fields and Struthers earned an EBIT of $ 8 2...
-
Statement of financial position at the start of the week: ASSETS $ Property 380,000 Office Equipment 140,000 Inventories 85,000 Trade Receivables 75,000 Total assets 680,000 EQUITY AND LIABILITIES $...
-
Could the owner of a business prepare a statement of financial position on 9 December or 23 June or today?
-
Prepare a flexible budget for planning (Learning Objective 1) Lasting Bubbles produces multicolored bubble solution used for weddings and other events. The companys static budget income statement for...
-
Comprehensive flexible budget, standards, and variances problem (Learning Objectives 2, 3,4, 5) One System assembles PCs and uses flexible budgeting and a standard cost system. One System allocates...
-
Work backward through labor variances (Learning Objective 4) Amandas Music manufactures harmonicas. Amanda uses standard costs to judge performance. Recently, a clerk mistakenly threw away some of...
Study smarter with the SolutionInn App