Develop logical data models for the form

Assignment Help Electrical Engineering

Reference no: EM131406572

Pine Valley Furniture

Pine Valley Furniture Development work on Pine Valley Furniture'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 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 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.

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.

c. What view integration problems, if any, exist? How should you correct these problems?

d. Have a fellow classmate critique your logical data model. Make any necessary corrections.

Reference no: EM131406572

Questions Cloud

Reducing the physical hardware needed : Discuss how server virtualization has saved many organizations money by reducing the physical hardware needed. Using Microsoft® Excel® to do your calculations, create a Return on Investment (ROI) analysis comparing the cost of 10 physical servers t..

How about internal and external threats : List and Describe the methods firms use to ensure the integrity of their software, their hardware, their networks, and their partners?Was Hardware, Software and Networks addressed?Was Wired and Wireless addressed?How about Internal and External thre..

What conduct is expected from employees : What conduct is expected from employees? Your minimum 10 slides should be original work involving your company (or a friend or a relative's).

Did you articulate how a firm reconciles the risks : To receive full credit you must satisfy the following criteria:Did you articulate the risks for applying and not applying a software patch, at least 4?Did you articulate how a firm reconciles the risks?

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

Analyze how language changes over long periods of time : Describe phonology, morphology, syntax, semantics, and phonetics in a dialect or a language and analyze how language changes over long periods of time and the use of human languages for communication between computers and people.

Which algorithm is used in this structure : Find out which file organizations are used in different database management systems at your university. Also discuss why they chose a particular structure. Is there any application of hashed file organization? Which algorithm is used in this struc..

Create a mission statement for the below cleaning company : Create a mission and vision statement for the below cleaning company. Must be 100 words for mission and 100 words for vision.

What potential challenges exist for using mi-fi for business : The interconnected world as most students know it - with easy and often free access to the Internet from home, school, the coffee shop, the airport, and even on the train- is actually fairly recent. We used to need cables (wires) to connect to oth..

User Account

All Pages