CodeYourFuture / CodeYourFuture/Module-SQL

E-Commerce database schema visualising and querying

Open
#5 0 comments 0 reactions 0 assignees View on GitHub
🏕 Priority Mandatory 📅 Sprint 2
Dominant language
PLpgSQL
Stars
0
Forks
3
PR merge metrics
No merged PRs in 30d

Description

### 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.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.