Development of an online store database

1,262 views

Научиться учиться

Published on May 1, 2024
About :

Recording of the webinar of the federal program "Code of the Future" (MIPT) for schoolchildren and students. 00:00 Introduction 04:34 Drawing a diagram in draw.io 07:33 Designing categories and products 10:35 Primary and foreign keys 14:30 Creating tables for categories and products 29:20 Designing customers and orders 35:54 Creating tables for customers and orders 43:25 "Many-to-many" relationship, designing positions in an order 52:56 Filling the database 57:10 Example queries 59:00 About the blog "Learn to learn" 01:02:20 Example queries 01:07:00 Summing up 01:10:49 Answers to questions Alexander Viktorovich will show you which tables are needed to store information about products, orders and customers, and how to properly link them together. You will learn how to create an online store database using postgreSQL, fill it with products, and what technologies to use to create a visual interface for it. Topics covered: Database design Martin notation One-to-one, one-to-many, many-to-many relationships Basic SQL queries #databasedesign #databases #postgreSQL #SQL #onetomany #manytomany ????SUPPORT THE PROJECT: https://www.donationalerts.com/r/lear...

  • vidoe Comments
Trend Videos
21:37
Black and White Chef Choi Hyun-seok's Garlic Dish! Jun-hyeon, you just eat♥ EP08. Clam Sujebi, Mara Cream Shrimp
낭만돼지 김준현
236,419 views   2 days ago
15:42
🇯🇵 Japanese Real Estate 1963 Tokyo Apartment 130 Million Won My Own Money Room Tour 🔨 Interior 35 Million Won End
정세월드
195,251 views   1 day ago
3:37
[Musical Star] Kim Kwang-yeon - If You Can't Take Your Steps Werther (4K)
빵송국
482,561 views   7 days ago
8:45
💍 We're getting married..! With 5 years of memories ❤️
담다미담
1,181,380 views   3 days ago
14:31
Cherry asked me to send her to a Korean kindergarten… Why is she suddenly doing that?
올리버쌤
468,034 views   1 day ago
37:54
[SUB] Excuse me, but would you please hand me your passport? [I don't have anything] EP.32 #Lee Young-ji #Kentaro
차린건 쥐뿔도 없지만
5,934,065 views   8 days ago
21:06
I felt bad about letting it go like this, so I brought it back.👨‍🍳TOP 8 Highlight Interview👨‍🍳 Black and White Chef: Culinary Class Wars Netflix
Netflix Korea 넷플릭스 코리아
2,390,350 views   8 days ago
29:35
[Highlights of Episodes 5-6] Choi Moo-sung's furious blast at Kim Hye-eun, who still blames Hwang In-yeop for her daughter's death Prefabricated Family Broadcast on JTBC 241023
JTBC Drama
433,535 views   3 days ago
15:22
What do Kia Tigers players eat every day? (feat. Kim Do-young😻) Exploratory Life EP.07
현대백화점그룹 STORY
181,472 views   3 days ago
10:21
Have you ever been to a funeral?
숏박스
3,997,471 views   8 days ago
11:06
gossiping friend
짧은대본 ShortPaper
593,507 views   7 days ago
58:52
The Return of Lethal Company
이도원
524,004 views   4 days ago
3:45
Do you want to go out with me?
웃기시네
591,157 views   3 days ago
21:13
Master Jang Young-ran, Actress Lee Seung-yeon, Yeonhui-dong Housewarming (Entertainment Behind the Scenes)
A급 장영란
573,708 views   3 days ago
3:11
aespa 'Whiplash' MV
SMTOWN
43,129,872 views   5 days ago
2:31
JENNIE - Mantra Show! MusicCore MBC241019 Broadcast
MBCkpop
2,922,300 views   7 days ago
11:44
[I'm SOLO LIVE] 22nd season final couple!! Is it currently in progress??
촌장엔터테인먼트TV
664,470 views   2 days ago
15:42
🇯🇵 Japanese Real Estate 1963 Tokyo Apartment 130 Million Won My Own Money Room Tour 🔨 Interior 35 Million Won End
정세월드
195,251 views   1 day ago
11:06
gossiping friend
짧은대본 ShortPaper
593,507 views   7 days ago
24:56
[What do you do when you play] My younger siblings' love that's hard to watch with your eyes open MBC241020 broadcast
픽잇 :Pick it
1,017,060 views   4 days ago
21:13
Master Jang Young-ran, Actress Lee Seung-yeon, Yeonhui-dong Housewarming (Entertainment Behind the Scenes)
A급 장영란
573,708 views   3 days ago
8:45
💍 We're getting married..! With 5 years of memories ❤️
담다미담
1,181,380 views   3 days ago
20:48
I gave a 4 million won coffee to Itseop who asked me to come back because the taste of the coffee had changed. [Home Cafe Tour]
안스타
134,115 views   4 days ago
22:59
Kim Won-hee (Entertainment industry appearance fee) who has been scorched by the best middle-aged woman's eloquence
밉지않은 관종언니
407,569 views   2 days ago
24:57
2 hours on the plane VS 17 hours lying down ⎪🇮🇩Indonesia 2
원지의하루
610,495 views   4 days ago
14:31
Cherry asked me to send her to a Korean kindergarten… Why is she suddenly doing that?
올리버쌤
468,034 views   1 day ago
10:21
Have you ever been to a funeral?
숏박스
3,997,471 views   8 days ago
2:26
[TAKE#B 4K] KISS OF LIFE - Igloo
GENIE MUSIC
1,698,879 views   5 days ago
42:17
[SUB] We've invited the Nobel Dopamine Prize candidates👩‍🎓 [I didn't prepare anything] EP.31 #LeeYoungJi #HaeWon
차린건 쥐뿔도 없지만
5,510,110 views   2 weeks ago
3:35
ILLIT (아이일릿) 'Cherish (My Love)' Official MV
HYBE LABELS
18,227,142 views   5 days ago
9:37
Taste Defense Command Mobile Strike Force
너덜트
1,046,305 views   8 days ago
24:57
2 hours on the plane VS 17 hours lying down ⎪🇮🇩Indonesia 2
원지의하루
610,495 views   4 days ago
Google AdSense
336 x 280
Up Next
9:31
I have a habit of losing my memories when I make someone laugh. I have a habit of losing my memories when I make someone laugh. When I make someone laugh... ㅣ Make Imda laugh!
임다TV
641,335 views
2 years ago
10:33
Make Imda laugh! I ended up laughing ㅋㅋㅋㅋㅋㅋㅋㅋㅋㅋ(Thomas the Tank Engine Legend) ★Imda★
임다TV
1,207,446 views
4 years ago
10:37
[Highlight] Three-line Poetry Contest! (Ronaldo is so funny hahahahahahahaha) ★Imda★
임다TV
1,562,705 views
5 years ago
11:04
[Highlight] The true legend of the dialect competition (the confrontation between the South and the North) You'll regret it if you don't watch it ㅋㅋㅋㅋㅋㅋㅋㅋ ★Imda★
임다TV
1,227,461 views
4 years ago
8:35
Make Imda laugh!! (Collection of legends)
임다TV
676,197 views
2 years ago
10:38
[Highlight] Voice Impression Contest! (Ki-cheol did it all ㅋㅋㅋㅋㅋㅋㅋㅋ) ★Imda★
임다TV
8,741,146 views
5 years ago
11:15
[Highlight] Dialect Contest! (Gyeongsang-do dialect is so sweet~) ★Imda★
임다TV
3,850,944 views
5 years ago
11:09
[Highlight] Three-line Poetry Contest! (Bongji ㅋㅋㅋㅋㅋㅋㅋㅋ) ★Imda★
임다TV
4,343,840 views
5 years ago
46:02
[Full video] Your face battle kkkkkkkkkkkkkkk
임다TV
233,272 views
2 years ago
9:10
(Legend Collection) Make people laugh by giving them Imda ㅋㅋㅋㅋㅋ
임다TV
1,100,751 views
2 years ago
10:05
Make Imda laugh ㅣ All-time legend ㅋㅋㅋㅋㅣ So funny ㅋㅋㅋㅋ
임다TV
419,379 views
3 years ago
10:17
The gold button, a symbol of a 1 million YouTuber!! Steal 6 of them!! Haha Hello, I'm Double B, a 6 million YouTuber^^ Hahaha
더블비
3,668,173 views
4 years ago
56:31
I lost 600,000 won as soon as I started because of the Chulgu BGM magician.. 300,000 won if you laugh! Make Chulgu laugh (17.06.15-3) :: ChulGu
철구형 (CHULTUBE)
5,915,526 views
7 years ago
54:03
This is a fun movie that I watched when I was 3 and still watch until I'm 80.
인생영화: Legend Movie
1,654,086 views
1 month ago
19:12
A collection of the top 50 funny YouTube comments that every Korean would have seen
유튜브레전드
4,026,443 views
3 years ago
19:00
If you get caught, you'll end up as an ingredient in Mala Tang...?!? Escape from Mala Tangㅋㅋㅋㅋ
웃소 Wootso
936,108 views
4 months ago
10:16
Real situation! The viewers really fought during the broadcast. ★Imda★
임다TV
3,484,023 views
4 years ago
10:10
Make me laugh with your nickname (IT A CAR is so funny lol)
임다TV
154,688 views
1 year ago
1:22:49
[Full video] Make Imda laugh, 1 million won prize money!! (Pengsoo, squid game, laughter legend)
임다TV
317,533 views
3 years ago
2:18:01
Iron Man is Back in Fortnite!
W1ndz
31,242 views
Streamed 1 month ago
12:11
I Played Fortnite On The World's Smallest Keyboard!
W1ndz
24,137 views
1 day ago
13:56
All Challenge GLOVES in Fortnite!
W1ndz
51,259 views
4 weeks ago
18:14
Can He Guess The Youtuber With 1 Question?
W1ndz
73,577 views
2 weeks ago
18:42
How % Smart are you?
W1ndz
88,424 views
3 weeks ago
12:03
BOT VS DOOM Challenge In Fortnite!
AlekosKal
5,397 views
1 month ago
42:18
MINECRAFT HAS LOST ITS COLORS!
McpcmStavros
34,963 views
10 hours ago
20:30
Minecraft BUT I GET WHAT I BUILD!
Puck Games
397,458 views
10 months ago
31:53
I beat All Countries in Fortnite as DrDoom!
W1ndz
66,551 views
3 weeks ago
19:28
THE POLICE GAVE US AN IMPORTANT INFORMATION! GTA San Andreas #8
W1ndz
11,475 views
1 month ago
37:11
€1 vs €1,000,000 CARS in MINECRAFT?!
Siaman
55,533 views
1 day ago
30:09
1 Win = Change House Challenge in Fortnite!
W1ndz
129,410 views
3 weeks ago
17:27
THE WAR WITH THE BALLAS STARTS HERE! GTA San Andreas #7
W1ndz
16,720 views
1 month ago
1:16:42
I SURVIVED PARKOUR CULTURE, IN MINECRAFT!
Ninja2die
61,274 views
3 days ago
25:00
Played ALL Neal.fun Games in 25 minutes...
W1ndz
38,569 views
5 days ago
20:16
I played Puck's Greek Horror Game!
W1ndz
28,484 views
2 weeks ago
11:33
1 Kill = Adding a Challenge Button to Fortnite!
W1ndz
38,439 views
2 weeks ago
13:02
Can you solve the IMPOSSIBLE QUIZ?
W1ndz
45,171 views
12 days ago
14:37
I WENT BEHIND ROOK ZUK'S CAMERAS BUT...
DimitrisKyrsanidisVLOGS
53,869 views
6 days ago
Google AdSense
336 x 280

fetery.com. Copyright 2024