Temasek Polytechnic
School of Informatics IT
Database Application Development CIA1C06
AY 1920 Oct Semester
Project Part 3
SQL and ServerSide Codes
Name:
Lim Ko Pi
Admission Number:
1234567D
Class:
P01
Table of Contents
SQL Codes 3
SQL Codes
Write out the related SQL codes, route pattern and HTTP method for every functionality that your web application has. You will demonstrate to your Lecturer if the functionalities work using Postman based on the routes you created in the route file, and the functions that you wrote in the controller and DB files.
Functionalities of Web Application
Related SQL code
URL Route Pattern
HTTP Method
Result From Postman
PassFail
To be filled by Lecturer
Login
SELECT password FROM ..
login
GET
Add a new userRegistration
INSERT INTO user ..
addUser
POST
Update password by user ID
GET
Update User details by user ID
UPDATE users SET ..
updateUser:userid
PUT
Display user status by userstatus
Delete a user by user ID
DELETE FROM user ..
deleteUser:userid
DELETE
Create new restaurant
INSERT INTO restaurant
Display all restaurant by Restaurattype
POST
Display restaurantdetails by restaurantid
Delete restaurant
Create new reviews
Display reviews by reviewid
Update the review by reviewid
Delete review by reviewid
Create new booking
Update the booking by bookingid
Display booking by bookingid
Delete booking by bookingid