Skip to content

Latest commit

 

History

History
33 lines (22 loc) · 1.15 KB

README.md

File metadata and controls

33 lines (22 loc) · 1.15 KB
  1. Update mysql connections in DB.js
  2. To run on local; npm install then npm start - runs on localhost:3000

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