• SQL | W3Schools W3Schools have lots of clear simple example for different types of SQL queries

• Databases: how they work, and a brief history Amazing summary of the history of databases, what they are, how they work and the different types

• Database Relationships

• Summary of one of the most common ways web apps get hacked

• An example of how you might structure a project using Express & SQlite

This week focuses on building a dynamic e-commerce web application, integrating React for the frontend with a Node.js/Express backend and SQLite database. The emphasis is on creating a full-stack application with database integration and state management in React.

Workshops

Monday

Friday

Execute Program

• Finalise previous courses

Topics

• Database schema design and normalization

• SQLite database management and querying

• SQL syntax, focusing on SELECT and INSERT queries

Project

• Develop an e-commerce web application with the following features:

• Design and implement a SQLite database schema for products, orders, and users

• Create a React frontend that communicates with an Express backend

Additional Skills

• Database relationship modeling (one-to-many, many-to-many)

• Using foreign keys in relational databases

• Optimizing database queries for performance

Databases

• Learn how to design and structure a database schema for the application (K10, S8)

• Implement CRUD (Create, Read, Update, Delete) operations for products and orders (S1, S3, S16)

• Acquire skills in using SQLite to manage and query relational data efficiently (K10, S3)

• Be comfortable with SQL syntax and how to use SELECT and INSERT queries (K10. S3)

React

• Gain proficiency in using React to create dynamic and responsive user interfaces (K7, S2)

• Understand the use of state management in React to handle the shopping cart functionality (K11, S10)

Your project this week is TBC

Intro

Learners will develop an end-to-end dynamic e-commerce web application where users can browse and purchase products online.

The frontend of this project will be built using React. For the backend, it will use Node.js and Express to handle server-side functionality. User accounts and product data will be stored in a SQLite database.

Project

Your project for the next week will be to develop a Express backend connected to a SQLite database and linked to a React frontend. Your UI should provide methods so that users can search for and display information about items and add them to a shopping cart. It is up to you to determine the process and order you take to achieve this, but should plan this carefully and attempt to anticipate any hurdles you approach will encounter.

Spike

Before you start writing features you need to design the schema for your data. Think about what different things your app needs to store, how they relate to each other, and how you can avoid duplicating information. Record your schema in your README.md using Markdown tables. Consider embedding a to help visualise the relationships.

Questions to consider

1. What kinds of data relationships are there?

2. What’s a foreign key? How can they help us design schemas with relational data?

User stories

As a shopper, I want to:

• See a homepage with content when I log in

• Be able to navigate between different pages of the app

• View a list of products when I visit the products page

Stretch user stories

• View and edit items in my shopping cart

• Complete the checkout process to "purchase" products in my cart

• See confirmation when an order is placed successfully

Repository naming convention

Please name your repo following this template: PRO04_Name1_Name2_Name3_Name4

Acceptance criteria

• Store product data in a database

• Follow React principles and best practices

• Alow users to search/filter products

• Allow users to add products to a cart

Stretch

• Track item stock and remove items that sell out