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

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

CHANNEL Architecting Data
Likes 83 Likes 83  
BOOK Digital VLSI Design and Simulation with Verilog
CHANNEL Wintellect Software Architecture

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Normalization Concepts
Likes 45 Likes 45  
COURSE Concepts & Conceptual Design
Likes 298 Likes 298  
COURSE Relational Algebra & Calculus
Likes 41 Likes 41