Relational Database Quiz for High School Students

🧠 Quick Study Guide: Relational Databases

• 📊 What is a Relational Database? It's a type of database that stores and provides access to data points that are related to one another. Data is organized into tables (relations).
• 🗄️ Tables (Relations): These are the fundamental building blocks. Each table represents a specific entity (e.g., 'Students', 'Courses', 'Teachers').
• ➡️ Rows (Records/Tuples): Each row in a table represents a single, complete entry or record for the entity. For example, one student's full information.
• ⬇️ Columns (Attributes/Fields): These define the characteristics or properties of the entity. Each column has a specific data type (e.g., 'Student_ID', 'Name', 'Grade').
• 🔑 Primary Key: A column (or set of columns) that uniquely identifies each row in a table. It cannot contain NULL values and must be unique for every record. Think of it like a student ID number.
• 🔗 Foreign Key: A column (or set of columns) in one table that refers to the primary key in another table. It establishes a link or relationship between two tables. This allows tables to be connected without duplicating all data.
• 🤝 Relationships: How tables are connected using primary and foreign keys. Common types include One-to-One, One-to-Many, and Many-to-Many.
• 🔍 SQL (Structured Query Language): The standard language used to communicate with and manage relational databases. It's used for tasks like creating tables, inserting data, querying data, and updating data.

📝 Practice Quiz: Relational Databases

1. Which of the following best describes a 'row' in a relational database table?

1. A specific category or attribute of the data.
2. A unique identifier for the table.
3. A single, complete record for an entity.
4. The entire collection of data in the database.

2. What is the primary purpose of a 'Primary Key' in a relational database?

1. To link two tables together.
2. To ensure that each record in a table is uniquely identified.
3. To store large blocks of text data.
4. To define the data type for a column.

3. A 'Foreign Key' is used to:

1. Create new tables in the database.
2. Delete data from a table.
3. Establish a link between two tables.
4. Sort data in ascending or descending order.

4. Which term refers to the structure that organizes data into rows and columns in a relational database?

1. Index
2. Query
3. Table
4. Report

5. What does SQL stand for?

1. Simple Query Logic
2. Structured Question Language
3. Standard Query Link
4. Structured Query Language

6. If a table named 'Students' has a 'StudentID' column that uniquely identifies each student, what type of key is 'StudentID'?

1. Foreign Key
2. Candidate Key
3. Primary Key
4. Secondary Key

7. A 'column' in a relational database table is also commonly referred to as a(n):

1. Record
2. Tuple
3. Attribute
4. Relation