Saturday, 17 November 2018

CBSE Class 10 - FIT - Chapter 3: Office Tools - Database Concepts (Q & A) (#cbsenotes)(#eduvictors)

Database Concepts 

Class 10 - FIT - Chapter 3: Office Tools

CBSE Class 10 - FIT - Chapter 3: Office Tools - Database Concepts  (Q & A) (#cbsenotes)(#eduvictors)

 (Q & A)

Q1: What is database? Give example.

Answer: A database is a collection of related information organised as tables is known as database, e.g. INGRES, MySQL etc.

Q2: What is MS Office suite?

Answer: Microsoft office is a suite of products that aim at making easy integration of data between different applications such as Word Processor, Spreadsheet, Presentation Graphics and Database Manager.

Q3: Define the term DBMS.

Answer: The full form of DBMS is Database Management System. It is a computer based record keeping system. 

Q4: State the primary goal of a DBMS.

Answer: To provide a convenient and efficient environment in which we can store and retrieve information.

Q5: What is MS Access?

Answer: Microsoft Access is a Relational Database Management System (RDBMS) that you can use to store and manipulate a large amount of information.

Q6: What is a relational database? Define RDMBS?

Answer: A Relational Database is a database, which consists of tables of related information that are linked together based on a key field. In RDBMS, the data is organized in the form of tables (i.e., rows and columns). These tables are called relations. Each row in a table represents a relationship among a set of values.

Q7: Write any two uses of a database management system.

1. DBMS is used to store data at a centralised location.
2. It is used to minimise data redundancy and data inconsistency.

Q8: What is a field?

Answer: A field is a category of information. It contains a set of characters, which have a proper meaning.

Q9: Write any two advantages of using database or DBMS.

1. Can ensure data security.
2. Reduces the data redundancy.

Q10: What is a record?

Answer: A record is a collection of data items, which represents a complete unit of information.

Q11: Define the primary key with an example.

Answer: A field which uniquely identifies each record in a table is known as the primary key. e.g. studentId is the primary key of the Student table.

Q12: Give one advantage of using the primary key.

Answer: A primary key uniquely identifies the record in the table.

Q13: Give any two disadvantages of the database systems.

1. High complexity
2. Database failure
3. Administrative and maintenance costs.

Q14: Write the significance of a foreign key.

Answer: A foreign key is used to Establish a relationship between any two tables of RDBMS.

Q15: Fill in the blanks:

(i) MS Office is a product of ________________ .
(ii) MS Access is a relational  ______________.
(iii) Database is a logical __________________ data.
(iv) In RDBMS Data is organized in the form of _______________.
(v) A record is a collection of ____________.

(i) Microsoft
(ii) database management system (RDBMS)
(iii) collection of related
(iv) table
(v) data items

Q16: Distinguish between data and information.

Answer: Data is a collection of raw facts whereas information is a processed data.

Q17: What is the default extension of MS Access database?

Answer: MDB

Q18: What is a composite key?

Answer: It is a primary key in a table and foreign key in another table.

Q19: What is Design View in MS Access?