Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
a) Maya Media owner plans to build a Java program which uses an input file for storing the subscription records. Explain to Maya Media about the disadvantages of the traditional file system approach if the three branches need to share information. Clarify the advantages of a database approach with regards to the matter. b) Represent the requirements as displayed in Figure 1 using an Entity-Relationship diagram (ERD). Add any two new attributes suitable to enhance the subscription information. c) Transform the ERD produced from question b into relational model form. d) Explain the impact of the following statement to your database design. "Expired subscriptions and former subscribers that no longer have a current subscription remain in the database." Draw the new ERD which represent this statement and determine the mapping into relational model.

a) Maya Media owner plans to build a Java program which uses an input file for storing the subscription records. Explain to Maya Media about the disadvantages of the traditional file system approach if the three branches need to share information. Clarify the advantages of a database approach with regards to the matter. b) Represent the requirements as displayed in Figure 1 using an Entity-Relationship diagram (ERD). Add any two new attributes suitable to enhance the subscription information. c) Transform the ERD produced from question b into relational model form. d) Explain the impact of the following statement to your database design. "Expired subscriptions and former subscribers that no longer have a current subscription remain in the database." Draw the new ERD which represent this statement and determine the mapping into relational model.

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question

Answer D and E only

 

** ERD attached (the second picture)

 

** Relational model:

 

c) Entity Relationship to Relational Model:

To convert the given diagram to a relational model, below are the steps: 

Create Relations from Diagram:

The relations in the model are as below: 

1. Subscriber: (SubscriberID, Name, Address, Email, Phone)

2. SubscriptionTypes(TypeCode, Name, Description, DuartionDays)

3. Subscriptions(SubscriptionID, Price, StartDate, EndDate)

 

Solve the relationships by adding referential integration:

1) Subscription will have one Subscriber: Thus add a new foreign key SubscriberID

2) Subscription will have one SubscriptionType, thus add a new foreign key TypeCode.

 

FINAL RELATIONAL MODEL

1. Subscriber: (SubscriberID, Name, Address, Email, Phone)

Primary key: SubscriberID

Foreign key: NA

 

2. SubscriptionTypes(TypeCode, Name, Description, DuartionDays)

Primary key: TypeCode (Either D or S)

Foreign key: NA

 

3. Subscriptions(SubscriptionID, Price, StartDate, EndDate, TypeCode, SubscriberID)

Primary key: SubscriberID

Foreign key: TypeCode from SubscriptionTypes, SubscriberID from Subscriber

Address Name SubscriberID Email TypeCode Name Phone Subscription Type Description Subscriber (1,M) (1,1) DurationinDays makes belongs to (1,M) (1,M) SunscriptionID Subscription EndDate Price StartDate
Transcribed Image Text:Address Name SubscriberID Email TypeCode Name Phone Subscription Type Description Subscriber (1,M) (1,1) DurationinDays makes belongs to (1,M) (1,M) SunscriptionID Subscription EndDate Price StartDate
Question 1: (DATABASE APPLICATION DEVELOPMENT) Maya Media publishes a daily newspaper and would like an application to be developed to maintain information about subscribers and subscriptions. Maya Media has 3 different branches that have to access the information. Each subscriber is uniquely identified by a subscriber number and is also characterized by name, postal address, email 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 shall be deleted from the database. The example report below shows the subscriptions belonging to subscriber number 21567. Date printed is not stored in the database. Name: Anita Hashim Date Printed: 06/08/2007 Address: Email: Telephone: 15 Jalan Darat, Kajang, 43640 anita1234@gmail.com Selangor 03-85432163 Subscriber#: 21567 Subscription# Туре Price Start End 144134 RM52.00 01/01/2006 31/12/2006 145234 D RM95.00 01/01/2007 30/06/2007 145876 D RM80.00 01/07/2007 31/12/2007 Figure 1: Subscription report a) Maya Media owner plans to build a Java program which uses an input file for storing the subscription records. Explain to Maya Media about the disadvantages of the traditional file system approach if the three branches need to share information. Clarify the advantages of a database approach with regards to the matter. b) Represent the requirements as displayed in Figure 1 using an Entity-Relationship diagram (ERD). Add any two new attributes suitable to enhance the subscription information. c) Transform the ERD produced from question b into relational model form. d) Explain the impact of the following statement to your database design. "Expired subscriptions and former subscribers that no longer have a current subscription remain in the database." Draw the new ERD which represent this statement and determine the mapping into relational model. e) Does normalization need to be performed on your database design? Explain your answer.
Transcribed Image Text:Question 1: (DATABASE APPLICATION DEVELOPMENT) Maya Media publishes a daily newspaper and would like an application to be developed to maintain information about subscribers and subscriptions. Maya Media has 3 different branches that have to access the information. Each subscriber is uniquely identified by a subscriber number and is also characterized by name, postal address, email 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 shall be deleted from the database. The example report below shows the subscriptions belonging to subscriber number 21567. Date printed is not stored in the database. Name: Anita Hashim Date Printed: 06/08/2007 Address: Email: Telephone: 15 Jalan Darat, Kajang, 43640 anita1234@gmail.com Selangor 03-85432163 Subscriber#: 21567 Subscription# Туре Price Start End 144134 RM52.00 01/01/2006 31/12/2006 145234 D RM95.00 01/01/2007 30/06/2007 145876 D RM80.00 01/07/2007 31/12/2007 Figure 1: Subscription report a) Maya Media owner plans to build a Java program which uses an input file for storing the subscription records. Explain to Maya Media about the disadvantages of the traditional file system approach if the three branches need to share information. Clarify the advantages of a database approach with regards to the matter. b) Represent the requirements as displayed in Figure 1 using an Entity-Relationship diagram (ERD). Add any two new attributes suitable to enhance the subscription information. c) Transform the ERD produced from question b into relational model form. d) Explain the impact of the following statement to your database design. "Expired subscriptions and former subscribers that no longer have a current subscription remain in the database." Draw the new ERD which represent this statement and determine the mapping into relational model. e) Does normalization need to be performed on your database design? Explain your answer.
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS