AdvertisementYour brand could be hereYour brand hereOn every Darslab page · students, parents and teachersinfo@darslab.comAsk for pricesPricesinfo@darslab.com
☰ Year plan · Communication Technology

Tables, fields and keys

Week 5 · Unit 2 Requirements and Production Stages of the Project (2), Create database tables stage (1): database, table, record, field, field types and sizes, flat and relational databases, the primary key · 3 lessons
Answers are for parents and teachers.
1
Look at the members table. Write the number of fields, the number of records, and the value of books_read for Karim.
2
Choose text, integer, decimal or date: (a) a book title, (b) the number of pages, (c) the price in pounds with piastres, (d) the day a book was borrowed.
3
A table of books has the fields title, writer and shelf. Can title be the primary key? Explain, and suggest a better one.
4
A flat table repeats the shelf room for 40 books. The room is renamed. How many rows must be edited? And in a table of shelves with one row per shelf?
5
Why must a primary key never be empty?