According to the information of the webstore of pine valley furniture (PVF) posted blow, design an E-R diagram for PVF Webstore
Background of Pine Valley Furniture PvF Pine Valley Furniture PVF) Company manufacturing high-quality wood furniture and distributes it t retail stores within the United States. Its product lines include dinette sets, stereo cabinets, wall units. living room furniture, and bedroom furniture. In the early 198os, PvF's founder, Alex Schuster, started to make and sell custom furniture in his garage. By 1984, business expanded and Alex had to rent a warehouse. Then PVF's product line had multiplied, sales volume had doubled, and staff had increased o fifty employees. By 1990, PVF moved into its third and present location. of the added ty of the company's operations, Alex the company into the following functional areas: manufacturing, and and installed minicomputer to automate invoicing, account receivable, and inventory control applications e 1990s, PVF management decided to convert its information systems to a database management system. The computer-based applications at su business pport its processes. When customers order customer and must be must and shipped the the right mailed to the right address. have to paid work Given these most of PVF's applications are located in the accounting and financial areas. The applications include order filling, invoicing, accounts receivable, inventory control, accounts payable, payroll, and general ledger. With PVF's new centralized database, data are organized around entities, or subjects, such as customers, invoices, and orders. Recently, the PvF board of directors has requested that a project team be created to explore has ortunity to develop an electronic commerce (E-Commerce) system. Specifically, research found a good opportunity for online fumiture especially areas te furniture furniture purchasing, and (3) furniture The board initially incorporate three target markets E-Commerce purchasing. to focus Judson, on corporate furniture buying system. Given the high plan, but wants vice president priority of this project, Jackie this project. of marketing, and senior systems analyst Jim Woo were assigned to work on To better understand what data would be needed within the WebStore, Woo the information from the JAD session and his previously developed data-flow diagram, and summarized the customer and inventory information identified, which are listed in the following table. Corporate Customer Home Office Customer Student Customer Invento Informatio Company name Name SKU Company address Company's name School Name Company phone Address Address Description Company fax Phone Phone Finished product size Company preferred Fax E-mail shipping method Finished product weight E-mail Available materials Buyer name Buyer phone Available colors Buyer e-mail Price Lead time
