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

Database Creation and Modeling using MYSQL Workbench
Coursera Project Network via Coursera
MYSQL Workbench إنشاء و تصميم قواعد البيانات باستخدام
Coursera Project Network via Coursera
Intermediate Relational Database and SQL
Coursera Project Network via Coursera
Database Foundations: Data Structures
LinkedIn Learning
FileMaker: Relational Database Design
LinkedIn Learning