Home > Databases and data storages > Relational databases - Designing

Module: Databases and data storages

Topic: Relational databases - Designing

1. Lesson: Introduction to relational databases
2. Lesson: Designing relational databases
3. Assessment: Assessment 1

---

---

Lesson 1

Introduction to relational databases

Self Learning Duration

30 mins

Lecture Duration

30 mins

Self learning content

https://www.youtube.com/watch?v=QpdhBUYk7Kk

Lecture content

Brief introduction about relational database technologies and the concept of relations.

http://www.nyu.edu/classes/jcf/CSCI-GA.2433-001_sp12/slides/session3/EnterpriseDataModelingUsingTheEntity-RelationshipModel.pdf

Lab and tutorials

None

Assessment

None

---

---

Lesson 2

How to design a relational databases

Self Learning Duration

180 mins

Lecture Duration

240 mins

Lab Tutorial Duration

120 mins

Self learning content

https://www3.ntu.edu.sg/home/ehchua/programming/sql/Relational_Database_Design.html

Lecture content

• Discuss about relationships
• How to identify relationships based on shopping card system scenario
• Design an ERD diagram for shopping cart system

Lab and tutorials

Students are suppose to create an ERD for a business case (Shopping cart, Student reg sys)

Assessment 1

Create an ER diagram for a shopping cart system.