I/S Resource Group: Relational Database Design, Relational, database, design, data, modeling, entity, entities, relationship, diagram, domain, relation, key, referential, integrity, view, normal, form, functional, transitive, dependency, clustering, partitioning, SQL

Relational Database Design

Abstract
(3 Days)

This course provides the techniques and tools to perform data analysis on the information components of an organization, develop a data model for that data and then create efficient relational database objects in which that data can be stored. Upon completion of this course, students should be able to design relational database structures that support relational database queries, while avoiding the query problems and anomalies that result from poor database design.

Audience

This course is open to application programmers and analysts who wish to understand good relational database design.

Topics

Examples of query anomalies that result from poor design
Data modeling – entity-relationship diagrams
- Entities
- Domains
- 1-1, 1-many and many-many relationships
Relational data model
- Relations
- Keys
- Referential integrity
- Views
Converting an entity-relationship diagram to relation definitions
Relation normalization
- 1st to 5th normal forms
- Functional and transitive dependencies
Indexing, clustering and partitioning
SQL statements to implement the relational database design
- CREATE TABLE
- CREATE VIEW
- CREATE INDEX

Supervised Exercises

Each class session will be accompanied by a set of written exercises designed to reinforce the classroom material.