A
Multiple Choice Questions
1. Which of the following can be considered as an example of a database?
- (a) Dictionary
- (b) Telephone directory
- (c) Marks Register
- (d) Newspaper
Answer: (b) Telephone directory
2. Which of the following is NOT a DBMS?
- (a) MS Access
- (b) Open Office Base
- (c) MS Excel
- (d) MySQL
Answer: (c) MS Excel
3. DBMS stands for __________.
- (a) Data and Books Management System
- (b) Database Management System
- (c) Duplicate Books Management System
- (d) Data Management Multi System
Answer: (b) Database Management System
4. Which of the following data models sets a relation between two or more tables?
- (a) Relational Data Model
- (b) Network Data Model
- (c) Hierarchical Data Model
- (d) Connection Data Model
Answer: (a) Relational Data Model
5. The details associated with an entity are called ____________.
- (a) Table
- (b) Attributes
- (c) Records
- (d) Primary key
Answer: (b) Attributes
6. A __________ is represented as rows in a table.
- (a) field
- (b) attribute
- (c) record
- (d) candidate key
Answer: (c) record
7. In which of the following forms can a data value be represented?
- (a) Numeric
- (b) Character
- (c) Alphanumeric
- (d) All of the above
Answer: (d) All of the above
8. Which of the following uniquely identifies a row in a table?
- (a) Primary key
- (b) Alternate key
- (c) Foreign key
- (d) Candidate key
Answer: (a) Primary key
9. A ___________ is a feature of a database using which we can enter data in a table in an easy and user friendly manner.
- (a) query
- (b) report
- (c) form
- (d) field
Answer: (c) form
10. A _____________ is a question asked from a database.
- (a) query
- (b) report
- (c) form
- (d) field
Answer: (a) query
B
State whether the following statements are True or False
1. A database cannot be organised.
Answer: False — organised storage is one of a database's key features.
2. Data is the collection of raw facts.
Answer: True
3. A table can be created without a primary key.
Answer: False — every table needs a primary key to uniquely identify its rows.
4. Two tables can be related in a network data model.
Answer: False — it is the relational model, not the network model, that sets relations between two or more tables.
5. MS Access is an example of a database.
Answer: False — MS Access is a DBMS (software used to create/manage a database), not a database itself.
D
Answer the following questions
1. Define the terms: (a) Database (b) Data redundancy (c) Report
(a) Database: A collection of logically related data items stored in an organised manner, which can be added to, modified, deleted, or displayed as per the user's requirement.
(b) Data redundancy: The situation where the same data field is repeated across multiple tables in a database, i.e., unnecessary duplication of data.
(c) Report: An object of a database used to present the output of a query in a formal, well laid-out format, rather than as plain rows and columns.
2. Give one point of difference between: (a) Data and Information (b) Form and Query (c) Network and hierarchical data model
(a) Data and Information: Data is raw, unprocessed facts (e.g., marks and roll numbers), while information is the processed and organised form of data (e.g., a report card).
(b) Form and Query: A form is used to enter data into a table through a user-friendly interface, while a query is used to retrieve specific information from the database.
(c) Network and hierarchical data model: In the hierarchical model, data is organised into a tree-like structure of linked records; in the network model, multiple records can link to the same master file (like an inverted tree), allowing more flexible relationships than a strict hierarchy.
3. Give any four advantages of a DBMS.
Answer:
- Increases efficiency — organised tables make saving, reading, and searching data faster.
- Increases accuracy — minimised redundancy and inconsistency mean data retrieved is accurate.
- Increases validity — field properties/restrictions set during table design ensure only valid data is entered.
- Security — unauthorised access is controlled through passwords and encryption.
4. Consider the Library table given below and answer the questions that follow.
| Book_Id | Book Name | Author Name | Price | Publisher |
|---|
| F001 | Pride and Prejudice | Jane Austen | 550 | ABC |
| S004 | Amazing Astronomy | E. Shane | 1050 | ABC |
| C005 | IT and Mankind | MHA Diwaan | 2500 | HYM |
(a) Name the fields in the given table.
Book_Id, Book Name, Author Name, Price, Publisher
(b) Which field should be made the primary key?
Book_Id, since it uniquely identifies each record and no two books share the same ID.
(c) Is there any alternate key in the table?
Yes — Book Name can serve as an alternate key, since it is also unique in this table but was not chosen as the primary key.
(d) How is primary key different from foreign key? Explain with example.
A primary key uniquely identifies each record within its own table, whereas a foreign key is a field in one table that refers to the primary key of another table, used to build a relationship between the two. For example, in the Student Registration Table, "Enrolment Number" is the primary key; in the Student Marks Table, "Roll Number" is the primary key, but "Enrolment Number" also appears there as a foreign key linking the two tables.