Coding And Development Project
&
Database Application Development
&
Database Application Development
Project Deliverables:
Low-fidelity prototype and a report detailing the website's functionalities & site-navigation map
Data Dictionary & Entity Relationship (ER) Diagram
Demonstration of API implementations of all SQL queries for all CRUD operations using Postman with at least one SQL query each for Create, Update, Retrieve, and Delete operations.
Restaurant review website and a video demonstration of the site. In addition, a Self-Directed Learning Report was also submitted.
Top-Left Image: Display of all restaurants in database.
Middle-Left Image: Display of restaurants filtered by Japanese cuisine.
Bottom- Left Image: Pop-up modal which allows logged-in users to add a review.
Bottom-Right Image: Pop-up modal showing more details of the specific restaurant. Such as reviews, descriptions, opening hours etc.
Top-Right Image: Display of top-navigation bar which allows user to go to login or register page.
The image on the top-left side shows restaurants stored in the database.
The image on the bottom-left side shows one of the slides for the write-up.
The image on the top-right side shows the final ER diagram.
Outcome of the Project:
A working restaurant review website that stores and retrieves data to/from a database.
What I learnt from the project:
Firstly, I learnt how to use JavaScript and HTML to create and code the website. It was an enriching experience as I was taught about various tools and create a look and feel of a website just by coding. Another aspect that I had learnt was the importance of good ER diagrams when using a database as they allow the programmer to better understand how they want the database and functions to work before they start to add data and SQL codes to retrieve or send the data.