Course Search:
Request more details:


Print Page

Oracle Foundation: Relational Database Design

Description:
This course covers the steps involved in the design of a relational database using the Oracle CASE *Method.
  • Cost: Price on application
  • Duration: 1 Day
  • This course is not available as part of our public schedule but can be provided on a customised client specific basis.
Prerequisites:
None
Introduction:
What is a data model?
Why develop and utilise an entity relationship model
Other aspects of the data model
Data model input
Components of an entity relationship model
Entities:
Definition
Examples
Determining entities
Entity classification
Relationships:
Definition
Examples of relationship ends
Examples of relationship types
Determining relationships
Attributes:
Definition
Examples
Determining attributes for each entity
Unique identifiers
Determining UID`s
Unique identifiers within a relationship
The E/R Model:
Reading the E/R model
Syntax
Guidelines for a model review
Appearance guidelines of the E/R model
Entity Topics:
Supertypes and subtypes
Exclusive arcs
Internal vs. external entities
Referenced and referencing entities
Advanced Topics:
Resolving many to many relationships
Domains
Derived attributes
Cascading
Non-transferable relationship
Qualified degree
Valid/invalid relationships
Normalisation


Dublin: 01 6627700 - Cork: 021 4319010 - Limerick: 061 311982

© Professional Training Solutions Limited 1996-2012
CRO No. 252390 - Unit 22, Westland Square, Pearse Street, Dublin 2, Ireland.