1 / 34

Data Modeling for Data Warehouse

What is Data Modeling?<br>What is the importance of Data Modeling?<br>Who should be involved in the Data Modeling process?<br>What is a relationship & What are 3 types of relationships?<br>what are the different levels of Data Modeling?<br>What is key in the database? & What is the difference between a composite key, primary key, and foreign key?<br>What do Clustered and Non clustered index actually mean?<br>what's the difference between view, trigger, and stored procedures?

Jasmine_Ibrahime
Download Presentation

Data Modeling for Data Warehouse

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Data Modeling for Data warehouse

  2. Agenda

  3. What is Data Modeling ?

  4. What is Data Modeling?

  5. What is the importance of Data Modeling?

  6. Who should be involved in the Data Modeling process?

  7. How we Model data?

  8. 1. Entity specification

  9. 2. Relationship specification

  10. 2.1. Relationship Cardinality

  11. Attribute specification

  12. Key Attributes Specification

  13. Key Attributes Specification

  14. Candidate key

  15. Alternate key, Primary key and Foreign Key

  16. Primary key vs. Foreign Key

  17. Other Key Attributes

  18. what are the different levels of Data Modeling ?

  19. The Conceptual model

  20. The Conceptual model

  21. The Logical Model

  22. The Logical Model

  23. The Physical Model

  24. The Physical Model

  25. The Physical Model

  26. The Index

  27. The Index

  28. Cluster VS. Non-Cluster index

  29. The View

  30. The Stored Procedure

  31. The Trigger

  32. Summary of the differences between the levels of data modeling;

  33. References

More Related