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.
Basic Data Management Concepts
Organizing Data in a Database
Database Management Systems
Using Database Systems in Organizations
Please discontinue use of cell phone and turn off ringer
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
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.
A collection of data organized to meet user’s needs.
File or Table
Fields are set to hold specific types of data.
A Database is a collection of files/tables
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.
Which field would act as the best primary key?
7.2 Organizing Data in a Database
In a relational database, tables are linked (related) through common fields.
Makes use of primary key
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.
7.3 Database Management Systems
Single User vs. Multiuser
General-Purpose vs. Special-Purpose
A schema is an outline of the logical and physical structure of the data and relationships among the data in the database.
A data dictionary provides a detailed description of all data used in the database.
Data can be sifted, sorted and queried through the use of data manipulation languages.
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.
SELECT * FROM EMPLOYEE WHERE JOB_CLASSIFICATION = ‘C2”
7.4 Using Database Systems in Organizations
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.
Business Intelligence is the use of data mining to help increase efficiency, reduce costs, or increase profits.
7.5 Database Trends
The Web is frequently used as the Front End of DBMS’s.
Visual, audio, and unstructured database systems organize non-textual data.
7.6 Managing Databases
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?
Don’t forget to turn your phone on!!