Level 1: Foundation Builder (Aiming for a PASS / 'C' Grade)

1. Define: In a database, what is a 'Table'? What is a 'Record'?

2. Identify: What is the main purpose of a 'Primary Key'?

3. List: Name the four main objects in a database management system (DBMS).

4. Recall: Which database object is used to ask questions and retrieve specific data from a table?

5. State: Give one major advantage of using an electronic database over a manual (paper-based) one.

6. Identify: Which database object is best for creating a user-friendly screen for data entry?

7. Define: What is 'data redundancy'?

Level 2: Concept Connector (Aiming for a 'B' Grade)

1. Explain: Explain the difference between a Primary Key and a Foreign Key. How do they work together to create a relationship?

2. Describe: Using the example of a school library, describe a 'One-to-Many' relationship between a 'Students' table and a 'Books_Borrowed' table.

3. Compare: What is the difference between a Query and a Report? When would you use each?

4. Explain: Why is 'Student Name' a poor choice for a Primary Key in a student database? What would be a better choice?

5. Justify: Explain why storing all library information (student details, book details, and borrowing details) in one single, massive table is a bad database design.

Level 3: 'A' Grade Challenge (Aiming for an 'A' Grade)

1. Design: You need to design a simple database for a local sports club. The database must store information about members and the sports they play.

• Design two tables: Members and Sports.

• List the fields (columns) you would include in each table.

• Identify the Primary Key for each table.

• How would you link these two tables? Identify the Foreign Key and the type of relationship (e.g., One-to-Many).

1. Problem-Solving: Using your database design from the previous question, write a query in plain English to find "the names of all members who play cricket." Explain which tables the query would need to look at to get this information.

2. Analyze: A bank clerk uses a well-designed Form to enter new customer data. They cannot see the main database table directly. Explain two reasons why this is a good security and data integrity practice. (Hint: Think about data validation and preventing accidental deletions).

Exam Tip for Chapter 9: When asked to design a database, always clearly label your tables, list the fields under each, and underline the Primary Key. Use an arrow to show the link from the Foreign Key in one table to the Primary Key in another. This visual method clearly communicates the database structure.