The Database Approach

1. The Data Hierarchy

1.1. Bit (binary digit)

1.1.1. Byte

1.1.1.1. Field

1.1.1.1.1. Record

2. Database Management Systems (DBMS)

2.1. The relational database model is based on the concept of two-dimensional tables. It is usually designed with a number of related tables. Each of these tables contains records (listed in rows) and attributes (listed in columns).

2.1.1. A data model is a diagram that represents entities in the database and their relationships.

2.1.1.1. Entity

2.1.1.1.1. Atribute

3. Primary key is an identifier field that is unique and separates it's entity from others.

4. A secondary key is another field that has some identifying information, but typically does not identify the record with complete accuracy.

5. File Management Environment

5.1. Organizes data files

6. Database Management System

6.1. Minimizes problems:

6.2. Data redundancy (data was stored in multiple locations)

6.3. Data isolation

6.4. Data inconsistency

6.5. Maximizes the following:

6.6. Data security

6.7. Data integrity

6.8. Data independence

7. All information for this presentation was found in "Introduction to Information Systems" TG 2.2 and TG 2.3 by R. Kelly Rainer Jr. and Brad Prince