Skip to content

zuhairtaha/tasks-mysql-nodejs-app

Repository files navigation

tasks-mysql-nodejs-app

tasks web application using nodejs with expressjs framework and MySQL database

homework 1 question

homework 2 question

img1 img2 img3 img4 img5 img6 img7

PART 2

Create a new database containing the following tables: Class: with the columns: id, name, begins (date), ends (date) Student: with the columns: id, name, email, phone, class_id (foreign key) If you are done with the above tasks, you can continue with these advanced tasks: Create an index on the name column of the student table. Add a new column to the class table named status which can only have the following values: not-started, ongoing, finished (hint: enumerations).

uml

DataBase.sql