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?
2. 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.
Computer Science Homework Solutions
#41298
Intro to database - Crow's Foot model; ERD; Entities
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 (attached) 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?
2. 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.
What is this?
By OTA - Overall OTA Rating
Suraj Joshi, PhD (IP) - 4.7/5
Purchase Cost Now
$2.19 CAD (was ~$7.98)
Included in Download
- Plain text response
- Attached file(s):
- database.doc
Why you can trust BrainMass.com
- Your Information is Secure
- Best Online Academic Help Service
- Students find real academic Success
- SQL Replication - This project will challenge you to set up replication on your SQL Server installation. Every step to complete this process is not laid out for you here. Complete the steps and document your choices th ...
- Use SQL Management Studio Express 2005 to create a database - See attached file for full problem description.
- Database Management - Draw an E-R Diagram showing each entity, its attributes, and it relationships to the other entities. State any assumptions you make. Also Describe your usage of the mailing list, including the dates a ...
- A workbook can contain more than one worksheet. - A workbook can contain more than one worksheet. Can you give an example of a spreadsheet application where it would be necessary to have more than one worksheet, can you explain how that works?
- Sql Server 2005 Express - I am having trouble creating A View in SQL Server 2005 using the following table. I have selected subscriber_id and magazine_id, but I cannot create the correct code to complete the view. See at ...
