Class 22 - Week 2 Exercises

HackYourFutureBelgium / sql-database

Databases module of HackYourFuture Belgium's Sunday classes, 2024 edition

https://hackyourfuturebelgium.github.io/sql-database/

9 stars 17 forks source link

Class 22 - Week 2 Exercises #27

Open antonioalmeida opened 5 months ago

antonioalmeida commented 5 months ago

Week 2 - Exercises

Please leave a comment below with a link to 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

Create a Gist here
Name it formula1.sql. Make sure it's public
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 commented 5 months ago

(example submission)

Exercise 1: Company

View solution

![image](https://github.com/HackYourFutureBelgium/sql-database/assets/4543448/2efd7e6a-e561-442c-a998-11caeea2d143)

Exercise 2: Gardener

View solution

![image](https://github.com/HackYourFutureBelgium/sql-database/assets/4543448/2efd7e6a-e561-442c-a998-11caeea2d143)

Exercise 3: Formula 1

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

Exercise 4: LinkedIn

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

amirabayoumi commented 5 months ago

Exercise 1: Company

View solution

![image](https://github.com/HackYourFutureBelgium/sql-database/assets/149677044/4b234f0c-5b22-4f3f-bc1f-4190c07c5b87) ![image](https://github.com/HackYourFutureBelgium/sql-database/assets/149677044/8ce1b82d-3d7b-425a-896b-9abecdef3671)

Exercise 2: Gardener

View solution

![image](https://github.com/HackYourFutureBelgium/sql-database/assets/149677044/e26d56b4-7cbf-44cd-83ec-34c100fa2ade) ![image](https://github.com/HackYourFutureBelgium/sql-database/assets/149677044/7baada10-756e-448d-95cc-764a891bda37)

edinssa commented 5 months ago

Exercise 1: company ER

Company ER

Exercise 2: Gardner ER Gardener ER

Exercise 3: Formula 1 https://gist.github.com/edinssa/34c7fa48924ddd7120707f0bfbd9c9ff

Exercise 4: LinkedIn https://gist.github.com/edinssa/729b65bcde2eaeec656a683759b68e28

Lishan6 commented 5 months ago

Exercise 1: Company COmpany.drawio.pdf

Exercise 2: Gardener

Exercise 2_ Gardener.drawio.pdf

Exercise 3: Formula1

Exercise 4: LinkedIn https://gist.github.com/Lishan6/6d094cb9aa19fb230db3f7b9f365298b

hitomipupil commented 5 months ago

Exercise 1: Company

View Solution

![Week 2 : Excercise 1 : Company(excalidraw)](https://github.com/HackYourFutureBelgium/sql-database/assets/26542813/11c04943-a820-4362-ab8e-0d4c22a83e1b) ![Week 2 : Exercise 1: Company](https://github.com/HackYourFutureBelgium/sql-database/assets/26542813/99e9895b-4d9a-40c1-bef1-f0a0e65c3e81)

Exercise 2: Gardener

View Solution

![Week 2 : Excercise 2 : Gardener(excalidraw)](https://github.com/HackYourFutureBelgium/sql-database/assets/26542813/a0589dd5-3aea-4c32-9ec0-a2a5e16c3938) ![Week 2 : Excercise 2 : Gardener](https://github.com/HackYourFutureBelgium/sql-database/assets/26542813/edd9ebb6-be5b-48d1-b269-ae1b4cb5111b)

Exercise 3: Formula1

View Solution

https://gist.github.com/hitomipupil/904537529d68bbed06fad342db7c71ef

Exercise 4: LinkedIn

View Solution

https://gist.github.com/hitomipupil/772c2d0ef205a9b47f8a0e545cb163d0