Relational Modeling in Dia
Offered By: Coursera Project Network via Coursera
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