Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A telecommunication company provides telecom services and it wants to record the following business information for better operation. Each customer can choose the company as

A telecommunication company provides telecom services and it wants to record the following
business information for better operation.
Each customer can choose the company as their telecom carrier by themselves or be invited
by an existing customer, and an existing customer can refer many potential customers. Every
customer has a unique account number. Their name, address, telephone number, invitation
number are important information for the business operation.
The company provides many programs for the customer to choose. The programs are
identified by their id, type, duration and price. A customer has to join one and only one
program.
The company also provides several promotions from time to time, customers are free to join
many of them but one at a time. The information of promotion id, type, start date, end date,
price is very important information for both the company and the customers.
Please design a simplified data model for the company and help it better record the data for
business operations.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions