Question
Pine Valley Case Exercises Development work on PVF's new customer tracking system is proceeding according to plan and is on schedule. The project team has
Pine Valley Case Exercises
Development work on PVF's 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 system's Customer Profile Form, Products by Demographics Summary Report, and Customer Purchasing Frequency Report.
Because you are not 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 system's 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.
- Develop logical data models for the form and two reports mentioned in the case scenario.
- Perform view integration on the logical models developed for part a.
- What view integration problems, if any, exist? How should you correct these problems?
- Have a fellow classmate critique your logical data model. Make any necessary corrections.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started