Build a Database from a Relational Model

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

Interpret a Relational Model diagram.

Construct database tables from a Relational Model.

Test a relational database design.

Clock1.5 Hours
Intermediate中級
Cloud無需下載
Video分屏視頻
Comment Dots英語(English)
Laptop僅限桌面

In this course you will interpret the components of a relational data model, convert that model into a relational database, and then test the database design. The process of database design begins with requirements analysis to determine who will use the new database and how it will be used. The results of the detailed analysis are recorded in an Entity Relationship Diagram (ERD), which documents entities and their attributes, along with the relationships between entities. The ERD (logical design) is then converted into the Relational Model, which serves as the blueprint for the actual creation of a database in a database management system. By the end of this course, you will have used a blueprint—a Relational Model—to create a database using SQLiteStudio. In addition, you will have developed test data and queries to validate the database design represented by the Relational Model. 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.

您要培養的技能

Relational ModelingRelational DatabaseSQLiteStudioDatabase TestingForeign Key

分步進行學習

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

  1. The Relational Model

  2. Build a Table with the SQLiteStudio GUI

  3. Build a table with SQL code

  4. The Combination Key

  5. Test Data

  6. Test the Database Design

指導項目工作原理

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

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

審閱

來自BUILD A DATABASE FROM A RELATIONAL MODEL的熱門評論

查看所有評論

常見問題

常見問題

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