Case study models a mobile phone company

Assignment Help PL-SQL Programming

Reference no: EM132944382

MIS602 Data Modelling and Database Design

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:- Data Implementation.rar

Reference no: EM132944382

Questions Cloud

Create a work breakdown structure : Create a Work Breakdown Structure, a Project Management plan, and a Project Schedule in consultation with your team and to review documents based on team

Discuss relationship between external and internal auditors : Discuss relationship between external auditors, internal auditors and good governance practices. (review an articles to support the answer)

What would be the net A-R on the Balance Sheet : Assume you estimate 8% of Accounts Receivable to eventually become Bad Debts. What would be the net A/R on the Balance Sheet

Prepare journal entries for transactions for sampson corp : Prepare journal entries for the above transactions. The current market price of the common shares is $15 per share. Sampson Corporation has 100,000 common share

Case study models a mobile phone company : Case study models a mobile phone company. The company has a number of phones that are sold by staff to various clients

What the amount of the cash discount allowable : Merchandise is sold on account to a customer for $18,000. The terms are 1/10, n/30, FOB shipping point. What the amount of the cash discount allowable

How much in preferred dividends was paid : During the current year, common shareholders received a dividend distribution. How much in preferred dividends was paid during the current year?

Nature of an evolutionary development methodology : What is the nature of an evolutionary development methodology? In what ways are evolutionary methods different to those that are used for large-scale enterprise

Make december close income summary to retained earnings : Make December 31, close Income Summary to Retained Earnings assuming that Nevada had $63,000 of net income for the year

User Account

All Pages