5. Simple Queries
Simple Queries
I referred to the Microsoft website for reference while creating queries in this video.
Tutorials in the series:
Similar Posts
A-Level Revision Links
ByA Mu
Just a bunch of useful links that you could use while revising for the OCR Computer Science A-Level Online textbook @ https://en.wikibooks.org/wiki/A-level_Computing Specification@ http://www.ocr.org.uk/Images/170844-specification-accredited-a-level-gce-computer-science-h446.pdf Extra Resources @ https://www.cambridgegcsecomputing.org/ http://www.ocrcomputing.org.uk/overview.html https://www.memrise.com/course/1211053/ocr-a-level-computer-science-2/ https://www.youtube.com/playlist?list=PLCiOXwirraUBj7HtVHfNZsnwjyZQj97da http://teach-ict.com/2016/A_Level_Computing/OCR_H446/OCR_H446_home.html https://www.cram.com/flashcards/ocr-computer-science-revision-6714147 https://www.youtube.com/channel/UCsBxhDfwURg-vQASN2ZeHwg https://www.mrfraser.org/ https://www.physicsandmathstutor.com/computer-science-revision/a-level-ocr/ https://isaaccomputerscience.org/topics GigaFlop
3. Creating relationships
ByA Mu
Creating Relationships Relationships in a database are important to reduce redundancy. have a look at the following slides to see why normalisation is important. More to follow on normalisation and the different stages to normalise data. Tutorials in the series:
While Loops
ByA Mu
While Loops are similar to for loops because they repeat segments of code. However in a for loop, you specify how many times a segment of code should repeat. With a while loop, you need to set the condition to make the code stop repeating the specified segment. Setting the condition is similar to that more »
Reading from a text file
ByA Mu
Reading Text from a File Everything we have done so far only adds text to a text file and closes the file. Nothing is displayed (printed) on our screens. Now we want to take information from a text file and display it on our screens. Notice how the code below on line 1 when opening more »