Question: please solve this problem asap Considet the following situation. Pine Valley Furniture Compary (PVFG is a smal manufacturer of case goods furniture that is, all
Considet the following situation. Pine Valley Furniture Compary (PVFG is a smal manufacturer of case goods furniture that is, all wood furniture as opponed to ciphoistered fumiture). The compary has a namber of product ines inctuding dinette sets, wat units, dests, Bookcases, wall units, ining room and bedroom furniture. PVFC markets its furrature to a wide variety of retail outlets. At the present time the compary has 50 employees, about 500 customers getal fumitute stotes induding some large chains, and sales have been increasing by 25% per year. Orders are tranemitted by muit, fax, or taken over the phone. A typical Customer Order is shown below. PVF C asants an application to capture its cuatomer onders in a dafabase and to be able to query the database for quentions of interest Of interest is the abihty to get rid of the paper copies and to be able to re-print a castomer order at anyime in the fulure. Give the ERO for a databsse design that would allow capturing such customer orders over time. Do not introduce additionil attributes/dafa fielas beyond what as shown in the sample customer order below and the above description. Upload/attach your ERDPlus expert diagram file ai well an the exported image file here. 2 Files are expected
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
