Databases
Records, fields and keys, flat file versus relational, data types and validation, and SQL, the topic where a query must be written, not described.
What this lesson covers
Databases is a 6-part O Level Computer Science lesson. Each part makes one point and then hands over to the next, so it can be read in a sitting or picked up again at the part you stopped on. It defines the idea in plain words before using it, works through an example step by step, breaks the topic into its parts and compares them, names the mistakes that cost marks in an exam, ends with a recap of what to remember.
How it begins
A field is a single item of data (Surname). A record is a complete set of fields about one item or person (all the details of one student). A table is a collection of records with the same structure. A database is one or more tables. A primary key is a field that uniquely identifies each record. StudentID, ISBN, MemberNumber. A surname is unsuitable because two people may share one.
The 6 parts
- The structure, from field to database
- Flat file versus relational
- SQL: the clauses, in order
- Where marks go
- What to remember
- Watch one worked through
Practise Databases
Everything on QuizByt for O Level Computer Science that goes with this lesson: read it first, then test yourself while it is fresh.
🧠 8 quizzes on Databases (5 easy, 2 medium, 1 hard)
Work up from easy to hard: the hard quiz asks the O Level exam-style questions on Databases.
🖨️ Printable worksheet
Databases on paper for O Level, with room to write the working out. Preview the first page free.
🎮 Games for O Level Computer Science
Memory and reasoning games at the right level for O Level. Passing a quiz on Databases earns the credits that open them.
This topic needs a subscription
This lesson is part of a paid plan. Create a free account to start with our free lessons, or subscribe to open every topic.
- 🆓 Free lessons are open on any account
- 📗 Monthly: 5 paid topics a month
- 📘 Yearly: 7 paid topics a month
- ⭐ Premium, every topic, unlimited
- 🧺 Or buy this single topic, the lesson is included