OCR GCSE Computing: Relational Databases - Topic 16 [OLD COURSE]

Video on relational databases for the OCR course.

[cambasi]

Bruh you don't understand how much these vids have saved my life if it wasnt for these my computing exam would have gone in without lube and left me in a mess

[hasal]

It is very nice to see that you are still making computer science videos for us and not leaving us to rot when it comes to end of year exams.

[helloohelloo]

I really appreciate your videos! ive gone from confidently going to fail to maybe fail

[Tuilaras]

Shout out to the ones who are revising the last minute and of course, GL to everyone tomorrow.

[oliverthespy]

Have this exam tomorrow, this is a massive help. Thanks a million!

[tobias-edwards]

I forgot to say, but because of your videos I managed to get an A* somehow o.O So a really, really, really big THANK YOU! This video series is

[tobias-edwards]

Hi, great video serious - you are saving me because my class didn't learn anything for two years.... (Long story). But, I'm thinking ahead and I will be taking competing at a level. They changed the specs for a level computer science so that the exams are after 2yrs...etc... Anyway, do you think you will be making an a level computing course in the future because this series is good! (I'm doing OCR) btw. TY!

[balkaranmali]

Just catching up on some last minute revision. Thanks for all you've done. You've helped me out a lot

Also what course would you say is harder AQA or OCR?

[joseazevedocorreia]

part of ocr specification needs you to know exact definitions of primary/foreign key
there was a 4 marker asking the difference between primary/foreign but you havent gone in enough detail for me to answer that properly?

[elrond]

sql in this case, SQL= Structured Query Language, not, Standard Query Language, , , hope it helps (not meaning to be picky or anything, great vid!)

[aavashsubedi]

Just a little something but you can consider modules like a 'DLC' to a game - it doesn't come with the game but it provides additional features.

[tdag]

I could see some economics creep up there: scarce "resources allocated successfully" :DD

[yaqub]

can you tell me what is a primary key in another way because I did not understand the way you said it in a video?

[lisaly]

is a key field and a primary key the same thing?

[chisam_]

Just wondering before the exam, why would you separate tables and utilize a foreign key. All the examples you used seemed to work as a flat-file, so I was wondering the reasons for separating data.

[samcadogan]

So a primary key is a unique identifier, but what is the foreign key? is it just the same as the primary key but because it is in another table is it labelled "foreign"?

[draculanova]

Do we need to know about entity relationships? They are in the textbook, but don't seem to be on the spec

[michaellinton]

At 9:53 on the second table is code on both tables the primary key, I'm kinda confused by it, could you please explain

[ironwithin]

So with relational databases you only need one key field to link databases if you have more than one it is data redundant

[Metal_Fingers.]

What is the difference between range check and length check?