PDP systems is a computer memory manufacturer and peripheral distributor with a corporate office located in Fremont California. The company consists of 9 departments and 160 employees with 80 networked computer users in the corporate office. The data system for the company currently consists of some database and some file based systems used by departments and individuals.

The company is not only a memory manufacturer but also a peripherals distributor. Thus, product information such as price, quantity and date product received is essential for the business to operate. The product information is shared among eight of the nine departments. Presently the product information is maintained in three separate files; purchasing, accounting, and warehouse. Maintenance of three separate files of the same information is not only expensive, but also redundant and it slows business decisions down.

Purchasing is responsible for purchasing peripherals from vendors. The purchaser keeps his/her own records of the products on order. At the same time the warehouse department is responsible for entering the product data when the products are received. Then the accounting d

· Once the sales order is approved by the accounting department, it would be sent to the warehouse for processing and shipping.

· Each sale or purchase order must have a date and time.

· Eliminating the duplication of data and extra labor costs.

- The products are then prepared in the shipment to be delivered to the customer.

1. Every employees (Sales Representatives) assists at least one customers, every customers can only have one employee assisting them.

Some common words found in the essay are:
Fremont California, Business Rules, PDP Systems, SQL Server, Current Enhancements, Sales Representatives, Database Systems, Access Office, Database Scope, Finally Access, product information, accounting department, · sales, · product, desktop database, quantity date, sales representatives, warehouse department, oracle sql server, access desktop, pricing quantity, provide company benefits, maintains product information, · sales representatives, price quantity date,
Approximate Word count = 1215
Approximate Pages = 5 (250 words per page double spaced)