Pine valley furnituredevelopment work on pine valley, Ask an Expert

Accounting

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 da- tabase model, translate the customer track- ing 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.

View complete question

Accounting Basics, Accounting

Category:- Accounting Basics
Reference No.:- M91722142

Have any Question?Write your Review or question?

Related Questions in Accounting Basics

Question - you are the controller of harmon oil a

Question - You are the Controller of Harmon Oil, a medium-sized oil exploration company in Texas. It is time to make a forecast of the company's annual earnings. You know that additional losses will be recognized before ...

Question - alex acquires a residential rental property on

Question - Alex acquires a residential rental property on June 1, 2018 at a total cost of $423,000. Of this total, $132,000 can be allocated to the value of the land. He immediately spends $42,000 to make major improveme ...

Question based on your understanding of financial statement

Question: Based on your understanding of financial statement analysis, of the three statements (Income Statement, Balance Sheet, Statement of Cash Flows) which statement do you think is the most important and why? The re ...

Question - a bond has a 7 coupon and pays interest

Question - A bond has a 7% coupon and pays interest semi-annually. What is the amount of each interest payment if the face value of a bond is $1,000?

Question - kingbird enterprises owns the following assets

Question - Kingbird Enterprises owns the following assets at December 31, 2017. Cash in bank - savings account 70,600 Checking account balance 20,800 Cash on hand 8,300 Postdated checks 840 Cash refund due from IRS 34,50 ...

Question - alpha technology produces two products a high

Question - Alpha Technology produces two products: a high end laptop under the label Excellent Laptops and an inexpensive desktop under the label Outstanding Computers. The two products use two overhead activities, with ...

Question - the following information pertains to hagen

Question - The following information pertains to Hagen Metal Work's ending inventory for the current year: Item Quantity Unit Cost Unit Market Value C 90 $24 $16 D 75 22 20 K 40 25 28 M 22 15 17 Required - a. Determine ...

Question - at the beginning of 2016 pioneer products

Question - At the beginning of 2016, Pioneer Products' ownership interest in the common stock of LLB Co. increased to the point that it became appropriate to begin using the equity method of accounting for the investment ...

Question - dan bought a hotel for 2600000 in january 2012

Question - Dan bought a hotel for $2,600,000 in January 2012. In May 2016, he died and left the hotel to Ed. While Dan owned the hotel, he deducted $289,000 of cost recovery. The fair market value in May 2016 was $2,800, ...

Question using the readings about the differences between

Question: Using the readings about the differences between managers and leaders, and grounded in strategic planning, how can one take a leadership role in making yours a plan that works? The response must be typed, singl ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Accounting Basics Expert