Consider the following set of normalized relations from a database used by a mobile service provide to keep track of its users and advertiser customers

Consider the following set of normalized relations from a database used by a mobile service provide to keep track of its users and advertiser customers.

USER (UserID, UserLName, UserFName, UserEmail,  UserYearOfBirth, UserCategoryID, UserZip)

ADVERTISERCLIENT (ClientID, ClientName,  ClientContactID, ClientZip)

CONTACT (ContactID, ContactName, ContactEmail,  ContactPhone)

USERINTERESTAREA  (UserID, InterestID,  UserInterestIntensity)

INTEREST (InterestID, InterestLabel) C

CATEGORY (CategoryID, CategoryName,  CategoryPriority)

ZIP (ZipCode, City, State)

 

Question: Identify possible opportunities for denormalizing these relations as part of the physical design of the database. Which ones would you be most likely to implement?

Complete Answer:

Get Instant Help in Homework Asap
Get Instant Help in Homework Asap
Calculate your paper price
Pages (550 words)
Approximate price: -