Database Components

Question 1

Give a simple example of a schema

Answer 1

The “Student” schema might include tables for student records, course enrollments, & grades.

Question 1

What is a schema in a database?

Answer 1

Defines the structure of a database, including the tables, fields, & relationships between them.

Question 2

What are the components of a relational database?

Answer 2

1. Tables
2. Rows
3. Columns
4. Primary Key
5. Foreign key

Question 3

What does TABLES represent in a relational database?

Answer 3

Store data in rows and columns

Question 4

What does ROWS represent in a relational database?

Answer 4

Each row contains a record of data

Question 5

What does COLUMNS represent in a relational database?

Answer 5

Each column represents a field, like a name or ID.

Question 6

What does PRIMARY KEY represents in a relational database?

Answer 6

A unique identifier for each row in a table

Question 7

What does FOREIGN KEY represent in a relational database?

Answer 7

A field in one table that links to the primary key of another table.

Question 8

How is data organized in a relational database?

Answer 8

• Data is organized into tables, with each table containing rows (records) & columns (fileds).
• Tables can be linked using keys, like primary keys & foreign keys.

Question 9

What is data independence?

Answer 9

Refers to the ability to change the structure of a database without affecting the data or the applications that use the data.
- It ensures flexibility & scalability in managing databases.

Question 10

What is a schema in a database? (In More Detail)
- Define:
- Example:

Answer 10

1. Define: defines the structure of a database, including the tables, fields, and relationships between them.
2. Example: The “Student” schema might include tables for student records, course enrollments, and grades.

Question 11

What are the components of a relational database? (In More Detail)

• List each different component & Define what they represent:

Answer 11

1. Tables: Store data in rows and columns.
2. Rows: Each row contains a record of data
3. Columns: Each column represents a field, like a name or ID.
4. Primary Key: A unique identifier for each row in a table.
5. Foreign Key: A field in one table that links to the primary key of another table.