Case study - data implementation

Reference no: EM132944223

Data Modelling and Database Design Assessment

Data Implementation - Case Study

The following case study models a mobile phone company. The company has a number of phones that are sold by staff to various clients. Each phone comes with a plan and each plan has a number of features specific to that plan including:

- a call charge in cents per minute (this does not apply to all plans)
- a plan duration in months
- a break fee if the customer leaves the plan before the end of the plan duration
- a monthly data allowance in gigabytes

Assumptions that are made for the assignment are:
- mobile phones are locked to a plan for the length of the plan duration

Attachment:- Database SQL.zip

Reference no: EM132944223

Questions Cloud

What are the monthly payments on the loan : You are planning to buy a new house. You currently have $35,000. How much do you pay on interest and principal the 50th monthly payment?

When will have enough money for the down payment : When will you have enough money for the down payment and closing costs, assuming that the $35,000 is the only investment that you make?

What is the amount of revenue to be recognized : What is the amount of revenue to be recognized in relation to the use of delivery of raw materials for the year ended December 31, 2020

Convert an estimate to a purchase order in quickbooks online : What is the best practice sequence of steps to convert an estimate to a purchase order in QuickBooks Online? Left Navigation Bar > Expenses > down arrow

Case study - data implementation : Data Modelling and Database Design Assessment

Prepare current and long-term liability sections of december : Prepare the current and long-term liability sections of the December 31, 2021, balance sheet. Trade accounts payable on that date were $324,000.

What is the available quality recognition labels : What is the available quality recognition labels available here in thecountry.

What total cash received from customers during the year : Instead of using T-accounts, think about how you would derive cash flows from net income.] Total cash received from customers during the year

Find the total tax expense during the year : Find the Total tax expense during the year. All changes in deferred tax balances were due to deferred tax benefits or expenses.

User Account

All Pages