|
Class Agenda:
- Relational database terminology
- What is a data model?
- Benefits of data modeling
- Gather and document business requirements
- Data model input
- Identifying entities, attributes and relationships
- Handling complex relationships such as many-to-many, recursion, supertypes, subtypes and exclusive arcs
- Determine entity unique identifiers (primary keys)
- Implementing relationships with foreign keys
- Domains and derived attributes
- Producing an entity relationship diagram
- Producing table diagrams
- Normalizing to 5th normal form
- Denormalization
- What is a physical data model?
|
|
Prerequisites:
- No prerequisites are required for this course.
Audience:
- This course is designed for all database professionals and non-technical professionals including:
- Developers
- Database Administrators
- Application Designers
- Business Analysts
- Others concerned with logical database design
Course Benefits:
Students will understand the principles and tasks of relational data modeling and be able to communicate using relational database terminology. Students will also be able to translate business requirements into logical data models.
Materials Furnished:
- Lecture and discussion followed by team-based workshops for each major topic to reinforce the material.
- Each participant will receive an extensive lecture guide with several examples and workshop solutions.
Recommended Follow-On Course:
- Oracle 9i Fundamentals
- Oracle 9i PL/SQL Fundamentals
Course Length: Two Days
List Price: $990
|
