Preview

Introducing Database System

Best Essays
Open Document
Open Document
4276 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Introducing Database System
CHAPTER 1: Introducing Database System

LEARNING OUTCOMES
TOPIC

At the end of this chapter, students should be able to:

DATABASE CONCEPT

BSIT 201
 Explain what is data management  Differentiate manual file system and computerised file system with database system

INTRODUCING DATABASE SYSTEM

CHAPTER 1

 Define database system, database and database management system  List the functions, advantages and disadvantages of database management system

PREPARED BY:

YEW CHERN HAR SCHOOL OF INFORMATION TECHNOLOGY
FACULTY OF ENGINEERING AND INFORMATION TECHNOLOGY
Slide 2 of 80

CHAPTER 1: Introducing Database System

CHAPTER 1: Introducing Database System

TOPIC OUTLINES
TOPIC

INTRODUCTION
TOPIC

Introduction 1.1 Manual File System 1.1.1 Disadvantages of Manual File System 1.2 Computerised File System 1.2.1 Disadvantages of Computerised File System 1.3 Database System 1.4 Database 1.4.1 Characteristics of Database 1.5 Database Management System 1.5.1 Functions of Database Management System 1.5.2 Advantages of Database Management System 1.5.3 Disadvantages of Database Management System
Figure 01

Are you being overwhelmed by too much data?
Slide 3 of 80 Slide 4 of 80

CHAPTER 1: Introducing Database System

CHAPTER 1: Introducing Database System

INTRODUCTION
TOPIC

INTRODUCTION
TOPIC

What you need is Data Management

Figure 02

Not sure how to make sense of the data?
Slide 5 of 80

Figure 03

Slide 6 of 80

1

CHAPTER 1: Introducing Database System

CHAPTER 1: Introducing Database System

INTRODUCTION
TOPIC

INTRODUCTION
TOPIC

Data management is a discipline that focuses on the proper way for

We will examine 3 ways for managing data
Manual File System

Computerised File System
Figure 04 Figure 05 Figure 06

Evolution of Data Management

Generating Data

Storing Data

Retrieving Data

Database System
Focus of this course
Slide 7 of 80 Slide 8 of 80

CHAPTER 1: Introducing

You May Also Find These Documents Helpful

  • Good Essays

    Husky Air Case

    • 660 Words
    • 3 Pages

    this, improving the Strategic area will improve the financial area as well. With improved growth, a company would naturally see an increase in revenue. Plus with the reduced cost of maintaining a lower profile file management system, profit margin will also see an increase. Customer relations will likely improve with a more streamlined file system as entering and retrieving data will allow for quicker turnaround times and improved accuracy. Finally, we can examine the improvement for Social concerns. However, the focal point of this project is to improve the Operational concerns of the company as that is…

    • 660 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Nt1330 Unit 1 Study Guide

    • 1178 Words
    • 5 Pages

    A database management system organizes both physical and logical approach to the data on the other hand file-processing system integrates only the physical access.…

    • 1178 Words
    • 5 Pages
    Powerful Essays
  • Powerful Essays

    Unit 18 - Database P1, M1

    • 995 Words
    • 4 Pages

    Database, it is a place use to store lots of data. It can be seen as a filing cabinet. And database management system (DBMS) is software that specificity designs for managing the data in database such as create, update or delete them. General is including security, retrieval and backup features. User also allows using the data to create a report or share data with multi-user.…

    • 995 Words
    • 4 Pages
    Powerful Essays
  • Satisfactory Essays

    Application Excersice 4

    • 429 Words
    • 2 Pages

    1. Identify whether each characteristic listed below generally belongs to a file-based system or to a database system.…

    • 429 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Database tools and technologies affected the business processes and decision making by a great extent. The most important benefit of the database is to change unstructured information into structured information, and allow users to analysis the data stored into different tables with the help of queries. Before database, all the information used to stored into paper and other unstructured computer programs, due to which getting required information process was very slow. Due to database, all the data is stored into the server and not only access of these became faster but also multiple users can access database at the same time. It removes redundancy from the tables, and ensure that the data all over the database is consistent, and also ensure the integrity of the data.…

    • 899 Words
    • 3 Pages
    Good Essays
  • Good Essays

    One of the most important elements of a computer based information system is the database. A database is a collection of records or information that is stored in a computer in a structured manner so that information can be stored, managed, and retrieved. Databases are very useful for manipulating large amounts of data and producing reports and documents. This paper takes a look at the Oracle database system and its usage within my organization.…

    • 592 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Relational Databases

    • 750 Words
    • 3 Pages

    A database uses a database management system or DBMS that use one of five specific data structure that allows the end user access to the data in the database. The five data structures are hierarchical, network, relational, object-oriented, and multidimensional. The first databases used the hierarchical data structure to store and gather the data. This structure the data relations are stored in a tree like records are dependent and arranged in multilevel with one root record and various subordinate levels. Any data element in the database can be found by starting at the root record and…

    • 750 Words
    • 3 Pages
    Good Essays
  • Better Essays

    A database management system is a system in which data is stored, processed, and retrieved. These systems are known for security accuracy and consistency. A well-planned and developed database is very efficient and meets the current and future needs of the organization to which it services. This type of system allows the organization to collectively store and manipulate data.…

    • 864 Words
    • 4 Pages
    Better Essays
  • Better Essays

    Accounting, bookkeeping information, personal financial records, stocks and personal property inventories are only some examples of how databases are managed and can be created for a multitude of things and all of these different types of files and data can be managed through a Database Management System (DBMS). The better the DBMS system is the better that system will support the organization. When you have a DBMS that supports the organization, that organization will be able to increase productivity, profits and overall status of business.…

    • 1084 Words
    • 5 Pages
    Better Essays
  • Good Essays

    This paper will discuss the different databases in my organization with regards to what the databases are being used for and any improvements that can be made. To understand how a database helps the day-to-day functions of a business one must first know what a database does and how it works. A database is a “systematized collection of data that can be accessed immediately and manipulated by a data-processing system for a specific purpose” (English Dictionary). So a database is an application or tool used for storing and arranging information efficiently. Databases are very important tools in the workplace, if a company’s data is stored on a typically spreadsheet problems would arise fairly quickly. A spreadsheet is very hard to retrieve data except basic queries, and there is no multiple user access, and perhaps the most troublesome issue is that there is no integrity and data validation. In databases the structure is based on tables which have columns and rows that will store specific data. A row “in a table is referred to as a record. Records are where the individual pieces of information are stored” (Microsoft). Columns will identify the data in the table with the rows showing the records. The main types of databases are; relational and flat-file databases. “A flat file database is a database designed around a single table. The flat file design puts all database information in one table, or list, with fields to represent all parameters. A flat file may contain many fields, often, with duplicate data that are prone to data corruption” (databasedev). Flat file databases are good for small amounts of data that store simple data such as list and data values. Relational databases deals with more than one database at a time. It forms a relationship between tables that are manipulated to suite the user needs. The two main databases that I use at my job would be Microsoft Access and Microsoft SQL Server.…

    • 752 Words
    • 4 Pages
    Good Essays
  • Better Essays

    Data Management Strategy

    • 2264 Words
    • 10 Pages

    Regardless of the size of an organization, proper data management is vital for innumerable reasons. Data is stored in various forms- computer, paper, or any form of electronic media. Some data can be obstructed after a certain period, but other data would be crucial for the operative management of a company. In other words, inadequate data management could contribute to the success or failure of an organization. Unfortunately many companies have dealt with large losses within their organization because of the loss of essential data. Therefore, managing data properly is imperative, regardless of its form. This is where special data management software is helpful to assist with updates, deleting and creating information (Meridian, 2012). In most organizations today, data is stored through computer. In the case of computer data, frequent backups of information should be conducted in case a break down, the backup software will store all of the vital information to the company. Management of data is also crucial for research and development. Because data management is vital for any organization, business, government, etc. it is imperative to implement a backup plan into your data management strategy (Meridian, 2012). Data processing and data management are crucial mechanisms of business organizations today. When it comes to data management, data is organized in a hierarchy that starts with the smallest piece of information used by a computer. Data management strategy is imperative in the business world today. It is an important resource in the operations of business that aids in the efficiency and decisions made within an organization. That being said it is important that everyone within the organization is involved with the strategy and that it aligns with the goals and objectives of the business. Change is inevitable when dealing with business, and the same goes for data management. A company must be able to adapt,…

    • 2264 Words
    • 10 Pages
    Better Essays
  • Powerful Essays

    The software system for data storage, on the other hand, will be designed as a web-based for data application and shall provide the following functionalities:…

    • 3515 Words
    • 15 Pages
    Powerful Essays
  • Good Essays

    This paper is designed to discuss the structure and use of a database system that is currently being used by a nationally recognized telecommunications and entertainment company. It will contain information about the specific type of database that is being used by this company. According to Webopedia, “a database is a collection of information organized in such a way that a computer program can quickly select desired pieces of data. You can think of a database as an electronic filing system” (Database, 2011). Every company has some type of database system that holds information that needs to be accessed regularly by the employees to be used to complete a task or goal. There will be some recommendations of improvements to the company procedures of the use of the described database.…

    • 853 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    Assumption ........................................................................................ 3 1. 2. 3. 4. 5. 6. Conceptual Data Model ...................................................................... 4 Relational Schema .............................................................................. 5 Normalization ..................................................................................... 6 SQL Code and Testing........................................................................ 12 Screen Design and Testing .................................................................. 18 Report Design and Testing .................................................................. 27…

    • 1809 Words
    • 8 Pages
    Powerful Essays
  • Satisfactory Essays

    Bca Se Syllabus

    • 1858 Words
    • 8 Pages

    Block 1 : DBMS concepts : Introduction – Basics of Database – Three views of Data – Three level architecture of DBMS – Facilities – Elements of DBMS – Advantages and disadvantages – Database Models : File Management system and its drawbacks – Database Models : E-R Model, Hierarchical Model, Network Model, Relational Model.…

    • 1858 Words
    • 8 Pages
    Satisfactory Essays