DTSA 5733 Relational Database Design

  • Specialization:Ìý¶Ù²¹³Ù²¹²ú²¹²õ±ð²õ
  • Instructor:ÌýDiÌýWu, Assistant Professor
  • Prior knowledge needed:Ìý

Learning Outcomes

  • Understand and explain Entities and Relationships.
  • Draw ERD(Entity Relationship Diagrams).
  • Understand and explain Relations.
  • Convert ERD to a Relational Model.
  • Understand and explain Normalization Forms and Process.
  • Normalize a Relational Model to Third Normal Form.

Course Content

Duration: 8h

Introduce students to Database Management Systems. Introduce and train students with how to build conceptual entity relationship models.

Duration: 9h

Introduce the concepts about relational models. Train students on how to convert a conceptual entity relationship model to a relational model.

Duration: 11h

Introduce students withÌýthe reasons and process of normalization. Train students with skills to normalize a relational model to 3NF.

Duration: 8h

A summary of the knowledge we learned in this course, starting from an Entity Relationship Model to a Relational Model in 3NF and ready for implementation.

Duration: 6h

You will complete a peer reviewed final project worth 20% of your grade. You must attempt the final in order to earn a grade in the course.ÌýIf you've upgraded to the for-credit version of this course, please make sure you review the additional for-credit materials in the Introductory module and anywhere else they may be found.

Note: This page is periodically updated. Course information on the Coursera platform supersedes the information on this page. ClickÌýView on CourseraÌýbuttonÌýabove for the most up-to-date information.