Relational Modeling in Dia

4.7
95 個評分
提供方
Coursera Project Network
1,790 人已註冊
在此指導項目中,您將:

Transfer entities and attributes from an ERD into a Relational Model.

Resolve one-to-many and many-to-many relationships in a Relational Model.

Draw a Relational Model Using the Dia diagramming tool.

Clock50 minutes
Beginner初級
Cloud無需下載
Video分屏視頻
Comment Dots英語(English)
Laptop僅限桌面

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.

您要培養的技能

  • Database (DB) Design
  • Relational Model
  • Dia Diagramming
  • Relational Database
  • Foreign Keys

分步進行學習

在與您的工作區一起在分屏中播放的視頻中,您的授課教師將指導您完成每個步驟:

  1. ERD Revisited

  2. Relational Model Components

  3. Entities and Attributes

  4. Adding Tables and Primary Keys

  5. One-to-Many Relationships

  6. Many-to-Many Relationships

  7. The Complete Relational Model

指導項目工作原理

您的工作空間就是瀏覽器中的雲桌面,無需下載

在分屏視頻中,您的授課教師會為您提供分步指導

授課教師

審閱

來自RELATIONAL MODELING IN DIA的熱門評論

查看所有評論

常見問題

常見問題

還有其他問題嗎?請訪問 學生幫助中心