DESIGNING RELATIONAL DATA MODELS | CONCEPTUAL, LOGICAL, AND PHYSICAL DATA MODELS

This video introduces conceptual, logical and physical data models based on a case study. You will learn about the types of data models - Relational and Dimensional Data Models. I will also introduce you to the 3 Normal Forms, the difference between Dimensions, Fact, Fact Tables, and how to design a Star Schema. Watch our previous video where we provide detailed explanations for creating a Dimensional Data Model Star Schema from the conceptual to the physical level in Microsoft Excel and SQL Server Management Studio
DIMENSIONAL DATA MODELING TUTORIALS -...
DIMENSIONAL DATA MODELING TUTORIALS -...

CASE STUDY
A company has several stores in multiple cities in the Province. The company manager wants to track product sales in all the stores. Design a data model that will meet the company's needs.
IN THIS VIDEO, WE SOLVED THIS QUESTION BY DESIGNING BOTH DIMENSIONAL MODEL (STAR SCHEMA) AND RELATIONAL MODEL

• #education
• #sql
• #sql_server_management_studio
• #tsql_queries
• #dimension_data_model
• #relational_data_model
• #fact
• #fact_table
• #dimensions
• #entities
• #attributes
• #degenrate_dimensions
• #ralph_kimball_methodology
• #bill_ilmon
• #star_schema
• #snow_flake
• #conceptual_model
• #logical_model
• #physical_model
• #database
• #primary_key
• #foreign_key
• #constraint
• #denormalization
• #normalization
• #1st_normal_form
• #2nd_normal_form
• #3rd_normal_form
• #business_process
• #grain
• #data_warehouse
• #entity_relationship
• #1nf
• #2nf
• #3nf