What is the main purpose of using a relational database?

Define the terms: Table, Record, and Field.

What are the two essential characteristics of a Primary Key?

Explain the function of a Foreign Key in a relational database.

Give a real-world example of a 'One-to-Many' relationship between two tables.

What is the difference between a Query and a Report in a DBMS?

Which DBMS object is best suited for entering and editing data in a user-friendly way?

You want to find all students from the 'Student' table who live in 'Colombo'. Which DBMS object would you use to retrieve this specific information?

What is a 'Data Type' in a database field? Give two examples.

Why is an 'Admission Number' a better choice for a Primary Key in a student table than a 'Student Name'?

Can you edit data directly in a Report? Why or why not?

What does 'data redundancy' mean, and why should it be avoided?

You have a 'Doctors' table and a 'Patients' table. A doctor can have many patients, but a patient is assigned to only one doctor. Identify the Primary and Foreign keys needed to link these tables.

What is the purpose of a Form in a database?

You have created a query to show student exam results. Now you need to print this information in a well-formatted, professional layout with a title. Which DBMS object should you create?