Database systems
Sponsored Links
This presentation is the property of its rightful owner.
1 / 36

Database Systems PowerPoint PPT Presentation

  • Uploaded on
  • Presentation posted in: General

Database Systems. Basic Data Management Concepts Organizing Data in a Database Database Management Systems Using Database Systems in Organizations Database Trends Managing Databases. Please discontinue use of cell phone and turn off ringer. Chapter 7. The Value of Databases.

Download Presentation

Database Systems

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript

Database systems

Database Systems

Basic Data Management Concepts

Organizing Data in a Database

Database Management Systems

Using Database Systems in Organizations

Database Trends

Managing Databases

Please discontinue use of cell phone and turn off ringer

Chapter 7

The value of databases

The Value of Databases

Databases and Database Management Systems (DBMS) transform large quantities of data into specific and valuable information for accomplishing some goal.

7 1 basic data management concepts

7.1 Basic Data Management Concepts

Key Terms

  • DBMS

  • Field

  • Record

  • File

  • Primary Key

Database management system dbms

Database Management System (DBMS)

A DBMS consists of a group of programs that manipulate the database and provide an interface between the database and the user or the database and application programs.




Front End

Back End



A collection of data organized to meet user’s needs.

File or Table


Records (Entities)

Database fields

Database Fields

Fields are set to hold specific types of data.



A Database is a collection of files/tables

Database heirarchy

Database Heirarchy

Keys and primary key

Keys and Primary Key

Key: A field in a record that is used to identify the record

Primary key: A field that uniquely identifies a record

A primary key field prevents duplicate records from occurring in a table.

Primary keys

Primary Keys

Which field would act as the best primary key?

Primary keys1

Primary Keys

Database systems

Primary Key

Simple but restrictive dbms

Simple but Restrictive DBMS

The database approach to data management

The Database Approach to Data Management

7 2 organizing data in a database

7.2 Organizing Data in a Database

Key Terms

  • Relational Model

  • Data Analysis

The relational model

The Relational Model

In a relational database, tables are linked (related) through common fields.

Relation types

Relation Types


Most typical

Makes use of primary key



Data analysis

Data Analysis

GIGO, or Garbage In Garbage Out, refers to the fact that inaccurate data entered in a database will result in inaccurate information produced from the database.

  • Data analysisis a process that involves evaluating data to identify problems with the content of a database.

    • Consider what would happen if CardNumber were not a primary key, and two or more customers had the same CardNumber.

  • Data Integrity refers to the accuracy of the data in a database.

Northwind database example

Northwind Database Example

7 3 database management systems

7.3 Database Management Systems

Key Terms

  • Data Integrity

  • GIGO

  • Schema

  • Data Dictionary

  • SQL

Database types

Database Types

Single User vs. Multiuser

General-Purpose vs. Special-Purpose


Creating a database

Creating a Database

A schema is an outline of the logical and physical structure of the data and relationships among the data in the database.

Creating a database1

Creating a Database

A data dictionary provides a detailed description of all data used in the database.

Database strengths

Database Strengths

Data can be sifted, sorted and queried through the use of data manipulation languages.

  • The power of a database and DBMS lies in the user’s ability to manipulate the data to turn up useful information.

Data manipulation language

Data Manipulation Language

A Data Manipulation Language (DML) is a specific language provided with the DBMS that allows people and other database users to access, modify, and make queries about data contained in the database, and to generate reports.

Structured Query Language (SQL): The most popular DML.


7 4 using database systems in organizations

7.4 Using Database Systems in Organizations

Key Terms

  • Data Warehouse

  • Data Mining

Data stores

Data Stores

Data Warehouse: A database that holds important information from a variety of sources.

Data Mart: A small data warehouse, often developed for a specific person or purpose.

  • Data Mining: the process of extracting information from a data warehouse.

    • “Connecting the dots”

Data stores1

Data Stores

Business intelligence

Business Intelligence

Business Intelligence is the use of data mining to help increase efficiency, reduce costs, or increase profits.

7 5 database trends

7.5 Database Trends

Key Terms

  • Distributed Database

Databases and the internet

Databases and the Internet

The Web is frequently used as the Front End of DBMS’s.

Distributed database

Distributed Database

Other types of databases

Other Types of Databases

Visual, audio, and unstructured database systems organize non-textual data.

7 6 managing databases

7.6 Managing Databases

Key Terms

  • Database Administrator

Database administrator

Database Administrator

A database administrator (DBA) is a skilled and trained computer professionals who directs all activities related to an organization’s database, including providing security from intruders.

Chapter 7 questions

Chapter 7 Questions?

Don’t forget to turn your phone on!!

  • Login