CBSE 10th class Unit 3: Chapter 1 INTRODUCTION TO DATABASE MANAGEMENT SYSTEM

 

 Unit 3: 

Chapter 1

INTRODUCTION TO DATABASE MANAGEMENT SYSTEM

A. Multiple Choice Questions

1.      (c) Marks Register

2.      (c) MS Excel

3.      (b) Database Management System

4.      (a) Relational Data Model

5.      (b) Attributes

A. Multiple Choice Questions

6. (c) record
7. (d) All of the above
8. (a) Primary key
9. (c) form
10. (a) query

B. State whether the following statements are True or False

1. False
2. True
3. False
4. False
5. True

C. Fill in the blanks

1. The raw facts constitutes data.
2. An entity is a real world object about which information is to be stored in a database.
3. The output of a query may be displayed in the form of a report.
4. The data values for all the fields related to a person or object is called a record.
5. All the field values that are eligible to be the primary key are the candidate keys for that table.

D. Answer the following questions

1. Define the terms
• (a) Database: A collection of related data that can be accessed, managed, and updated.
• (b) Data Redundancy: The duplication of data in multiple places within a database.
• (c) Report: A formatted presentation of data extracted from a database.
2. Give one point of difference between
• (a) Data and Information: Data is raw, unprocessed facts, while information is data that has been processed and organized to convey meaning.
• (b) Form and Query: A form is used to input data into a database, while a query is used to retrieve data from a database.
• (c) Network and Hierarchical data model: In a network model, a record can have multiple parent records, while in a hierarchical model, a record can have only one parent record.
3. Give any four advantages of a DBMS.
• Data integrity: Ensures data accuracy and consistency.
• Data security: Protects data from unauthorized access.
• Data sharing: Allows multiple users to access and share data.
• Data independence: Isolates data from applications.
4. Consider the table given below and answer the questions that follow
• (a) Fields: Book_Id, Book Name, Author Name, Price, Publisher
• (b) Book_Id should be the primary key. It uniquely identifies each record.
• (c) There is no alternate key in the table.
• (d) A primary key uniquely identifies a record in a table. A foreign key is a field in one table that references the primary key of another table. For example, if we had a "Borrower" table with a "Book_Id" field, this "Book_Id" would be a foreign key referencing the "Book_Id" primary key in the "Library" table.