Oracle Foundation: Relational Database Design

Request more details:

submit request
Description:
This course covers the steps involved in the design of a relational database using the Oracle CASE *Method.
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