Reference no: EM13188942
The database tracks subscribing accounts, cable services subscribed, channel line-up, and pricing. The following detailed information requirements need to be represented by ERD.
Database should store information about each current or past subscriber, such as first name, last name, subscribing address, billing address, and phone number. Each subscriber is assigned a unique account Id. A current subscriber is one who currently has cable services installed. A past subscriber is one who once had cable but now has disconnected. Installation date and disconnection date, if disconnected, should also be stored in the database. When a subscriber disconnects and later reinstalls, he'll be given a new account id. When a subscriber moves to a new address, he'll also be given a new account Id.
Cable market is divided into different submarkets (e.g. East, West, North, South, and Central). The submarket divisions are exclusive, that is, a subscription address can only belong to one submarket. Each submarket has a unique name.
The cable company offers 3 levels of services to all customers in all submarkets: basic, standard, and premium. The Basic service contains a group of about 10 channels; the Standard, about 25 channels; and the Premium, about 60 channels. The Standard consists of all channels offered at the Basic level, plus some more. The Premium consists of all channels offered at the Standard level, plus some more. The channel packaging is the same across all submarkets and all accounts. The database needs to store information about how channels are packaged. This information may change from time to time. However, only the current packaging is stored.
Information about channels include unique channel name (e.g. A&E), current channel line up number (e.g. 41), and offering company name (e.g. AETN). The channel line-up is the same across all submarkets and all accounts. The channel line-up may change from time to time. However, only the current lineup is stored. (Notice the difference between "channel name" and "channel line up number." When we say "Channel 41 is A&E," we mean "A&E programming is sent through the band of frequencies denoted by the number 41.")
Monthly subscription fee for a particular level of service (say, the Basic) is the same across all markets. Of course, higher level of services cost more than lower levels.
A subscriber account can only subscribe to one level of service.
The database should record information about channels, channel line up, service packaging, service pricing, and subscription levels, as described above.
|
What would you expect from duffs stock price
: Duff Inc. paid a 2.06 dollar dividend today. If the dividend is expected to grow at a constant 4 percent rate and the required rate of return is 7 percent, what would you expect Duff's stock price to be 3 years from now
|
|
Project process groups
: You're familiar with the PMBOK and its five project process groups. Have you applied them on other projects? How do you envision those processes and phases applying to your trade show project at LRH? Explain which, if any phases will be more complica..
|
|
Prepare a report explaining the possible methods
: Prepare a report explaining the possible methods that can be adopted in this particular scenario, resources required for the methods chosen for this investigation, approximate budget to conduct the investigation
|
|
Find the covariance between x and y
: find the covariance between hourly wage X and education Y (measured in years of schooling) using the following summary statistics for a sample of 10 workers in a plant. xbar = 11.775 ybar=13.8 sum of (x-xbar)(y-ybar) = 103.55 sum of xy =1728.5
|
|
Database tracks subscribing accounts-channel line-up-pricing
: The database tracks subscribing accounts, cable services subscribed, channel line-up, and pricing. The following detailed information requirements need to be represented by ERD.
|
|
Determine gdp by both the expenditures and income approaches
: Then determine NDP. The Expenditure approach equals out to $361 Billion, the way to find this is to add up all the expenses, and the Income approach equals out to $380 billion and the way to find this part is to add up all the income. With that de..
|
|
Create a project scope management plan
: Create a project scope management plan that will detail how the project scope will be defined, managed, and controlled to prevent scope creep. The plan may also include how the scope will be communicated to all stakeholders.
|
|
What factors might these types of stores have in common
: Like supermarkets, full-service department stores like Macy's are generally in decline. What factors might these types of stores have in common behind their declines How would you determine which were important and which were not
|
|
What factors give rise to the varying levels of market power
: Many MBAs who ventured into the "dot.com" world of the late 1990s found themselves unemployed by 2001 as many firms in that industry ceased to exist. However, during their tenure with these companies, these managers gained valuable skills in how t..
|