Database Concepts - Revision Worksheet
Section A: 1-Mark Questions (Concept Checks)
1. What does DBMS stand for?
2. Define a file in the context of data storage.
3. What is data redundancy?
4. What is a tuple in a relational table?
5. Define metadata.
6. What is a primary key?
7. Which type of key can be a combination of multiple attributes?
8. Mention one open-source DBMS.
9. What is the full form of SQL?
10. What do we call a special value used when data is unknown?
Section B: 2-Mark Questions (Short Answer)
11. List two major limitations of the file-based data system.
12. What is a composite primary key? Give an example from the chapter.
13. Define degree and cardinality with examples.
14. Differentiate between candidate key and alternate key.
15. Why is GPhone not suitable as a primary key, even if it's unique?
16. What is the difference between a query and an update operation in DBMS?
17. Why is data inconsistency more likely in a file system?
Section C: 3-Mark Questions (Application and Analysis)
18. Explain how a relational database avoids redundancy using the school example.
19. Define schema, instance, and constraint. Use examples.
20. How does a foreign key maintain referential integrity? Illustrate using STUDENT and GUARDIAN tables.
21. In the ATTENDANCE table, why can't RollNumber alone be used as a primary key?
22. Suppose two students have the same guardian. How does DBMS avoid repeating guardian info?
23. Identify the keys used in the following schema and classify them:
- Table: EMPLOYEE(AadharNumber, EmployeeID, Name, Address)
- Table: DEPENDENT(EmployeeID, DependentName)
Section D: HOTS (High Order Thinking Skills)
24. A student is transferred to another school. What all changes must be made in the STUDENTATTENDANCE
database?
Database Concepts - Revision Worksheet
25. If a guardian changes their phone number, explain how that change is propagated in the DBMS and not in a file
system.
26. Suppose the school adds a new table for health records. What foreign keys would you consider adding?
27. Why is it dangerous to allow NULL values in foreign key columns without control?
28. Can a primary key ever be NULL or duplicated? Justify.
29. Compare relational data model with file system on basis of structure, access, and security.
Practice-Based Questions (Exam Pattern)
30. Given:
- STUDENT(RollNumber, Name, GUID)
- GUARDIAN(GUID, Name, Phone)
- ATTENDANCE(Date, RollNumber, Status)
Identify:
- Primary Keys
- Foreign Keys
- Composite Key (if any)
31. Design a relation to store items in a school canteen with the following:
- ItemCode, ItemName, Price, Calories
- Mention which field should be primary key and any necessary constraints.
32. A database has two states of a table:
- Table A: Columns in order: RollNumber, Name
- Table B: Columns in order: Name, RollNumber
Are these two states equivalent in a relational DBMS? Why?
