Database Design

SpiralTrain BV

In the course Database Design participants learn the techniques and considerations for creating a well-structured database.

Price

from €1,599

Level

Not specified

Kind

Training

Subject

Automation and IT, Training and education

More information and registration at SpiralTrain BV

Description

Intro Database Management Systems The course Database Design starts with a discussion of the basic architecture of Database Management Systems. Attention is paid to the Database Schema and the differences between the conceptual, logical and physical model. The role of SQL, Data Definition Language (DDL) and Data Manipulation Language (DML) is also discussed. Database Design Subsequently the phases of Database Design and the components of a database are treated. The ERD Model and the UML Model are covered here. Possible design errors and the application of constraints are also reviewed. ER Modeling In the ER Modeling section participants learn how to discover the entities and their relationships and map them to tables. They learn the principles of Entity Relationship Modeling. Also treated is how to find and model attribute domains. Table Mapping Then attention is paid to how entities and their relations can be translated into tables in a relational database. The different mapping strategies for hierarchies of entities are also covered such as table per class, table per hierarchy and the use of discriminator columns.