Skip to content

armgitaar/tasks-mysql-nodejs-app

 
 

Repository files navigation

  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

Releases

No releases published

Packages

No packages published

Languages

  • JavaScript 45.6%
  • TSQL 33.9%
  • HTML 19.5%
  • CSS 1.0%