Web www.afleming.co.uk

Database Design

You are here : Home > More Lecture Materials > Database Design

Description

An introduction to databases and their benefits, their development and maintenance from sizing to backup and recovery. It also examines methods of ensuring database and data security.

Table of Contents

1. Database Design
   1. Definitions
   2. Advantages of a Database Approach
   3. Costs and Risk of a Database Approach
   4. Range of Database Applications
   5. Components of a Database Environment
   6. Evolution of Database Systems
   7. Starting Point for Creating a Database Structure
2. Indexing
3. Backup and Recovery
   1. Backup
   2. Recovery
   3. Selective Rollback/Forward
4. Database Sizing
   1. Table Spaces
   2. Index Sizing
   3. Archiving
5. Database Security
   1. Definition
   2. Access to the Database
   3. Access to the Data
   4. Roles of Database Users
   5. Approaches to Security
6. Data Security
   1. Data Integrity
   2. Database Locking
   3. Table/Page/Row Locking
   4. Dead-Lock
7. Concurrency
   1. Multi-user System
   2. Types of Locking
   3. Database Constraints

Download the material from here