Logical Design

Database    |    Beginner
  • 11 videos | 1h 17m 39s
  • Includes Assessment
  • Earns a Badge
Likes 148 Likes 148
The logical design model consists of taking the conceptual diagram and converting it to represent the logical implementation of the database. Explore the entities, attributes, and relationships that exist in the logical model.

WHAT YOU WILL LEARN

  • describe the logical data model and its advantages
    define entities in the logical data model for designing a database
    identify the different categories of attributes that are used in a logical data model
    define the data types for attributes in a logical data model
    define DEFAULT and CHECK constraints and nullibility for attributes in a logical data model
    describe the different keys used in a logical data model
  • describe referential integrity and foreign key constraints for a logical data model
    define relationships in a logical data model for designing a database
    define advanced relationships in a logical data model
    model entity supertypes and subtypes in a logical data model
    resolve many-to-many relationships when building a logical data model

IN THIS COURSE

  • 3m 49s
    After completing this video, you will be able to describe the logical data model and its advantages. FREE ACCESS
  • 7m 5s
    In this video, you will learn how to define entities in the logical data model for designing a database. FREE ACCESS
  • Locked
    3.  Defining Attributes
    8m 17s
    In this video, you will learn how to identify the different categories of attributes that are used in a logical data model. FREE ACCESS
  • Locked
    4.  Defining the Data Type
    7m 8s
    In this video, you will learn how to define the data types for attributes in a logical data model. FREE ACCESS
  • Locked
    5.  Defining Constraints and Nullibility
    7m 27s
    Find out how to define DEFAULT and CHECK constraints and nullability for attributes in a logical data model. FREE ACCESS
  • Locked
    6.  Defining Keys for Tables
    9m 3s
    After completing this video, you will be able to describe the different keys used in a logical data model. FREE ACCESS
  • Locked
    7.  Defining Referential Integrity
    6m 21s
    After completing this video, you will be able to describe referential integrity and foreign key constraints for a logical data model. FREE ACCESS
  • Locked
    8.  Defining Relationships
    6m 28s
    Find out how to define relationships in a logical data model in order to design a database. FREE ACCESS
  • Locked
    9.  Advanced Relationship Modeling
    7m 51s
    Find out how to define advanced relationships in a data model. FREE ACCESS
  • Locked
    10.  Modeling Entity Supertypes and Subtypes
    9m 3s
    In this video, you will learn how to model entity supertypes and subtypes in a logical data model. FREE ACCESS
  • Locked
    11.  Resolving Many-to-many Relationships
    5m 9s
    To resolve many-to-many relationships when building a logical data model, you can use a junction table. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Channel Microsoft Certified: Power BI Data Analyst Associate
Likes 245 Likes 245  
Book Power BI Data Modeling: Build Interactive Visualizations, Learn DAX, Power Query, and Develop BI Models
Course Database Fundamentals: Database Administration Basics

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Book Relational Database Design and Implementation, Fourth Edition
Course Relational Algebra & Calculus
Likes 41 Likes 41  
Course Normalization Concepts & Forms
Likes 186 Likes 186