|
Synopsis |
This course covers the principles of database design
from the conceptual model of the business to the logical and physical design of
the Ingres database. The course emphasizes the often overlooked
distinction between entities and facts, and stresses the importance of
extensibility, transparency and performance.
This course is intended for architects and designers but should also be
considered by lead programmers who need to explain a design to a development
team, or by anyone else who needs to understand a database design. |
 Customers in the US/Canada should
contact KB
Computer Associates to schedule this course |
|
Duration and Cost |
1 day, £350 / $685USD / €520, per seat, ex VAT |
Price excludes VAT and other applicable local taxes |
|
Location |
London, Manchester, Dublin, and
on-site world-wide |
|
|
Format |
Lecture |
|
Course
Code |
DBD |
|
|
Prerequisites |
This course has no formal prerequisites, however
some experience of analysis or business process modelling would be advantageous.
Some previous experience of using SQL may also be helpful but is not essential. |
|
|
Outline |
| Chapter 1 |
The Conceptual
Model |
| |
nature and purpose / informality / identification of
entities / graphical representation / enterprise specificity / recording
business rules / point of view / dealing with imprecision
|
| Chapter 2 |
The Logical Model |
| |
technology
independence / entities versus facts / propositions / redundancy and
normalization / First Normal Form explained / logical keys / conflation
of fact types / key irreducibility / 2NF / correlation versus functional
dependency / 3NF / 4NF / 5NF / SQL null / problems with SQL null /
insufficiency of normal forms / specialization / conceptual mapping
|
| Chapter 3 |
The Physical Model |
| |
performance / informed trade-offs / logical mapping / SQL DBMS versus
relational DBMS / denormalization / cost of denormalization / SQL data
types / default values / storage structures / heaps / hash tables / ISAM
tables / B-trees / physical key selection / secondary indices / vertical
and horizontal fragmentation (partitioning) / ...ON UPDATE CASCADE of
foreign keys / optimization |
|
Contact us
 |
|
|
Discounts are available for large
blocks of training or training credits bought at once. Contact us for
details. |
|
