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

    With a non-database system, much time and energy is lost in trying to maintain and use data. Using physical data storage requires a manual organization system and having to peruse through file cabinets or bookshelves of paperwork to find one piece of information or enter a new piece of information is inefficient in today's computerized society. As such, in the interest of making a more effective operation for Husky Air, computerizing their data storage will remove the…

    • 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

    Companies that use database management systems use the database approach to as opposed to the traditional approach, where customer data is maintained in separate files with each file relating to the process that is specific to the organization such as billing, shipping. The database approach is very advantageous to the organization because each application uses a collection of data that is related in the database.…

    • 592 Words
    • 3 Pages
    Good Essays
  • Better Essays

    Ordinarily a database management system is considered a modernized record keeping system. Not with standing, DBMS’s is an accumulation of projects, which are utilized to characterize, make and keep up databases. Essentially, DBMS’s is a universally useful programming…

    • 952 Words
    • 3 Pages
    Better 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

    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

    worker

    • 506 Words
    • 2 Pages

    There are many data management issues that need to be considered when dealing with new data, transferring data, or just storing data for long periods of time. For instance, if a corporation or business needs to store data for long periods of time, they may have to come up with multiple ways of storing the data in the event one device or method fails. Also, all things eventually wear out in time. Therefore, servers, hard drives, databases and any other technological data storing equipment or methods, must be constantly upgraded or maintained to prevent data rot and equipment failures.…

    • 506 Words
    • 2 Pages
    Good Essays
  • Better Essays

    Relational Databases

    • 4830 Words
    • 20 Pages

    Databases are possible because of their database management system (DBMS). As shown in Figure 4.2, the DBMS is a software program that sits between the actual data stored in the system and the application programs that use the data. As shown in Figure 4.4, this allows users to separate the way they view the data (called the logical view) from the way the data is actually stored (the physical view). The DBMS interprets the users ' requests and retrieves, manipulates, or stores the data as needed. The two distinct views separate the applications from the physical information, providing increased flexibility in applications, improved data security, and ease of use.…

    • 4830 Words
    • 20 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
  • 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
  • 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