Development work on Pine Valley Furnitures new customer tracking system is proceeding according to plan and is on schedule. The project team has been busy designing the human interfaces, and you have just completed the new tracking systems Customer Profile Form, Products by Demographics Summary Report, and Customer Purchasing Frequency Report. Because you are now ready for a new task, Jim Woo asks you to prepare logical data models for the form and two reports that you have just designed and drop them by his office this afternoon. At that time, the two of you will prepare a consolidated database model, translate the customer tracking systems E-R data model into normalized relations, and then integrate the logical data models into a final logical data model for the customer tracking system.

a. Develop logical data models for the form and two reports mentioned in the case scenario.

b. Perform view integration on the logical models developed for part a

Customer Profile PK11 CustomerlD Name Primary Address Alternative Address Phone Fax BuyerName EmailAddress SchoolAffiliation DOB Gender FirstPurchaseDate Annuallncome CustomerT ype MaritalStatus Occupation Dependents InitialContact Promotion PromotionDescription BegnningDate EndingDate SelectedPromotion PKFK1,12,11 CustomerlD PKFK2,13,14 PromotionlD Inventory Order PK SKU PK PK.FK1,11 CustomerlD ProductName Description Material Color Price LeadTime OrderDate ShipDate OrderDetails PK,FK2,123 OrderlD PK,FK2 PK,FK1J1SKU ustomerID Quantity Promotedltem PK,FK2,12 PK,FK1,11 SKU Customer Profile PK11 CustomerlD Name Primary Address Alternative Address Phone Fax BuyerName EmailAddress SchoolAffiliation DOB Gender FirstPurchaseDate Annuallncome CustomerT ype MaritalStatus Occupation Dependents InitialContact Promotion PromotionDescription BegnningDate EndingDate SelectedPromotion PKFK1,12,11 CustomerlD PKFK2,13,14 PromotionlD Inventory Order PK SKU PK PK.FK1,11 CustomerlD ProductName Description Material Color Price LeadTime OrderDate ShipDate OrderDetails PK,FK2,123 OrderlD PK,FK2 PK,FK1J1SKU ustomerID Quantity Promotedltem PK,FK2,12 PK,FK1,11 SKU