| Data Modeling |
| |
| This course introduces the principles of relational databases and relational database design. Business requirements will be incorporated into a logical data model. The components of a logical data model are defined and represented as an entity relationship diagram and table diagrams. Table construction rules and data normalization rules will be discussed as well as supertypes, subtypes and recursive relationships. |
|
| Covered Topics: |
- 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: |
|
| 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: |
- Student Manual
- 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
|
|
|
|
|
|
