2025 - Week 2 Exercises

[antonioalmeida]

Week 2 - Exercises

Please leave a comment below with your answers to Week 2's exercises.

How to share

Leave a comment below with the answers to all exercises.

For Exercises 1, 2

Upload your diagram as an image.

For Exercise 3 - Formula 1

1. Create a Gist here
2. Name it formula1.sql. Make sure it's public
3. Share the link to your Gist

For Exercise 4 - LinkedIn

Same as exercise 3, but name your file linkedin.sql

Remember: if you need to make changes, you can edit your Gist.

[antonioalmeida]

(example submission)

Exercise 1: Company

View solution

Exercise 2: Gardener

View solution

Exercise 3: Formula 1

https://gist.github.com/antonioalmeida/9990eeacfbc67eaea8a073fd918192d0

Exercise 4: LinkedIn

https://gist.github.com/antonioalmeida/23ba5300b973ee75ae60986e24819b3f

[chiller33]

Exercise 1

Exercise 2

Exercise 3

CREATE DATABASE Formula 1;

use Formula 1;

CREATE TABLE Car (carNumber INTEGER UNIQUE, weight INTEGER, maxSpeed INTEGER, PRIMARY KEY(carNumber));

CREATE TABLE Pilot (id INTEGER UNIQUE, name TEXT, birthDate DATE, country TEXT, PRIMARY KEY(id));

[payalrattan]

Exercise 1: Company
https://excalidraw.com/#json=6vRv39fJsFTl-0e7UKEW8,iTpvkmlvn6qYRyUrDbgfig
Exercise 2: Gardener
https://excalidraw.com/#json=w4X-GyJJ8L88hmhuHjPfV,GQ1mhV6gHJE6VJqV1_418w
Exercise 3: Formula 1
https://gist.github.com/payalrattan/9360740fa8dc8688d71d132c13bf1f20
Exercise 4: LinkedIn
https://gist.github.com/payalrattan/5e74d9efabb3a167f64da88f686089e8

[Timo-khan]

Exercise 1. Company ER diagram: https://excalidraw.com/#json=_c_sjWSRe4GDk_VUAqNsz,nrKcBPME2BsPxUQyApCiug
Exercise 2. Gardener ER diagram: https://drive.google.com/file/d/1hFXuLSNEgcyKIf-DLl05vjwx3MMQ5TUx/view?usp=sharing
Exercise 3. Formula 1: https://gist.github.com/Timo-khan/369aa7c478fdfef5df2cfac23526de9a
Exercise 4. LinkedIn: https://gist.github.com/Timo-khan/b9bbe38995c32f656e07f0ba00882832
Note: Sorry for my late submission, my assignment is not fully completed yet, thanks for your understanding.

[AhmedAlkhaldi93]

Exercise 1: Company

Exercise 2: Gardener

Exercise 3: Formula 1
https://gist.github.com/AhmedAlkhaldi93/2cdcaa4715d11fc0d27252d14e9ff2c9

Exercise 4: LinkedIn
https://gist.github.com/AhmedAlkhaldi93/ada1c4ee3dfb0d8742ea24b247f88c79