Premium Essay

Database Systems for Business

In:

Submitted By greenasil
Words 3888
Pages 16
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 markets and expanding the operation, Play On Toys is at a critical junction. Ensuring that internal systems are functioning at highest efficiency and are prepared for growth are essential elements for the continued success of Play On Toys.
Currently, records and information for critical areas including sales, financial, production, and customer relations are held in isolated electronic and paper files as well as some small databases. Essential reporting and transaction processing are highly dependent on manual inputs. Critically, sales orders submitted via the website must be manually processed by sales administrators in a process requiring printing orders and entering them into a spreadsheet manually.
The current system of record keeping and reporting lacks cohesion and efficiency, and coupled with the anticipated growth of Play On Toys, changes must be made to ensure that essential functions such as sales, inventory control and financial management are capable of scaling up as the business continues to grow.
This briefing outlines relevant information related to options for improving the information technology system and proposes a recomended course of action.

Similar Documents

Premium Essay

Database Systems for Business

... Page 19 Conclusion Page 20 Bibliography Page 21 Introduction In the following assignment I will present an introduction to databases which will demonstrate my knowledge through creating reports, defining key terms and there advantages and disadvantages, as well as designing an entity model. These will support my knowledge. TASK 1 Diagram 1: Marks & Spencer’s three-layer relational database architecture related to their online activities. Internal Schema (Server) Conceptual Schema (Programmer) External (Customer) External (Supplier) External (Business partners) External (Departments) As shown in diagram 1, a 3-layer Relational database separates the physical database from the user applications. The following schemas are defined at each of the following levels: * Internal * Conceptual * External “The DBMS is responsible for mapping between these...

Words: 2877 - Pages: 12

Premium Essay

Exam

...Management Information Systems MANAGING THE DIGITAL FIRM, 12TH EDITION GLOBAL EDITION Chapter 6 FOUNDATIONS OF BUSINESS INTELLIGENCE: DATABASES AND INFORMATION MANAGEMENT Management Information Systems CHAPTER 6: FOUNDATIONS OF BUSINESS INTELLIGENCE: DATABASES AND INFORMATION MANAGEMENT Learning Objectives • Describe how the problems of managing data resources in a traditional file environment are solved by a database management system • Describe the capabilities and value of a database management system • Apply important database design principles • Evaluate tools and technologies for accessing information from databases to improve business performance and decision making • Assess the role of information policy, data administration, and data quality assurance in the management of a firm’s data resources 2 © Pearson Education 2012 Management Information Systems CHAPTER 6: FOUNDATIONS OF BUSINESS INTELLIGENCE: DATABASES AND INFORMATION MANAGEMENT Organizing Data in a Traditional File Environment • File organization concepts – – – – Database: Group of related files File: Group of records of same type Record: Group of related fields Field: Group of characters as word(s) or number • Describes an entity (person, place, thing on which we store information) • Attribute: Each characteristic, or quality, describing entity – E.g., Attributes Date or Grade belong to entity COURSE 3 © Pearson Education 2012 Management Information Systems CHAPTER 6: FOUNDATIONS...

Words: 2709 - Pages: 11

Premium Essay

Dbm 502 Week One

...Material Database Environment, Development Process, and Staffing Tables Part I Database Environment Table Describe each component of the database environment, and provide a common vendor-supplied example or an example of how this component relates to the rest of the database environment. |Components |Description |Example | |Database Management |The Computer Software application that |MySQL, MS-SQL, Oracle IBM DB2.. Etc | |System (DBMS) |interacts with the user and other applications | | |Repository |A storage location for safety of preservation |Dimensions, Maven, | |Metadata |Data the describes other data. |Card Catalogs in the old days, Digital | | | |Photos have metadata describing the photo| | | |location, apature size, etc. | |Case Tools |Computer aided software engineering tools. A |Umbrello, Visio (Kinda) etc. | | |domain of tools to design and implement | | | |software | | |Database ...

Words: 1500 - Pages: 6

Premium Essay

Data Development Cycle

...The database development Process Vamsinadh Machavarapu IST 7000 Wilmington University Table Of Contents Introduction...........................................................................................3 SDLC Phases.........................................................................................3 • Requirements Analysis...................................................................4 • Database Design.............................................................................4 • Evaluation and Selection................................................................5 • Logical Database design................................................................5 • Physical Database design...............................................................6 • Implementation..............................................................................6 • Data Loading.................................................................................7 • Testing and Performance Tuning...................................................7 • Operation.......................................................................................7 • Maintenance...................................................................................8 Conclusion.............................................................................................8 References.......................................................................................

Words: 1225 - Pages: 5

Premium Essay

Web 407 Week 2

...Web 407 Week 3 Database Paper In the business world, most people will find a need for a database software program to store or house data pertaining to their business. There are however, multiple things to consider before one makes their final choice on what software they will be using. A few things that should be addressed are the type of software desired, either open-source or propriety, and what characteristics of the database meets the company’s needs. There are two basic types of database programs people can choose from when deciding what they want for their small business, an open-source database or a propriety one. While both of these are similar, they still have their advantages and disadvantages. First, consider what an open-source program is. The term open-source means exactly what it sounds like; the source code for the software is completely open and free to the public. Some advantages that come with this are the fact there is no upfront costs when it comes to obtaining the database program. While this sounds great, one needs to consider the tools the business has at its disposal. If you do not have the people to manage the databases and run them, then more employees must be hired in order to support the system. This can lead to more cost in the long run. So the fact that it’s free can also be a disadvantage. Another advantage to open-source database systems is a lot of them have a huge following such as MYSQL. MYSQL is database that is designed to use Standard...

Words: 917 - Pages: 4

Premium Essay

Accounting Information Systems: Course Objectives, Description, Topics, and Assignments

...ACCOUNTING INFORMATION SYSTEMS: COURSE OBJECTIVES, DESCRIPTION, TOPICS, AND ASSIGNMENTS ACCT-5600 DR. NICOLAOU Fall 2010 COURSE STRUCTURE In the modern world, the majority of accounting entries occur electronically. Accountants and auditors store information in databases, managed by enterprise systems that have a set of controls to ensure that transactions and record keeping happen as expected. E-business Web sites handle transactions automatically, with the accounting data going directly into the necessary databases. The concept of a paper trail has become a bit of a misnomer; today, because of accounting information systems, there is often no paper involved at all; however, it is important to establish the flow the data in different areas of the organization, or audit trail, so as to properly exercise internal controls. AISs help in this purpose. At the outset of this course, you will learn the basics of accounting information systems and business processes. Next, you will learn about database management systems, and the design of various database models. Finally, you will learn about how to use internal controls effectively for risk management, as well as the requirements for business reporting. After completing this course, you should not only have a clear idea of how accounting information systems work, but you should also be prepared to design and configure them to meet the record-keeping and risk management requirements of the organization. In addition...

Words: 6838 - Pages: 28

Free Essay

Oracle Database Trends

...Research projectDatabase TrendssUBMITTED BYAndrew HoPatrick TchissamboFlavio baptista | | | PROFESSOR TAHEREH DANESHI | Summary page Our project is about database trends. We started the project by identifying aims and goals such as understanding what database is.We calculated in detail and understood and researched on database understood database used by ORACLE. INTRODUCTION The definition of a database is a structured collection of records or data that is stored in a computer system. In order for a database to be truly functional, it must not only store large amounts of records well, but be accessed easily. In addition, new information and changes should also be fairly easy to input. In order to have a highly efficient database system, you need to incorporate a program that manages the queries and information stored on the system. This is usually referred to as DBMS or a Database Management System. Besides these features, all databases that are created should be built with high data integrity and the ability to recover data if hardware fails. (What is a Database?, 2010) AIM The aim of the study is many folded such as, understanding database, go in detail and understand and research on database, understand the technology used by ORACLE, derive conclusions on the development in the field of database. LIMITATIONS This study is descriptive in nature and the research is done on published secondary materials. Logical conclusions are made based on our experience and...

Words: 3078 - Pages: 13

Premium Essay

Reflection

...Guide This week, you will explore how databases are used in the work environment. Databases play a significant role in an organization, so it is important to know how to capitalize on database functionality. You will also learn how businesses, consumers, and the government use collaboration tools in the work environment, and how these tools have transformed the business processes of today’s organizations. Additionally, you will explore electronic commerce, and discuss the challenges this technology presents to businesses and their consumers. Databases, Network Applications, and E-Business OBJECTIVE: Describe how databases are used in the work environment. Resources: Ch. 4 and Technology Guide 2 of Introduction to Information Systems and Ch. 1 for Access in Microsoft® Office 2010 Content • Ch. 4: Data and Knowledge Management of Introduction to Information Systems o Managing Data • The Difficulties of Managing Data • The Data Life Cycle o The Database Approach • The Data Hierarchy • Designing the Database o Database Management Systems • The Relational Database Model • Databases in Action o Data Warehousing • Describing the Data Warehouse • Data Marts o Data Governance o Knowledge Management • Concepts and Definitions • Knowledge Management Systems • The Knowledge Management System Cycle • Technology Guide 2: Computer...

Words: 610 - Pages: 3

Premium Essay

Ch. 11-16 Study Guide

...brick-and-mortar store | A conventional store with a physical presence. | brokerage site | A type of Web site that brings buyers and sellers together to facilitate transactions between them; the site earns revenue in the form of commissions on sales made via the site. | business-to-business (B2B) model | An e-commerce model in which a business provides goods or services to other businesses. | business-to-consumer (B2C) model | An e-commerce model in which a business provides goods or services to consumers. | business-to-government (B2G) model | An e-commerce model in which a business provides goods and services to government organizations. | consumer-to-consumer (C2C) model | An e-commerce model in which a consumer provides goods or services to other consumers. | digital wallet | A program or online service that holds a buyer’s information (such as electronic payment, billing, and shipping information) that can be used to speed up online purchase transactions. | dot-com | An Internet-only store with no physical presence. | e-commerce | The act of doing business transactions over the Internet or similar technology. | e-commerce business model | A description of how an e-commerce company does business, such as the types of buyers and sellers involved. | e-tailer | An online retailer. | m-commerce | E-commerce carried out via mobile phones and other mobile devices. | meta tag | A special HTML or XHTML tag containing information about a Web page that is added by...

Words: 3951 - Pages: 16

Premium Essay

"Enterprise Level Data Work Flows and Data Warehouse

...whom this project would have been a distant reality. We also extend our heartfelt thanks to our family and well wishers. I would like to take this occasion to specially thank University of Northern Virginia to provide us with excellent faculty and also in supporting us getting quality education remotely. Contents SL No Title Page no 1 Abstract 5 2 Introduction to Databases 6 3 OLTP and OLAP Systems 7 4 Difference between OLTP and OLAP 9 5 Data Modeling 13 6 Workflows in Enterprise level Data warehousing 18 7 Business Intelligence tools used in Data flow and Data Warehousing 21 8 Analysis in Data warehousing 24 9 Conclusion 28 10 Foot Note 30 11 References 31 ABSTRACT These days majority of the applications, may it be web applications or windows applications or mobile applications, are completely database dependent. Most of the application developments are becoming database driven environments, hence rendering databases as one of the most key elements in a software environment. This dependency on databases can attributed to the increasing number of data requirements from the...

Words: 6349 - Pages: 26

Premium Essay

It205 Smart Scenario - Clarifying Business Strategy Through Database Analysis

...Event Coordinator What are the current problems that the Event Coordinator is having? (multiple choice, multi-select) ☑ System is disconnected from other departments. ☑ Too much manual intervention in the business process. ☑ Required information is not always available. ☑ Information retention is inefficient or non-existent. ☑ Poor use of available information technology resources. ☑ Insufficient use of database technology or tools. ☐ Poor communication. How could a proper database system and subsequent tools serve to improve the issues this department is having? (short answer) Have no database to keep track of clients. Only way of customer feedback is through cards and they do not reply. Database could do all that for them. They schedule staff by previous seasons. Database could give accurate occupancy. Database could advertise and rent rooms. Front Desk What are the current problems that the Front Desk is having? (multiple choice, multi-select) ☑ System is disconnected from other departments. ☑ Too much manual intervention in the business process. ☑ Required information is not always available. ☑ Information retention is inefficient or non-existent. ☑ Poor use of available information technology resources. ☑ Insufficient use of database technology or tools. ☐ Poor communication. How could a proper database system and subsequent tools serve to improve the issues this department is having? (short answer) Recepts should be logged into computer...

Words: 619 - Pages: 3

Premium Essay

Clarifying Business Strategy Through Database Analysis

...|Title |IT205 Smart Scenario - Clarifying Business Strategy Through Database Analysis | |Event Coordinator | |What are the current problems that the Event Coordinator is having? (multiple choice, multi-select) | | | |☐  System is disconnected from other departments. | |☑  Too much manual intervention in the business process. | |☐  Required information is not always available. | |☐  Information retention is inefficient or non-existent. | |☐  Poor use of available information technology resources. | |☑  Insufficient use of database technology or tools. | |☐  Poor communication. ...

Words: 861 - Pages: 4

Premium Essay

Case Study Lego

...LEGO - EMBRACING CHANGE BY COMBINING BUSINESS INTELLIGENCE WITH A FLEXIBLE INFORMATION SYSTEM History of LEGO Company The LEGO Group was founded in 1932 by Ole Kirk Kristiansen. The company has passed from father to son and is now owned by Kjeld Kirk Kristiansen, a grandchild of the founder.   It has come a long way over the past almost 80 years - from a small carpenter’s workshop to a modern, to a global enterprise that is now, in terms of sales, the world’s fourth-largest manufacturer of toys. The name 'LEGO' is an abbreviation of the two Danish words "leg godt", meaning "play well". The original Lego toys started with a wooden duck. But the first LEGO automatic binding brick is their most important product. The products have undergone extensive development over the years – but the foundation remains the traditional LEGO brick. The Lego Group began in the carpentry workshop of Ole Kirk Christiansen, in Billund, Denmark in 1916.  In 1961, Lego wished to expand sales to North America, but did not have the logistical capabilities to do so. Lego made an arrangement allowing Samsonite to begin producing and selling Lego products in the United States and Canada.  On 7 June 1968, the first Legoland Park was opened in Billund. This theme park featured elaborate models of miniature towns built entirely from Lego bricks. The three acre (12,000 m²) park attracted 625,000 visitors in its first year alone. During the next 20 years, the park grew to more than eight times...

Words: 1468 - Pages: 6

Premium Essay

The Design and Development of Business Warehousw Systems

...and Development of Business Warehouse Systems CIS 537 July 31, 2011 What type of new BW System you would want? The system that I want is the SAP NetWeaver Business Warehouse systems on the IBM InfoSphere Warehouse that is on IBM. With a business intelligence database with common properties in a class that can be a wide variation. The SAP NetWeaver Business Warehouse databases tend to have some features that are typical, of a standard BI database. It will fit into the InfoSphere Balanced Warehouse design and there are many benefits to running SAP NetWeaver BW on InfoSphere Balance Warehouse. Timely access to relevant information has always been critical to business success, with new data sources and increased access, managing, processing and making sense of data volumes is important. With the SAP NetWeaver Business Warehouse will lead the way to providing a complete business from data sources. A comprehensive set of tools, planning and simulation capabilities as the components of the SAP NetWeaver platform to combines powerful business warehouse infrastructure and data warehousing functionality. It will give a timely access to relevant information that has been critical to business success. The decision will be based on the full range of information available as the volume of available information grows. The InfoSphere Balanced Warehouse is a complete data warehousing solution that is comprised on pretested, scalable and fully integrated system. The system is configured by...

Words: 626 - Pages: 3

Premium Essay

Finance

...What is the most popular type of database? relational  Using a file-oriented approach to data and information, data is maintained in many separate files.  3. File-oriented approaches create problems for organizations because of multiple master files which may contain redundant data.  4. Which statement is true regarding file systems? The proliferation of master files creates problems in the consistency of specific data stored in different files.  5. A set of interrelated, centrally coordinated files is called a database.  6. The software program that creates, manipulates, and accesses the database goes by the acronym DBMS.  7. The ___________ acts as an interface between the database and the various application programs c) Database management system  8. The combination of the database, the DBMS, and the application programs that access the database through the DBMS is referred to as the c) Database system  9. The person responsible for the database is the b) Database administrator  10. All of the following are benefits of database technology except: b) Decentralized management of data  11. Separating the logical and physical views in a database allows the programmers to concentrate on coding the application logic b) since they do not have to focus on the physical location and layouts of various data items.  12. A database system separates the logical and physical view of data. Such separation facilitates the development...

Words: 3223 - Pages: 13