a) Draw an ER diagram for the relational schema: Customer (cid, name, address) Magazine (title, publisher, topic, frequency, url) Pricing (title, publisher, period, offer, price) foreign key (title, publisher) references Magazine Subscribes (cid, title, publisher, offer, from, period) foreign key (cid) references Customer, foreign key (title, publisher, period, offer) references Pricing The attribute "period" in Pricing tells the number of years for the subscription. The attribute "frequency" in Magazine tells how often the magazine is published (weekly, monthly, etc.). The attribute "from" in Subscribes tells when the subscription for the customer commences. b). How would your diagram change if you generalize the database to also model subscriptions to newspapers? Propose entities/relations and draw a corresponding schema. CS.VS. 1058