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. The date printed is not stored in the database. a)Maya Media owner plans to build a Java program that uses an input file for storing the subscription records. Explain to Maya Media 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 on your database design. Expired subscriptions and former subscribers that no longer have a current subscription remain in the database. Draw the new ERD which represents this statement, and determine the mapping into a relational model. E)Does normalization need to be performed on your database design? Explain your answer. !! This is second-time post this question Give me the ERD and rational form. !! FULL ANSWER