Back
|
|
|
RELATIONAL DATABASE & DATA MODELLING OVERVIEW
Delegates: |
|
Delegates who require an understanding of relational databases.
|
Objectives: |
|
On completion of this course, delegates will have an understanding of the structure
of a Relational Database Management System and have sufficient knowledge to converse
with RDBMS professionals.
|
Topics Covered: |
- Introduction to Databases
- Database Management Systems
- Database System Development
- Conceptual Data Models
- Entities
- Attributes
- Relationships
- Constraints
- Assumptions
- Identifying Entities, Attributes, Relationships
- Sub-type/Super-type relationships
- Arc, Non-transferable and Redundant Relationships
- Recursive Relationships
- Normalisation
- The Relational Model
- Structure
- Relational Terminology
- A Relational Schema
- Implementing Constraints
- Implementing Sub-type/Super-type Relationships
- Views
- Denormalisation
|
Requirements:
|
|
An understanding of Information Technology concepts and computer terms. |
|
|
|
