Skip to content

Latest commit

 

History

History
32 lines (32 loc) · 1.05 KB

README.md

File metadata and controls

32 lines (32 loc) · 1.05 KB

DBMS-Project

Requirement

Node.js
Plateform--optional

git clone https://github.com/RuitaoWu/DBMS-Project.git  
cd DBMS-Project  
npm install

Database

  • Before run the code make sure you have local database/schema named "dbms"
  • Before run make sure you have user account "comp440"
  • Execute the following SQL script if there has access denied SQL error
  • ALTER USER 'comp440'@'localhost' IDENTIFIED WITH mysql_native_password BY 'pass1234'
  • User 'comp440' may occurs error if the privilege isn't sufficient

Crruent Feature(s)

  1. New User register
  2. log in
  3. log out
  4. Initialize the database table
  5. User can post 2 blogs per day
  6. User can only comment blog one time
  7. User can't comment his/her own blog
  8. Empty prevention
  9. Display user blogs with positive comment
  10. Display user(s) post most blog on 2020-10-10
  11. Display mutual leaderid of user X and Y
  12. Display blogs with tag X
  13. Display user(s) who never post comment