The final project of Database Design.

Project Requirements

Database - MySQL

Relational Diagram

Webserver - Node.js + Express

1. Install node.js (Official LTS version)
2. Install yarn (a package manager for JS) by npm install -g yarn
3. Install nodemon (a monitor for node.js application) by yarn global add nodemon

nodemon in the main directory

Go to Database directory cd Database

1. Create Database node Create_DB.js
2. Create Tables node Create_Table.js
3. Insert testing data (optional)
   1. node Insert_Console.js
   2. Copy paste the "*.txt" filenames listed in Index.txt
   3. After finishing. Terminate it by Ctrl + C

• Basic Login System
• Basic Database Connection

• User Register Page

  Reports

  • Unsold Work Page
    • Bargain mechanism
  • List All Artist Page
  • List All Customer Page

  Receipt

  • Transaction Record (i.e. Payment)

  • Works for Sale Upload Page

    User

    • Artist Report Page
    • Salesperson Page (show the Performance)

• David Lee - Website Front-end and Back-end
• Jimmy Zhang - Database

• Basic writing and formatting syntax
• Creating and highlighting code blocks

• Hello World
• Understanding the GitHub Flow

• Push local master to remote branch git push origin master:<remote branch name>
• Git pull and keep local changes