Data Modelling C.C
Table of Contents
Introduction about Data modelling
Types of modeling projects
- Transactional business systems
- Business intelligence and data warehousing systems
- Integration and consolidation of existing systems
- Maintenance of existing systems
- Enterprise analysis
- Commercial off-the-shelf application
Database
- Hierarchy of data
- TFBS
- DBMS
- RDBMS
- Codd Rules
Models
- Physical
- Logical
- Conceptual
Relationships
- One-to-One
- One-to-Many
- Many-to-Many
How to understand the data
Database design
- How to design
- Issues in database design
Diagrams
- Sources of requirements
- Functional decomposition diagrams
- Data flow diagrams
- Use case diagrams
- ER diagrams
- Workflow models
- Business rules
- State diagrams
- Class diagrams
- Other documentation
- Constraints