Solution-What is the maximum number of subscriptions for a

What is the maximum number of subscriptions for a subscriber

Assignment Help Database Management System

Reference no: EM13950331

Meridian News publishes a daily newspaper and would like a database developed to maintain information about subscribers and subscriptions. Each subscriber is uniquely identified by a subscriber number and is also characterized by first name, last name, address, and phone number. Each subscription is uniquely identified by a subscription number and is also characterized by subscription type (Daily or Sunday only), price, start date, and expiration date. The price paid for a subscription is input when the subscription is sold, since it may vary due to special offers or situations. Expired subscriptions and former subscribers that no longer have a current subscription remain in the database.

The example report below shows the subscriptions belonging to subscriber number 31893.

1. Identify the entities discussed in the case?

2. What is the minimum number of current subscriptions for a subscriber?

3. What is the maximum number of subscriptions for a subscriber?

4. Using the Crow's Foot model, draw an ERD for the Meridian News database and state any assumptions you believe you have to make in order to develop a complete diagram.

Reference no: EM13950331

Questions Cloud

Percentage from your payments goes to is principle payment : Suppose you borrowed $12,000 at a rate of 9.0% and must repay it in 4 equal installments at the end of each of the next 4 years. How large would your payments be? For year 3, what percentage from your payments goes to is the principle payment?

Use each type of microscope : If you were looking for bacteria, Blepharisma, and Volvox in a sample of pond water, which type of microscope would you use to get a good image of each? Explain why you would use each type of microscope. (light microscope or electron microscope)

Call options intrinsic values and time premiums : What are the following call options' intrinsic values and time premiums if the price of the underlying stock is $55? Option strike price, Price of the call, Call at $50 $7.00 Call at $55 3.00 Call at $60 0.50

Calculate the depreciation expense : You are given the following information for Calvani Pizza Co.: sales = $38,000; costs = $21,000; addition to retained earnings = $5,000; dividends paid = $1,500; interest expense = $5,000; tax rate = 35 percent. Calculate the depreciation expense.

What is the maximum number of subscriptions for a subscriber : Using the Crow's Foot model, draw an ERD for the Meridian News database and state any assumptions you believe you have to make in order to develop a complete diagram.

Using the effective interest rate method of amortization : Consolidated Enterprises issues €10 million face value, five-year bonds with a coupon rate of 6.50 percent. At the time of issuance, the market interest rate is 6.0 percent. Using the effective interest rate method of amortization, the carrying value..

Reason for holding cash and cash equivalents : What is the reason for holding cash and cash equivalents? And which hybrid security has special claims on a corporation's profits or incase of liquidation of corporate assets?

Two projects should be chosen based on the payback method : X-treme Vitamin Company is considering two investments, both of which cost $10,000. Which of the two projects should be chosen based on the net present value method? Which of the two projects should be chosen based on the payback method?

Interpretation of the major structures : Interpretation of the major structures; constrained by analysis of data in Area A. There should be a discussion of any folding and/or faulting history and relationship(s) with igneous intrusions.

User Account

All Pages

What is the maximum number of subscriptions for a subscriber

Reference no: EM13950331

Reference no: EM13950331

Questions Cloud

Reviews

Write a Review

Database Management System Questions & Answers

Knowledge and data warehousing

Design a database schema

Entity-relationship diagram

Implement a database of courses and students for a school

Prepare the e-r diagram for the movie database

Design relation schemas for the entire database

Prepare the relational schema for database

Data modeling and normalization

Use cases perform a requirements analysis for the case study

Knowledge and data warehousing

Stack and queue data structure

Practice on topic of normalization

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT