Creating a Conceptual Design

Beginner
  • 10 Videos | 1h 1m 49s
  • Includes Assessment
  • Earns a Badge
Likes 90 Likes 90
Proper database design ensures the database will perform as expected for its users. Explore conceptual design, entities, relationships, as well as creating and integrating views into an ERD.

WHAT YOU WILL LEARN

  • describe what  a conceptual design and an ERD are when designing a database
    define entities, attributes, and relationships for a conceptual ERD for designing a database
    determine the entities and attributes for a conceptual ERD for designing a database
    determine attributes for a conceptual ERD for designing databases
    determine the relationships between entities in a conceptual ERD for designing a database
  • intergrate views into an ERD for designing a database
    perform view integration into an ERD by performing step 1: preintegration analysis and step2: comparison of schemas
    perform view integration into an ERD by performing step 3: conformation of schemas and step 4: merging and restructuring schemas
    create an ERD for a database based on a scenario
    identify the steps for designing a database and create an ERD

IN THIS COURSE

  • Playable
    1. 
    Overview of Creating a Conceptual Design
    3m 24s
    UP NEXT
  • Playable
    2. 
    Overview of Entities, Attributes, and Relationships
    5m 32s
  • Locked
    3. 
    Determining Entities
    3m 14s
  • Locked
    4. 
    Determining Attributes and Keys
    6m 54s
  • Locked
    5. 
    Determining Relationships in an ERD
    8m 9s
  • Locked
    6. 
    Integrating Views into an ERD
    4m 18s
  • Locked
    7. 
    Conceptual Schema Integration – Steps 1 and 2
    6m 53s
  • Locked
    8. 
    Conceptual Schema Integration – Steps 3 and 4
    5m 26s
  • Locked
    9. 
    Creating an ERD for Designing a Database
    9m 40s
  • Locked
    10. 
    Exercise: Creating a Conceptual ERD
    3m 49s

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 53 Likes 53  
Likes 108 Likes 108  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 109 Likes 109  
Likes 16 Likes 16  
Likes 45 Likes 45