This three-week program aims to introduce the fundamental concepts of databases using MySQL.
By the end of this module, students should have a familiarity with and basic understanding of the following:
- Entities
- The relational model
- The Structured Query Language (SQL)
- The construction of a database system
- MySQL as an example of a relational database system
Objective: This class aims to incorporate JavaScript code to operate the MySQL database. MySQL client can be used to demonstrate SQL queries however, students should know how to make a MySQL database connection from JavaScript, run queries from JavaScript and capture results of queries in JavaScript.
Objective: This class introduces more clauses (group by, having) in the select statement. MySQL joins (inner, self, left and right) should be explained with demonstration (Employee table with reportsTo field and Department table with its PK in Employee table is suitable for this demonstration). Promise based JavaScript program with SQL prepared statements should be understood by students. The program can be found in the Week2 folder (Credits: @remarcmij)
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).
Take a look at this video made by Daan, he explains how your homework needs to be handed in.
Also review the Git workflow material from the JavaScript3 module, use this as a reference.