E-Commerce database schema visualising and querying

[illicitonion]

Link to the coursework

https://github.com/CodeYourFuture/Module-SQL/tree/main/E-Commerce

Why are we doing this?

This project is about really understanding your database by representing it in a diagram. How do the tables relate to each other? How do references work? What is the primary key? What is a foreign key? Drawing a simple schema will clear this all up.

Remember, simple is better. Use a pencil and paper.

You should both draw the schema and write the queries.

Maximum time in hours

6

How to submit

1. Fork to your Github account.
2. Make a branch named after the project.
3. Make regular small commits with clear messages.
4. When you are ready, open a PR to the CYF repo, following the instructions in the PR template.
5. Make sure to include your schema visualisation (either as a digital format, or as a photograph), as well as the queries.