Oracle Foundation: Relational Database Design

This course has been superseded

Try searching for alternatives

Course Description

This course covers the steps involved in the design of a relational database using the Oracle CASE *Method.
1 Day
Contact us for pricing
 

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