Shuttle eze operates airport shuttle vans in twelve

Assignment Help Accounting Basics
Reference no: EM13883731

Shuttle Eze operates airport shuttle vans in twelve large cities. Those cities are Los Angeles, San Diego, San Francisco, Phoenix, Las Vegas, Houston, Dallas, Chicago, New York City, Washington D.C., Miami, and Orlando. Shuttle Eze operates passenger vans to shuttle travelers to and from the airports for a $25 fee per person.
Required:
a. Design the tables that the company would need in its database to operate these shuttles. Remember that they must collect, record, and track information about customers, payments, flights, gates, vans, drivers, pick up and delivery addresses. There may be other types of data not mentioned in the previous sentence that you would wish to add. The tables you design should have attributes (columns) for each critical piece of data. See Exhibit 13-4 for the concept of the table layouts. The tables you design should meet the first three rules of data normalization.
b. Describe the advantages and disadvantages of using a centralized database for Shuttle-Eze.

Reference no: EM13883731

Questions Cloud

What are some of the misconceptions of adhd : Can the symptoms change as the child ages? Can a child outgrow ADHD? What are some of the misconceptions of ADHD? Review behavioral management techniques that can be used to manage the symptoms of ADD/ADHD
Prepare the statement of cash flows of surmise company : Prepare the statement of cash flows of Surmise Company for the year ended December 31, 2013.
Cost straight-line to zero over the projects life : Romo Enterprises needs someone to supply it with 121,000 cartons of machine screws per year to support its manufacturing needs over the next five years, and you’ve decided to bid on the contract. It will cost you $880,000 to install the equipment nec..
Calculate optimal bundle of contingent claims : Tony Taxpayer earns $2000 in income. Income is taxed at 20%. Tony can underreport his income to the IRS and pay taxes only on the amount he reports, but should he be audited, the IRS will impose a surcharge of 200% on his unpaid taxes; Calculate Tony..
Shuttle eze operates airport shuttle vans in twelve : Shuttle Eze operates airport shuttle vans in twelve large cities Describe the advantages and disadvantages of using a centralized database for Shuttle-Eze.
Describe the incident and its environmental impact : Describe the incident and its environmental impact
What market structure best describes the pizza market : Consider the pizza market in a small college town with the following assumptions: The market is in long-run equilibrium. Each pizza shop sells 100 pizzas per week. (For ease of exposition, suppose that each shop sells only pizza and only one size.) W..
The values of the sysuptime in the system group : An SNMP manager sends a request for the values of the sysUpTime in the System group. Write the PDU with the fields filled in for the get-request PDU
What is the holding period return : Assume you short sell 300 share of the stock of EFG Corporation. Margin requirements are 60 percent. The price was $34 per share. One year later, the price of the stock is $35 per share. During that time, the company paid $0.75 per share in dividends..

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd