1.2 Introduction to Database

Dependencies

Refer to the following markdown file for the respective sections of the class:

• Self Studies
• Lesson
• Assignment
• Quiz
• Reference

Lesson Objectives

Learners will understand:

• Relational database
• Conceptual, logical and physical data model
• Data modeling
• Schema design
• Entity-relationship diagram (ERD)
• Normalization

Learners will be able to:

• Design database schema using DBML
• Create ERD from case study
• Normalize database schema

Lesson Plan

Duration	What	How or Why
- 5mins	Start zoom session	So that learners can join early and start class on time.
20 mins	Activity	Recap on self-study and prework materials.
40 mins	Concept	Part 1: Introduction to database.
	1 HR MARK
45 mins	Concept	Part 2: Data modeling. Demonstrate and guide learners on how to create ERD from case study.
15 mins	Break
	2 HR MARK
45 mins	Code-along	Part 3: Normalization. Demonstrate and guide learners on how to normalize database schema.
15 mins	Briefing / Q&A	Brief on references, assignment, quiz and Q&A.
	END CLASS 3 HR MARK