Relational Database Concepts

Outline

1. Contents
2. Description
3. Audience
4. Prerequisites
5. Topics Include
6. Duration
7. Minimum Requirements
8. Media

Description

Teaches practical and useful information about database management systems, their design and environment.

Audience

Programmers, systems analysts, designers, computer operators, managers, support personnel and end users.

Prerequisites

none

Topics Include

What is a Database?

• Data Organization
• Introduction
• Records and Files
• Databases
• Data-Related Goals
• Increase Data Independence
• Reduce Data Redundancy
• Increase Data Security
• Maintain Data Integrity
• Typical Database Users

Types of Database Systems

• Hierarchical Databases
• Network Databases
• Relational Databases

Database Life Cycle

• Stage 1: Initiation
• Stage 2: System Analysis
• Stage 3: System Design
• Stage 4: System Development- The Conceptual Model, Assigned Responsibilities, Programming
• Stage 5: Implementation - Acceptance of a New System, Potential Problems

What is a Database Management System (DBMS)?

• Database Origins
• Introduction
• File Processing Systems
• Data Duplication
• Data Integrity
• Elements of a DBMS
• DBMS Primary Functions
• Protect the Database from Users
• Assist Users in Manipulating Data
• Host Language Interface
• Fourth Generation Language
• Coding a Fourth Generation Language
• Query Languages
• A Query Language: Rendezvous
• Structured Query Language (SQL)
• The Data Dictionary

User’s View of a Database

• Logical Database Design
• Introduction
• Logical Database Design Steps
• Step 1: Identifying the Data Elements - Common Data Elements, Identifying Data Elements, Examples of Data Elements, Relationship Classes, The Next Step
• Step 2: Developing the Logical Model - Format of Rules for Attribute Values, Relations (Tables)

Normalization of Data

• Normalization
• Introduction
• Creating an Un-Normalized Table
• First Normal Form (1NF)
• Second Normal Form (2NF)
• Third Normal Form (3NF)
• Reviewing the Normalization Process
• Optimizing the Database
• Implementing the Database

The Data Dictionary/Directory System

• Purpose of a DD/DS
• Introduction
• DD/DS and Security Issues
• Other DD/DS Uses
• DD/DS User Categories
• DD/DS Components
• The Data Dictionary
• The Data Resource Dictionary
• The Metadata Dictionary
• Passive System Architecture
• Active System Architecture
• DD/DS System Architecture

Database Administration

• Overall Scope
• Introduction
• The Database Administrator
• Database Administrator Functions
• Database Administration Group
• Technical Responsibilities
• Education and Training
• Managerial Responsibilities
• Priorities and Goals
• Policy Formation
• System Development Involvement

Duration

7 hrs

Minimum Requirements

IBM 486 PC or compatible, SVGA color monitor, 8MB RAM, 36MB free hard disk space, Windows 3.1/Windows ‘95 or Windows NT.

Media

Diskette
CDROM

© Copyright Serebra Learning Corp., 2002