Share Description
In this course, you will :
- Learn the techniques required to create data models for your organisation.
- Use both the classic entity-relationship notation and the "crow's foot" notation to apply essential data modelling design ideas.
- Create semantically correct data models from entities, attributes, relationships, hierarchies, and other modelling components.
- Forward engineering is used to convert conceptual data models to logical and physical data models.
Syllabus :
1. Data Modeling Fundamentals
- Introduction to Data Modeling Fundamentals
- The Purpose and Role of Data Modeling
- Basic Data Modeling Concepts and Terminology
- Navigate Your Alternatives Among Methodologies, Techniques, and Notations
- Compare Data Modeling to Database Design
- Compare Transactional Data Modeling to Analytical Data Modeling
2. The Building Blocks of Data Modeling
- Introducing Data Modeling Building Blocks
- The Role of Entities in Data Modeling
- Add Attributes to Your Data Model
- Use Multi-Valued Attributes in Your Data Model
- Build Relationships into Your Data Model
3. Add Real-World Complexities to Entities and Attributes
- Why Real-World Complexities Matter in Data Modeling
- Build Hierarchies for the Entities in Your Data Model
- Specify Constraints for Your Attributes
- Specify Cross-Entity Dependencies Through Strong and Weak Entities
4. Add Real-World Complexities to Relationships
- Why Relationship Cardinality and Complexities Matter
- Build Real-World Complexities into Data Model Relationships
- Define the Maximum Cardinality of a Relationship
- Define the Minimum Cardinality of a Relationship
- Use Crow's Foot Notation for Minimum and Maximum Cardinality
5. Move Across the Different Levels of a Data Model
- Harmonize Different Levels of a Data Model
- A Brief Look at Relational Database Normalization
- Forward-Engineering Your Conceptual Data Model
- More Data Model Forward-Engineering
- Reverse-Engineer a Physical Model Back into a Conceptual Model
- Summarize How to Work with Different Levels of a Data Model
6. Software for Data Modeling
- The Importance of Data Modeling Software
- Build a Data Model with a Drawing Program
- Build a Model with a Data Modeling Software Tool
