Relational Database Design (Coursera)

Relational Database Design can be taken for academic credit as part of CU Boulder’s Master of Science in Data Science (MS-DS) degree offered on the Coursera platform. The MS-DS is an interdisciplinary degree that brings together faculty from CU Boulder’s departments of Applied Mathematics, Computer Science, Information Science, and others. With performance-based admissions and no application process, the MS-DS is ideal for individuals with a broad range of undergraduate education and/or professional experience in computer science, information science, mathematics, and statistics.

What You Will Learn

- Create Entity Relationship Models and Entity Relationship Diagrams

- Create Relational Models

- Normalize a Relational Model to 3NF

Syllabus

WEEK 1

Introduction to DBMS, and Entity Relational Models

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

WEEK 2

Relational Models

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

WEEK 3

Normalization

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

WEEK 4

Case Study

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.