database systems
Skip this Video
Download Presentation
Database Systems

Loading in 2 Seconds...

play fullscreen
1 / 36

Database Systems - PowerPoint PPT Presentation

  • Uploaded on

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.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Database Systems' - milos

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

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?

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”
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.

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!!