Database and Item Essay

Submitted By joetorrey38
Words: 699
Pages: 3
Open Document
Database Analysis Paper Torrey Collins CIS/207 1/24/12 Shawn Pullum

What is a database? A database is designed to offer an organized mechanism for storing, managing and retrieving information. Databases are a common usage in today’s businesses. They can serve the purpose for many reasons. Depending on what type of industry the company may be in. Databases can be used to store a company customer’s information, a business accounting, human resource, payroll, and many other departments a company may have. Databases are a more efficient and faster way to store and retrieve data electronically rather than using file cabinet to store information. With databases it will eliminate the paper trail. As an inventory coordinator at Dow Chemical, my job is consisting of bringing in and out product out of inventory. Whatever the computer shows in inventory it has to match it on the shelf. In order to maintain having the right number of parts on the shelf, doing a cycle every six months will allow less error and will save the company time and money. In the department that I work in we use Microsoft Access as our database for keeping up with the inventory we bring in and out. The way the database is for cycle counting and making sure the inventory is on target. The database in our department is broken down to the rows, buildings, shortages, the cost, how much is over, and the overall percentage for that particular row. Using Access as our database for cycle counting is a way to see how much we have in stock and how much we are losing or gaining in cost. Overall, this is a good way to keep up with the inventory. But changes can be made by implementing new ideas to improve the database at work. One change I would make is eliminating a person doing a physical count on every item that is on that row. By doing it this way, the chances of having human error is very possible. There is no way an individual will count every single item on a row. They will have items that will not be counted in the cycle count. They will have to come up with a new way to cycle count in order to cut down on the human error. My proposal is to implement a barcode scan system for cycle counting. The way it will be setup is when every time an item comes in a barcode will be place on the item and the shelf that the item goes on. The item then will be scan so the information will directly goes to the database. The scanner will be able to scan the item, cost, and quantity that came in. When it’s time to cycle count again, doing it the old way will be eliminated and less time to do. With having the new barcode system in place will be much faster by just scanning the shelf, this will allow the scanner to display on the scanner the item and quantity of that item without a person doing a physical count. This new system may cost heavily but within time it will pay for its self. This will eliminate human error tremendously by taking the responsibility of a person doing the physical cycle count and relying on an electronic device to do the work for them. This will also cut down the time it takes to a cycle count by more than fifty percent. That will definitely save the come time and money. The barcode system will not only be an asset but a lifetime investment for the company. The information will be more accurate in the database system without wondering if any item wasn’t counted. This should be the new way of doing inventory for the future. In conclusion, many companies everyday rely on information to make crucial decision on what direction a company should go. That is why having accurate information is so vital. By companies having a
Show More

Related Documents: Database and Item Essay

Relational Model and Assessment Criteria Essay

demonstrate the ability to: | |1 |Understand data models and |Provide evidence to support an understanding of different data models. Compare and | | |Database technology |contrast different data model structures and examine their contribution to database | | | |development | | | |Examine…

Words 1419 - Pages 6

Essay on IS520 U1 Assignment

Database Processing Unit 1 Assignments Chapter 1 Exercises 1.9 Single user database applications - Payroll accountants use software such as QuickBooks, Peachtree and Mas90 for compiling reports and tracking data. Multiuser database applications – PowerPM is a database server software package that runs off of a file server for multiuser access. This would benefit an educational service such as an online library, where numerous student logins are needed. http://findaccountingsoftware.com/dire…

Words 602 - Pages 3

Unit 03 assignment 02 Essay

Maintaining a Database Lab Analysis Capella University Professor Chrisman IT2230 Prior to this course my experience with Microsoft Access was limited to create address book and toying with it here and there for fun. What I would say that I have learned about creating and maintaining a database would be substantial, even though I am not quite good at the process yet, would be how records function within a database, designing a database using Datasheet view and Design view, how to create Queries,…

Words 320 - Pages 2

Week3VocabFillable 2 Essays

include in some database. Database A database is searchable. It can be both electronic and non-electronic, and database is organized by information. Many periodical databases are in full text; however, not all databases are in full text. There are only either citation or abstract. The databases is the index whether the information is available or not. A library catalog is a type of database that indicates the content of the library. Fields Specific database or catalog of a specific item or information…

Words 588 - Pages 3

Sql Research Paper

Introduction Although many varieties of sophisticated software are available for database construction, they impose very little restriction on their implemented form. Indeed, it would fly in the face of database philosophy to impose the form of implementation, for this would not encourage features like responsiveness to new requests (Bailey, Creel, Grossman, Gutti, and Sivakumar, 55-57). Thus each operational database is unique, even if the software used in constructing it is an industry standard…

Words 1316 - Pages 6

Advantages And Disadvantages Of Data Mining

Student Performance Analysis using Apriori Algorithm ware, such as search engines, customer-adaptive web services (e.g., using recommender algorithms), intelligent database systems, email managers, ticket masters, and so on, incorporates data mining into its functional components, often unbeknownst to the user. [11] Uses large item set property: Can…

Words 1498 - Pages 6

Essay on Week 2 Assignment 1 copy

during last week’s dinner, I have decided to help me sister. My sister owns a small clothing store not to far from her home. During that dinner we had last week, she mentioned to me that she was struggling to manually track and reorder high demand items. I suggested to her that could help build an automated system to assist her at her shop that was also very affordable. In this paper, I would to purpose all the necessary equipment needed. Also, explain the costs involved in the creation of the system…

Words 1050 - Pages 5

The principles and importance of normal Essay

Maintenance Database” for Huffman Trucking has been created. This paper will give a description and show the importance of normalization in relationship to this project and address the process by which the project was normalized. Normalization is considered a formal process that is used in determining which fields belong in which tables in a relational database. The function of normalization is to eliminate redundant data and to promote a greater overall organization of the database for functionality…

Words 323 - Pages 2

Physical Design and Implementation Essay

Assigment 6: Physical Design and Implementation Explain the security mechanisms available for a database and how the data will be protected. Database security is the most important component of any information system; it is the responsibility of team members and all staff managers, not just information technology professionals. Social engineering is the mother cause of having a compromised information system. Especially when employees are not properly informed about information and security processes…

Words 1576 - Pages 7

Undo And Redo Rules

will restore it in the stable database when it replaces x’s cache slot. H. [Step (3) of Restart] The before image of x wrt T, can be found in the log. I. [Step (4) of Restart] Upon recovery from a system failure, the scheduler must wait for the acknowledgment that Restart has been completed by the RM. It may then start sending operations to the RM again. Undo and Redo Rules This algorithm satisfies the Undo Rule. Suppose the location of x in the stable database contains the last committed…

Words 1334 - Pages 6