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 SubscriberID2) Subscription will have one SubscriptionType, thus add a new foreign key TypeCode. FINAL RELATIONAL MODEL1. Subscriber: (SubscriberID, Name, Address, Email, Phone)Primary key: SubscriberIDForeign 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: SubscriberIDForeign key: TypeCode from SubscriptionTypes, SubscriberID from Subscriber Question 1:(DATABASE APPLICATION DEVELOPMENT)Maya Media publishes a daily newspaper and would like an application to bedeveloped to maintain information about subscribers and subscriptions. Maya Mediahas 3 different branches that have to access the information. Each subscriber isuniquely identified by a subscriber number and is also characterized by name, postaladdress, email and phone number. Each subscription is uniquely identified by asubscription number and is also characterized by subscription type (Daily or Sundayonly), price, start date, and expiration date. The price paid for a subscription is inputwhen the subscription is sold, since it may vary due to special offers or situations.Expired subscriptions and former subscribers that no longer have a currentsubscription shall be deleted from the database. The example report below shows thesubscriptions belonging to subscriber number 21567. Date printed is not stored in thedatabase.Name: Anita HashimDate Printed: 06/08/2007Address:Email:Telephone:15 Jalan Darat, Kajang, 43640 anita1234@gmail.comSelangor03-85432163Subscriber#: 21567Subscription#ТуреPriceStartEnd144134RM52.0001/01/200631/12/2006145234DRM95.0001/01/200730/06/2007145876DRM80.0001/07/200731/12/2007Figure 1: Subscription reporta) Maya Media owner plans to build a Java program which uses an input file for storingthe subscription records. Explain to Maya Media about the disadvantages of thetraditional 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-Relationshipdiagram (ERD). Add any two new attributes suitable to enhance the subscriptioninformation.c) Transform the ERD produced from question b into relational model form.d) Explain the impact of the following statement to your database design. "Expiredsubscriptions and former subscribers that no longer have a current subscriptionremain in the database." Draw the new ERD which represent this statement anddetermine the mapping into relational model.e) Does normalization need to be performed on your database design? Explain youranswer. AddressNameSubscriberlDEmailТуреСodeNamePhoneSubscription TypeDescriptionSubscriber(1,M)(1,1)DurationinDaysmakesbelongs to(1,M)(1,M)SunscriptionIDSubscriptionEndDatePriceStartDate

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 SubscriberID2) Subscription will have one SubscriptionType, thus add a new foreign key TypeCode. FINAL RELATIONAL MODEL1. Subscriber: (SubscriberID, Name, Address, Email, Phone)Primary key: SubscriberIDForeign 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: SubscriberIDForeign key: TypeCode from SubscriptionTypes, SubscriberID from Subscriber Question 1:(DATABASE APPLICATION DEVELOPMENT)Maya Media publishes a daily newspaper and would like an application to bedeveloped to maintain information about subscribers and subscriptions. Maya Mediahas 3 different branches that have to access the information. Each subscriber isuniquely identified by a subscriber number and is also characterized by name, postaladdress, email and phone number. Each subscription is uniquely identified by asubscription number and is also characterized by subscription type (Daily or Sundayonly), price, start date, and expiration date. The price paid for a subscription is inputwhen the subscription is sold, since it may vary due to special offers or situations.Expired subscriptions and former subscribers that no longer have a currentsubscription shall be deleted from the database. The example report below shows thesubscriptions belonging to subscriber number 21567. Date printed is not stored in thedatabase.Name: Anita HashimDate Printed: 06/08/2007Address:Email:Telephone:15 Jalan Darat, Kajang, 43640 anita1234@gmail.comSelangor03-85432163Subscriber#: 21567Subscription#ТуреPriceStartEnd144134RM52.0001/01/200631/12/2006145234DRM95.0001/01/200730/06/2007145876DRM80.0001/07/200731/12/2007Figure 1: Subscription reporta) Maya Media owner plans to build a Java program which uses an input file for storingthe subscription records. Explain to Maya Media about the disadvantages of thetraditional 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-Relationshipdiagram (ERD). Add any two new attributes suitable to enhance the subscriptioninformation.c) Transform the ERD produced from question b into relational model form.d) Explain the impact of the following statement to your database design. &#34;Expiredsubscriptions and former subscribers that no longer have a current subscriptionremain in the database.&#34; Draw the new ERD which represent this statement anddetermine the mapping into relational model.e) Does normalization need to be performed on your database design? Explain youranswer. AddressNameSubscriberlDEmailТуреСodeNamePhoneSubscription TypeDescriptionSubscriber(1,M)(1,1)DurationinDaysmakesbelongs to(1,M)(1,M)SunscriptionIDSubscriptionEndDatePriceStartDate

Accepted Answer

a) Maya Media owner plans to build a Java program which uses an input file for storing the…