Database Design - Introduction

~~~~~~~~~~~~~~~ CONNECT ~~~~~~~~~~~~~~~

~~~~~~~~~~~~~~ SUPPORT ME ~~~~~~~~~~~~~~

🅑 Bitcoin - 3HnF1SWTzo1dCU7RwFLhgk7SYiVfV37Pbq
🅔 Eth - 0x350139af84b60d075a3a0379716040b63f6D3853

[pauluwukhor]

I had a difficult time explaining this to my students. i think i have a better understanding now after watching this video. Please do not relax. Thumps up!

[sandstormfx]

I don't know. He's between 3 and 40.

[haggisreflux]

My database instructor linked one of your videos and now I'm hooked. Thanks for the great info!

[konstantinrebrov]

One year ago I took a Databases class at my university. This video series was very helpful for me as an additional resource for studying. Thank you very much.

[Marz]

Just wanted to let you know, I and I am sure many others greatly appreciate your providing these lessons! You've got talent not only with these systems, but also with providing compelling lessons. I hope to see you continue to produce these excellent vids. Best of luck, and thanks again!

[prathamkesarkar]

Seriously more interesting than my college lecture's thanks making an awesome series

[krystalo]

This is a hidden gem for my university course, please be my professor

[ShakirAli-wbho]

you are really Caleb Curry sir awesome way of understanding

[camrouxbg]

I love the low-fi aesthetic of this. Chalk board propped up by books. Occasional rambling but not in a bad way. And I get to learn as well. :)

[lekeKar]

I just freaking love watching your tutorials, Great job mehn! Thanks for teaching Database design without putting me to sleep!

[zsohbsi]

I watched it for two days and can fulfill my knowledge very much, Awesome! Thanks Caleb.

[stopthephilosophicalzombie]

Dude you're awesome. I can tell you are genuinely passionate about this. I look forward to checking this out.

[irenesmarty]

Hi thanks for the video...like the way you explain each step. How do you create a subform with a main form that has many to many relationship?

For example:

Main Form
(Exam Plan - Table 1)
ExamPlanID - Text (Primary Key)
Posting start date
Posting end date

Subform
(Requisitions - Table 2)
RequisitionNum - Number (Primary Key)
Department
Position Name
HR Analyst
HR Assistant

Subform
(Positions - Table 3)
PositionNum - Number (Primary Key)
Vacancy Date

An Exam Plan can have many Requisitions (request to fill a vacancy) (from many departments)

A Requisition can be on many Exam Plans (multiple recruitments if the vacancy was not filled)

A Position # (each position # represents a vacancy) can be listed on many Requisitions (past and future recruitments) and a Requisition can have many Position #'s

I did a join table for:
- ExamPlanID / RequisitionNum
- RequisitionNum / PositionNum

I'm at the point of establishing the relationships but stuck here do not know how to create a form that contains all three tables on one form. To open a exam plan form where you can see all requisitions associated with the exam plan and the positions associated with the requisition attached to the exam plan...do you have a video that would help with this or advice on how to do it?

[shetkarabhijeete]

Just starting with database design! I hope your videos will guide me through! Starting with Introduction!

[Kearney]

Your the first person I've subscribed to, ever. Brilliant!

[dantealemanbaza]

Thank you for the course, I'm currently enrolled in a CS major and I am struggling with my Database class, I don't know why but I hope that this course will help me to understand the topics better.

[cognomen]

You're the man.

Thank you, Caleb.

[LPShreyDoshiHD]

This series is awesome. I just watched 3 videos till now and one complain I have about the videos is that there are ads in the beginning and sometimes in the middle of the videos. This really breaks the flow and concentration when watching the videos one by one. If you can just turn them off by some way? I know maybe you'd be earning from them but they are really distracting.
Thank for the teaching. I can understand RDBMS very well. Great videos :D

[sarahhakimi]

I am working on my first database design assignment, i hop it works for me

[pitnestle]

I really watched the Video just because i was bored and i didn't knew what else to do( I already know all this stuff...), but you're really good at explaining and talking so i watched one video after video...