Database Systems For Business Essay

3910 words - 16 pages

How can Play On Toys ensure its information technology systems are ready for growth?

Issue:
Play On Toys has enjoyed 5 years of success in the European market, experiencing strong growth, particularly in the past year, increasing its staff from 16 to 60 employees. With 200 customers, Play On Toys fulfils 3000 orders annually, with a turnover of 5million Euro and 1.4 million in pre-tax profit. Having expanded its range from 2 to 20 products, Play On Toys now works with 30 suppliers to acquire the 110 parts required to manufacture its wares.
Expansion into Asia, Africa and America is planned over the coming three years, with the accompanying growth and challenges of moving into new ...view middle of the document...

An overall recommendation is made at the end of the document.

Database Management System (DBMS)
Overview
A Database Management System (DBMS) is a computer program that allows users to interact with a database to store, modify and extract data as needed while securing the data from loss or corruption. Database systems can be developed for any functional area of the business, with typical implementations in accounting and finance, marketing and sales, operations and logistics, and human resource management. (Rainer & Watson, 2012) DBMS are implementable in organisations of any size and can operate on a single PC or on a mainframe serving many computers. (Hardcastle, 2011)
Benefits
In comparison to file based data storage, DBMS offer significant advantages including increased quality and accessibility of data, speed of processing and data security.
Ease of Access – Employees can easily access the information they need since the data is stored centrally on a shared system. Additionally multiple users are able to access the same data at once, allowing for simultaneous use of the information. (Oppel, 2009) (Pratt & Adamski, 2012)
Access Control – Access to the data in a DBMS is controlled by carefully designed security features. Typically, users must enter valid user-name and password credentials in order to access the system. Likewise, individual users or departments are granted access only to the data they need in order to do their work. Users can also be granted read-only or editing access depending on the needs of the company. (Elmasri & Navathe, 2004) (Connolly & Begg, 2005)
Custom Interfaces – DBMS offer customisation of views for users so that the most frequently accessed information is easy to get to quickly. (Oppel, 2009)(Elmasri & Navathe, 2004)
Efficiency – Database systems offer powerful search functions which can be used to locate and retrieve information much faster than by manual searching. Additionally, DBMS can be programmed to carry out a wide range of tasks such as report generation, saving more time. (Hardcastle, 2011) (Elmasri & Navathe, 2004)
Security – Because all data is stored centrally, DBMS are designed with high levels of security in place to avoid errors, data loss, attacks. (Elmasri & Navathe, 2004)
Data Integrity – Database systems ensure that data is captured in the correct format, and that required fields are filled when the record is created. For example, entries such as dates and account numbers that must follow a fixed character pattern will not be allowed if they do not fit the required pattern. This feature reduces the incidence of incorrect or missing information. (Elmasri & Navathe, 2004) (Pratt & Adamski, 2012)
Data Consistency – In file-based systems, the same information may be stored in multiple locations, which makes updating details difficult and often leads to inconsistency within the information stored. Database systems store each piece of information only once, making updates...

Other Essays Like Database Systems for Business

Mr Kavule Essay

855 words - 4 pages user mode will be reserved for special needs. Analyze the database environment. Database environment will consist of five major parts namely, hardware, software, people, procedures and data. The hardware components in the database system environment will identify all the systems, physical devices such as computers, network components and computer peripherals. The software refers to the collection of programs used within the

Database Security Essay

710 words - 3 pages . Week 2 User Account Security A database schema is built and used to group objects logically in a table and sorted into views and process procedures. A schema is somewhat of a box that contains the objects used in the database. Providing security for a database schema can be a task. To create a database schema the user will use SQL server to build the database box. It is wise to have a database schema for a business in order to store

Distributed Database

961 words - 4 pages . Next that algebraic query is decomposed into fragmented query. This step is called as Data localization. Then fragmented query is further optimized to communicate with operations. This step is called as Global optimization. Lastly the optimized query is optimized locally to fetch the data in local systems. This step is called as Local optimization. For accessing distributed database from internet we can use mobile agent based system completely

Database Management System

1543 words - 7 pages Language: All database management systems provide a query language, which enables users to define their requirements for extracting the desired information. For example, from an inventory database a user can list out the item description whose current inventory is less than 20 units.IV.Report Generator: A report is the presentation of information extracted from a database. A report generator enables the users of a database to design the layout of a

Integration of Mis Books

525 words - 3 pages Why do we need these references? Basically, BA 125 is all about Management Information Systems (MIS), thus we need these references: Management Information Systems for the Information Age (Haag and Cummings, 2010), Database Management Essential Concepts and Techniques in Microsoft Access 2007 (Shelly, Cashman and Vermaat, 2010), and Systems Analysis and Design (Shelly, Cashman, Rosenblatt). All of these books revolve around the concept of MIS

Database Design

653 words - 3 pages Database Design Bobby Watson DBM/380 March 27, 2014 Jean Baptiste Database Design Databases are the foundation to collecting and storing information that is pertinent to an integrated computer system. The importance of databases cannot be understated and must be the prime focus of the information technology organizations in all forms of business. It is probably best described in our text: “A database is a shared, integrated computer

Database Normalization and Logical Process Concept Paper

1457 words - 6 pages Database Normalization and Logical Process Concept paper This short paper will explain with a simple example the process and the need of normalization in the most of the business databases. Complete proposal break down (Timeline phases, Financial phases) will be submitted per management request. Overview At first any database should be designed with the end user in mind. Logical database design, also referred to as the logical model, is the

Data Development Cycle

1240 words - 5 pages the database process is Requirements Analysis.In this stage we need to find out the requirements of the business, What kind of data system is required for our business., How much volume of data should be handled on day to day basis.To know this information we need to spend a lot of time with the people in the organization. Data Analyst must spend more time in studying the existing system to know the volume of data should be handled in day to day

Database Environment

2977 words - 12 pages program establishes a connection to the DBMS on the server side. Once the connection is created, the client can communicate with the DBMS. ▪ ODBC (Open Database Connectivity) is a standard that provides and application processing interface which allows client side programs to call the DBMS as long as both sides have the required software. Most database vendors provide ODBC drivers for their systems. ▪ Client programs can connect to

Memorandum Paper Database

849 words - 4 pages database in the business environment has become an integral part in business processing. According to an article, Database Evolution: Microsoft Access within an Organization's Database Strategy, Chung explains that databases are used in a variety of levels for various reasons: Enterprise level, Department level, Workgroup/Team Level and Individual/small groups. With these, database systems are used as data centers in order for companies to process data

Database Analysis

721 words - 3 pages Databases are powerful tools that can provide businesses with an edge over the competition. Databases can help keep track of, inventory, billing, payroll, phone numbers, and much more. Databases are essential for almost every company in today's business world. The company that I used to work for custom built their database in-house to suit their business needs. The company uses Oracle, SQL, and Microsoft Access. The company asked me to develop a

Related Papers

Selecting A Database For A Small Business

1115 words - 5 pages the Order Line Items table. The Product ID in the Products table also had that relationship with the Order Line Items table; it too was created before the Order Line Items table. The Order Line Items table was created last. The thought process behind creating this database was providing an organized list of each customer that Jay-Star does business with. Now for this assignment, not all of Jay-Star’s customers were added to the database. That

Business Case For Hr Self Service Systems

1123 words - 5 pages Business Case for HR Self Service Systems Table of Contents Executive Summary 3 Project Overview 3 Business Case for Proposed Project 4 Conclusion 5 References 5 Executive Summary This paper addresses the business case for implementing self service in the IT industry with the aim of gaining higher efficiency for a majority of HR functions and other benefits that can be derived from improved information access. The

Database Systems And How They Are Used

517 words - 3 pages . It is also discipline specific considering it is only designed to do those particular functions. This is an Online Transaction Processing (OLTP) database system. It is used to create day-to-day business for the Verizon Company. Conclusion All companies make use of database systems. Prior to databases, companies had to utilize multiple file cabinets and keep paper copies of every transaction. Now, databases serve as the file cabinets and

Review Questions: Chapter 1

2512 words - 11 pages . • Canned Transaction – naïve or parametric end users main job function revolves around constantly querying and updating the database, using standard types of queries and updates called canned transactions that have been carefully programmed and tested. • Deductive Database System – some database systems provide capabilities for defining deduction rules for inferencing new information from the stored database facts. • Persistent Object