程序代写代做 database Temasek Polytechnic

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