Creating a Conceptual Design

Database    |    Beginner
  • 10 videos | 57m 19s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 153 users Rating 4.6 of 153 users (153)
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

  • 3m 24s
    Upon completion of this video, you will be able to describe what a conceptual design and an ERD are when designing a database. FREE ACCESS
  • 5m 32s
    Find out how to define entities, attributes, and relationships for a conceptual ERD when designing a database. FREE ACCESS
  • Locked
    3.  Determining Entities
    3m 14s
    To design a database, you need to determine the entities and attributes for a conceptual ERD. FREE ACCESS
  • Locked
    4.  Determining Attributes and Keys
    6m 54s
    To determine attributes for a conceptual ERD when designing databases, consult a reliable source. FREE ACCESS
  • Locked
    5.  Determining Relationships in an ERD
    8m 9s
    In this video, find out how to determine the relationships between entities in a conceptual ERD when designing a database. FREE ACCESS
  • Locked
    6.  Integrating Views into an ERD
    4m 18s
    In this video, you will learn how to integrate views into an ERD for designing a database. FREE ACCESS
  • Locked
    7.  Conceptual Schema Integration – Steps 1 and 2
    6m 53s
    In this video, learn how to perform view integration into an ERD by performing step 1: preintegration analysis and step 2: comparison of schemas. FREE ACCESS
  • Locked
    8.  Conceptual Schema Integration – Steps 3 and 4
    5m 26s
    Learn how to integrate views into an ERD by performing step 3: confirming schemas and step 4: merging and restructuring schemas. FREE ACCESS
  • Locked
    9.  Creating an ERD for Designing a Database
    9m 40s
    In this video, you will learn how to create an ERD for a database based on a scenario. FREE ACCESS
  • Locked
    10.  Exercise: Creating a Conceptual ERD
    3m 49s
    In this video, you will learn how to identify the steps for designing a database and create an ERD. 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

Rating 4.6 of 23 users Rating 4.6 of 23 users (23)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.6 of 142 users Rating 4.6 of 142 users (142)
Course SQL Developer
Rating 4.5 of 583 users Rating 4.5 of 583 users (583)