Try it on paper first. A hint, the key idea and the worked solution are here when you need them.
A school library keeps its books in a table called Books.
BookID Title Author Pages OnLoan
B101 Ocean Life Grant 212 FALSE
B102 Star Maps Osei 96 TRUE
B103 Clay Craft Lund 148 FALSE
B104 River Towns Osei 305 TRUE
B105 Quick Maths Iqbal 88 FALSE
B106 Wild Birds Grant 176 FALSE
B107 Code Club Mori 130 TRUEA single-table database keeps all its data in one table. A record is one row: all the data about one thing. A field is one column: one item of data about every thing, and its heading is the field name. A table with records and fields holds data items.
Have you tried it?
Work it out on paper first. It is fine to get stuck or make a mistake: that is how we learn. When you are ready, go through the solution one step at a time, and check each step against your own.
Given. The Books table, with a heading row and rows of data.
Step 1. Records. There is one row of data for each book, from B101 to B107. That is records. The heading row is not a record.
Step 2. Fields. There are columns: BookID, Title, Author, Pages and OnLoan. These are the field names.
Step 3. Data items. Each record holds one item in each field, so the table holds data items.
Step 4. The fourth record. B104, River Towns, Osei, and TRUE.
Answer: (a) records. (b) fields. (c) data items. (d) The field names are BookID, Title, Author, Pages and OnLoan; the fourth record is B104, River Towns, Osei, , TRUE.
Log in to join the discussion.
Loading…