Page 290 - Computer - 10(A&B)

• Do not use flammable material near electrical panels, switches, lift trucks or any electrical equipment.
• Make sure all equipment is properly grounded where needed.

• Fire extinguishers must be inspected regularly.
• Report to your supervisor of any defect in electrical, fire prevention or material handling equipment.

• No flammable material are to be placed around an exit door way. (Any 4 points)

Q. 21 Your cousin runs a small bookstore and wants to maintain an inventory of books. He needs to record
information such as book titles, authors, ISBNs, publication dates, prices, and stock levels. However, he is
not familiar with database management systems. Explain the following concepts to help him understand
DBMS:

a. What is DBMS?
b. What are the advantages of using DBMS?

c. Name any two database programs that can be used to create a table and store the data according to
his requirements.

d. Which field can be set as a Primary Key?
Ans: a. A Database Management System (DBMS) is software that helps users create, manage, and manipulate
databases. It allows for efficient data storage, retrieval, and organization.

b. Advantages of using DBMS:

• Data Integrity: Ensures accuracy and consistency of data.
• Data Security: Provides access controls to protect sensitive information.

• Reduced Data Redundancy: Minimizes duplication of data across the database.
• Data Management: Simplifies data handling through structured query language (SQL).

c. Two database programs:
• MySQL

• Open Office Base

d. The ISBN (International Standard Book Number) can be set as a primary key, as it uniquely identifies
each book in the inventory.

172