Oracle Foundation: Relational Database Design
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.
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
Examples of relationship ends
Examples of relationship types
Determining attributes for each entity
Unique identifiers within a relationship
Reading the E/R model
Guidelines for a model review
Appearance guidelines of the E/R model
Supertypes and subtypes
Internal vs. external entities
Referenced and referencing entities
Resolving many to many relationships