Week3 LESSONPLAN

Lesson 3: Database design, normal forms, SQL injection

Objective: This class invites students to discuss Entity Relationship Diagram (ERD). Students should be able to explain their choices of entities, relationships, attributes etc. SQL injection should be explained with a demonstration (with a simple JS client). Concepts of database transaction, ACID properties, normal forms should be introduced with examples / live coding (creating a transaction, committing and rollback-ing).

Topics to be covered

Entity Relationship Diagrams

- Associative entities from many-to-many relationships
- Boolean attribute instead of a table