YoVDO

Relational Modeling in Dia

Offered By: Coursera Project Network via Coursera

Tags

SQL Courses Relational Databases Courses Database Design Courses Foreign Keys Courses

Course Description

Overview

In this course you will learn to interpret and draw a relational model through hands-on exercises using a diagramming tool called “Dia”. You will complete the final step in the database design process as you convert the logical design documented in an Entity Relationship Diagram into a Relational Model. During the conversion, you will investigate relational modeling rules and practice modeling techniques as you learn to resolve one-to-many and many-to-many relationships using foreign keys and bridge tables. Your final Relational Model will become the blueprint for creating a database and its tables. Since data is at the center of any information system, knowledge and understanding of database design will serve you well as a database user or a database designer. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

Syllabus

  • Relational Modeling in Dia
    • In this course you will learn to interpret and draw a relational model through hands-on exercises using a diagramming tool called “Dia”. You will complete the final step in the database design process as you convert the logical design documented in an Entity Relationship Diagram into a Relational Model. During the conversion, you will investigate relational modeling rules and practice modeling techniques as you learn to resolve one-to-many and many-to-many relationships using foreign keys and bridge tables. Your final Relational Model will become the blueprint for creating a database and its tables. Since data is at the center of any information system, knowledge and understanding of database design will serve you well as a database user or a database designer.

Taught by

Judy Richardson and Melissa Al-Shaer

Related Courses

AWS Certified Database - Specialty (DBS-C01)
A Cloud Guru
AZ-304: Microsoft Azure Architect Design
A Cloud Guru
Advanced Features with Relational Database Tables Using SQLiteStudio
Coursera Project Network via Coursera
Advanced Monitoring and Optimizing with DynamoDB (Portuguese)
Amazon Web Services via AWS Skill Builder
Advanced Monitoring and Optimizing with DynamoDB (Spanish)
Amazon Web Services via AWS Skill Builder