Computer Programming Language Essay, Research Paper
Introduction
Background information of the company
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.
Problem
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 department receives the information to issue a check for the vendors.
The accounting department maintains the product information for the sales department because all sales orders must pass through the accounting department for a credit check. Accounting is also responsible for checking the sales orders for product pricing and sales amount.
The sales department requires pricing and quantity on the products from the purchasing department. The accounting department must gather information on the product from both the purchase and warehouse departments to verify the quantity and price. Then, when the sales order is approved it is given to data entry for processing the same information to the warehouse department for shipping and handling. Often times the information on the products is inconsistent. The inconsistent information on the products has cause a lot of friction between the purchasing, sales, and warehouse department. Which cause the company to lose a lot of its sales orders.
Objective of the project
The creation of a database that maintains product information, average cost of product on hand with new product, quantity, and date products received all in one database will provide the company with benefits such as; data consistency and reduction of administrative costs.
Goals of PDP Database Systems
+ The reduction of administrative and maintenance of product information costs by 15 %.
+ Eliminating the friction between departments on product information; such as pricing, quantity, and specifications, etc.
+ Eliminating the duplication of data and extra labor costs.
Significance
The maintenance cost for the new database system would need to be calculated so that it would actually provide the company with more benefits.
Proposed Database Scope
The proposed database will provide data access for 50 users, and only 10 of the users can modify or change the data on the products. The database would maintain data for approximately 368 types of products. Requirements for the new PDP Systems database are as follows:
1. Consistent product information such as product specifications.
2. Costs of products including shipping and insurance.
3. Cost averaging with existing inventory on hand and new product.
4. Track products (price, quantity, date) received from vendors and shipped to customers.
5. Consistency of products on order from purchasing and receiving at the warehouse.
Assumptions
+ The new database would require a new operating system that it is universal throughout the company.
+ Training would be required for all personals who would be using the database.
+ The sales price must be greater than the product cost.
+ The product quantity received and on hand must be equal or greater than the sales quantity.
+ Product shipment date and time must be later than the product received date and time.
Methodology
Business Rules
+ Each customer is assigned to one sales representative.
+ Each sale or purchase order must have a date and time.
+ All purchase order and sales order must be approve by the accounting department.
+ Once the sales order is approved by the accounting department, it would be sent to the warehouse for processing and shipping.
+ Each vendor can only have one purchase representative.
+ Only the accounting department can access account transactions.
+ Only sales representatives are allowed to make sales orders for their customers.
+ Sales representatives cannot modify account activity and account history.
+ Each product must have a product identification number with descriptions stored in the database.
+ All customer accounts must have a shipping address and a contact s name.
+ All product Information must be enter in the warehouse.
+ Each Sales Order can have many products.
+ All products are assigned
Наверняка у вас есть товары или услуги, продажа которых приносит вам максимальную прибыль. Для быстрого старта в сети вам необходимо создание посадочной страницы (одностраничного сайта), на которой будет размещена информация о маржинальных товарах/услугах интернет магазина. За 8 лет опыта разработки конверсионных страниц мы выработали оптимальную структуру, которая позволит привлекать через landing page больше продаж. На такую структуру «одевается» ваш контент — фирменный стиль, тексты, фотографии, уникальные торговые предложения, после чего страница выходит в свет. Разработка лендинга и запуск в сети — до 7 рабочих дней. Стоит отметить, что в разработку самой посадочной страницы входит и написание копирайтером продающих текстов для вашего бизнеса, чтобы каждый посетитель страницы захотел совершить покупку именно у вас. Результат: качественно разработаная продающая посадочная страница, которая готова приносить вам новых клиентов.