|
(703) 246-9100 Northern Virginia (804) 285-5830 Central Virginia (757) 420-3810 Tidewater Area (800) 294-7497 Toll Free (804) 285-3722 Fax |
|
(703) 246-9100 Northern Virginia (804) 285-5830 Central Virginia (757) 420-3810 Tidewater Area (800) 294-7497 Toll Free (804) 285-3722 Fax |
ORACLE FOUNDATION: RELATIONAL DATABASE DESIGN
Duration: 2 days
Course Description:
This course covers the steps
involved in the design of a relational database using the Oracle
CASE*Method.
You can learn …
An understanding of a relational model
To converse in relational database terminology
Who Needs to Attend:
Application Designers, Developers
and Database Administrators
Prerequisites:
None
Course Labs:
Entity Identification
Modeling
Relationship
Subtype and Exclusive Arc
Resolving M:M
Normalization
Course Content:
What is a data model? Why develop and utilize an entity relationship model?
Other aspects of the data model, Date model input, Components of an entity relationship model
Definition, Examples
Determining entities, Entity classification
Definition of relationships, Examples of relationship ends and types, Determining relationships
Definition and examples of attributes, Determining attributes for each entity
Unique identifiers, Determining UID’s
Unique identifiers within a relationship
Reading the E/R model
Syntax, Appearance guidelines of the E/R model, Guidelines for a model review
Supertypes and subtypes, Exclusive arcs
Internal vs. external, and Referenced and referencing entities
Resolving many to many relationships
Domains, Derived attributes, Cascading
Non-transferable relationship, Valid/invalid relationships
Qualified degree, Normalization
Unique Training Solutions for Unique Clients - Expanding skills today to meet the challenges of tomorrow
