Logical Design

Beginner
  • 11 Videos | 1h 23m 9s
  • Includes Assessment
  • Earns a Badge
Likes 71 Likes 71
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

  • Playable
    1. 
    Overview of the Logical Database Design
    3m 49s
    UP NEXT
  • Playable
    2. 
    Defining Entities
    7m 5s
  • Locked
    3. 
    Defining Attributes
    8m 17s
  • Locked
    4. 
    Defining the Data Type
    7m 8s
  • Locked
    5. 
    Defining Constraints and Nullibility
    7m 27s
  • Locked
    6. 
    Defining Keys for Tables
    9m 3s
  • Locked
    7. 
    Defining Referential Integrity
    6m 21s
  • Locked
    8. 
    Defining Relationships
    6m 28s
  • Locked
    9. 
    Advanced Relationship Modeling
    7m 51s
  • Locked
    10. 
    Modeling Entity Supertypes and Subtypes
    9m 3s
  • Locked
    11. 
    Resolving Many-to-many Relationships
    5m 9s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 32 Likes 32  
Likes 0 Likes 0  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 16 Likes 16  
Likes 45 Likes 45  
Likes 209 Likes 209