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 to one purchase order.
+ All orders are assigned to one EmployeeID and one CustomerID with at least one ProductID.
ER Diagram
1. Every employees (Sales Representatives) assists at least one customers, every customers can only have one employee assisting them.
2. The customer requests merchandise through the employee who enters order in the database.
3. The order checks the inventory for the quantity on hand.
a. If there is enough inventory, the products are sent to the customer through the shipment.
b. If there is not enough inventory, a backorder will be generated, creating a purchase from the supplier.
- The supplier receives the purchase and provides the products to be sold.
- The products are then prepared in the shipment to be delivered to the customer.
See Appendix for ER Diagram and Normalization Tables
Recommendations and Current Enhancements
To implement this project, we recommend using Microsoft software and platform due to the wide range of users. Instead of installing a new platform, we believe that using the existing platform along with upgrading the server and choosing new database software-Access 2000 is better.
As a database system Access has many good points and many bad points. Fortunately, most of the cons related to the ‘class’ of application that Access is. It is important to clarify the ‘class’ that Access falls into. Access is a desktop database package. It is not designed to compete with systems such as Oracle or SQL Server – full database servers – whose engines are superior in terms of speed and multi-user capabilities. This is usually the first perceived bad point: it does not provide good performance when run across a network and when more than a handful of people use it at once. However, if one considers what Access is designed as – a desktop database with limited multi-user capabilities – its performance capabilities are good. In addition, Access can and does make good front-end package larger engines such as Oracle and SQL Server. Against other desktop database package, Access has one huge advantage. It is likely that you are running Windows as your operating system and using Microsoft Office as your application base. Access integrates well with these packages and data transfer between Access and the other Office components is relatively easy. In addition, against the other desktop databases Access is both rich in features and powerful. Access 2000 probably puts Access above any other desktop database you can buy. Access has a user-base of millions and therefore there are a lot of add-ons and other third party software available. Finally, Access can be used by almost anyone of any level. Beginners can get to grips with it very easily using the wizards and the easy-to-understand interface whilst developers can push it to its limits and do some extraordinary things with it. It is a system for everyone created with a mixed user-level in mind.
Другие работы по теме:
My First Computer Essay Research Paper My
My First Computer Essay, Research Paper My First Computer Wow, what an experience it was to see for the first time a machine that could think! This machine could do math, display graphics at the drop of a dime, and play two dimensional games (whic was all that was around back then). This wasn’t something that you normally saw.
What Kind Of Problems Bring For The
New Millenium Essay, Research Paper Nobody actually knows what is going to happen when the clock strikes midnight for the year 2000. All around the world, people are concerned with what is being referred to as the Y2K computer bug. Some people are worried that the world as we know it is going to end. Others believe that everything is going to be just fine.
Computer Education Essay Research Paper Back to
Computer Education Essay, Research Paper Back to the 1940s, the modern electronic computer was developed at U.S. universities; however, in the year, there was no computer education yet. It needed more 10 years to have computer education. The period of the computer revolution was 1950 in the U.S.. Computer education began in the middle of the 1950s with an organized body of knowledge.
Motivation Speech Essay Research Paper IV BROADCAST
Motivation Speech Essay, Research Paper IV. BROADCAST PROGRAMMING: BASIC LAW AND POLICY The First Amendment and federal law generally prohibit the FCC from censoring material in broadcasting. Stations choose the material they determine as best for their community. The FCC does not advise on artistic standards, formats, grammar or the quality of their programming.
Binary Systems Essay Research Paper Binary systems
Binary Systems Essay, Research Paper Binary systems are a major factor of everyday live. As years pass the use of a binary system has changed dramatically. Throughout this essay I will explain what binary systems are, how they were used in the past, and how they are being used today. A binary system is defined as a numbering system with a base (radix) of 2, unlike the number system which has bases of 10.
Computer Essay Research Paper Computer is useful
Computer Essay, Research Paper Computer is useful for finding the information. As long as the Internet is installed in the computer, the people can be able to what they want to find. Of course, they have to waste the time for doing. Acquiring the information, they feel that it is valuable. Renctly years, the number of people is increased by using computer.
Object Oriented Programming Essay Research Paper THE
Object Oriented Programming Essay, Research Paper THE ADVANTAGES OF OBJECT-ORIENTED PROGRAMMING USING C++ Object-oriented programming is a new way of approaching the job of programming. Programming over the years has evolved to accommodate the increased complexity of programs. (1) Structured, easy to understand programming has been around since the late 60’s.
Assembly Language Essay Research Paper When programming
Assembly Language Essay, Research Paper When programming in assembly language, we have to specify operations in a much greater level of detail than we would have to do in a high level language. Furthermore, we get relatively little help from the assembler in finding errors. Assemblers can only check the syntax of each line, and check that every symbol or label used is defined somewhere.
Programming Is Just Problem Solving Essay Research
Paper A computer cannot think, so this means that in order to get it to do any useful work, a user must provide it with a program. A program is a list of instructions that describe how to solve a particular problem, written in a language that a computer can understand, although programming a computer is a lot more involved than simply writing a list of instructions.
Data Encryption How Secure Are We Essay
, Research Paper Brad Plank 10/4/01 Senior Research Synopsis Encryption and Cryptography Have you ever wanted to send a message to someone while distorting it in some fashion so the only person who can UN-distort it is the person you send it to? This way, if a third party intercept this message, all they see is a bunch of gibberish.
Untitled Essay Research Paper A hacker is
Untitled Essay, Research Paper A hacker is a person obsessed with computers. At the heart of the obsession is a drive master the computer. The classic hacker was simply a
Another Computer Essay Essay Research Paper The
Another Computer Essay Essay, Research Paper The Computer Underground. The beginning of the electronic communication revolution that started with the public use of telephones to the emergence
The Computer Essay Research Paper When you
The Computer Essay, Research Paper When you think about your future keep one thing in mind, knowledge is the key. You should always try and keep up with the advances made, and recently our nation is steadily changing. Each day we become more and more dependent on technology to run our lives. If possible you should try and keep up, whether it be by reading books, taking classes, or getting help from a friend.
Hackers Essay Research Paper In the article
Hackers Essay, Research Paper In the article that I read was about Hackers. It talked about the aspects of how the youths of today commit this crime. Hacking overall requires the utmost intelligent. These people that become Hackers have special knowledge and skills in computer programming, Internet use, overwhelmingly bright in mathematics and other important factors.
Computer Scientist Essay Research Paper The title
Computer Scientist Essay, Research Paper The title computer scientist can be applied to a wide range of computer professionals who usually design computers and the software that runs them, develop information technologies, and develop and adapt principles for applying computers to new uses. Computer scientists perform many of the same duties as other computer professionals, but their jobs are distinguished by the higher level of theoretical expertise and innovation they apply to complex problems and the creation or application of new technology.
Letter Of Recommendation Essay Research Paper Letter
Letter Of Recommendation Essay, Research Paper Letter of Recommendation for Raj Rishi Chatterjee I should like to write a few words in support of Mr. Raj Rishi Chatterjee’s application for graduate admission in your department. He is interested in pursuing his graduate work in the broad area of Computer Science.
Essay On Hacking Essay Research Paper Essay
Essay On Hacking Essay, Research Paper Essay On Hacking by Philip Smith A topic that i know very well is computers and computer hacking. Computers seem very complicated and very hard to learn, but, if given time a
Programming A Vcr Essay Research Paper PROGRAMMING
Programming A Vcr Essay, Research Paper PROGRAMMING A VCR Thomas Hunter 1103B 04/24/00 Programming a VCR Programming the timer on a VCR (Video Cassette Recorder) can be very easy. First you need to be able to read the remote control. Next you need to know what time and what channel the program is going to be on.
3D Animator Essay Research Paper The field
3D Animator Essay, Research Paper The field of computer animation can be one of the most interesting fields in art today. It is for sure the most rapidly changing fields in art. Many people starting back in the 1980’s began to make their Amiga computers draw flat 2d animations. It took a lot of time and a lot of programming skills.
Politics Essay Research Paper Is computer programming
Politics Essay, Research Paper Is computer programming a career I would like to persue? Chapter 1 What is computer programming? A program is basically a set of directions to a given destination. Say your friend asks you, “where do u Live”. You reply, “Down the street until the first right, go right there and it is the second house on the left.” You have just given a program and you are the programmer for giving those directions.
Bill Gates Essay Research Paper Bill GatesThe
Bill Gates Essay, Research Paper Bill Gates The Chairman and Chief Software Architect of Microsoft William Gates III was born in October 28, 1955. He lived in Seattle with his father who is a Seattle attorney, his mother who was a chairwoman of United Way International, and his two sisters.
Another BIll Gates Essay Research Paper William
Another BIll Gates Essay, Research Paper William or Bill Gates was born on October 28, 1955. Bill had two sisters and they grew up in Seattle. Their father William H. Gates II is a Seattle
The Computer Mouse Essay Research Paper The
The Computer Mouse Essay, Research Paper The Computer Mouse The computer mouse is a common pointing device, popularized by its inclusion as standard equipment with the Apple Macintosh. With the rise in
Is Cobol Dead Essay Research Paper Is
Is Cobol Dead Essay, Research Paper Is COBOL dead? To be completely honest, I originally had no idea. I knew that I took it as programming class last semester, but I didn’t know how it applied to the business world. Nor, had it ever crossed my mind in the 3+ months that I used it. The fact that you asked the question made me wonder myself, so I had to do some reading.
JavaScript Essay Research Paper Within this report
JavaScript Essay, Research Paper Within this report is information on how JavaScript is used on the Internet. This report will contain information that will help you learn about JavaScript and its uses on the Internet. It mentions what JavaScript is, where it originated and what some of its uses are.JavaScript is a loosely typed scripting language that resembles the programming language C.
Computer Programmers Essay Research Paper Computer programmers
Computer Programmers Essay, Research Paper Computer programmers are the writers of computer programs. They do this by coding sets of instructions into machine-readable form. Programmers analyze data processing problems and plan, organize, and develop logical sequences of operations to be used by computers in processing information to solve business, scientific, engineering, and other complex or time-consuming problems.
Computer Violence Essay Research Paper Violent Computer
Computer Violence Essay, Research Paper Violent Computer Games A lot of adults say violent computer games make you violent. I disagree. When you are mad you can take out your anger while playing that game. Lots of kids I know have violent computer games and none of them are violent. Pretty much everything in this world has violence in it.
What Is English Essay Research Paper English
What Is English? Essay, Research Paper English, well what is English? We all know that it is a language. But, what is the study of english? It is the study of literature in the english language. People attend english classes. This may be to learn the English Language or to learn about english literature or writing.