Database Basics for Business: DBMS Concepts, Tables, Queries, Forms and Reports (MS Access Overview) Questions

Question 1

Define database.

Accepted Answer

A database is an organized collection of related data stored for easy access and update.

Question 2

Define DBMS.

Accepted Answer

DBMS is software used to create, store and manage databases.

Question 3

What is a primary key?

Accepted Answer

A primary key is a field that uniquely identifies each record in a table.

Question 4

What is a foreign key?

Accepted Answer

A foreign key is a field that links one table to the primary key of another table.

Question 5

What is a query?

Accepted Answer

A query is a request to retrieve or filter data from one or more tables.

Question 6

Write the meaning of normalization.

Accepted Answer

Normalization is organizing tables to reduce redundancy and improve data consistency.

Question 7

Write any three needs/advantages of DBMS in business.

Accepted Answer

DBMS reduces redundancy, improves consistency, provides security, enables fast retrieval and reports, supports backup and recovery, and supports multi-user access (any three).

Question 8

Differentiate between data and information (any three points).

Accepted Answer

Data is raw facts; information is processed meaningful output. Data may not be useful directly; information supports decisions. Data is input; information is output (any three).

Question 9

Explain primary key and foreign key with example.

Accepted Answer

Primary key uniquely identifies records (CustomerID in Customer table). Foreign key links tables (CustomerID in Orders table referencing Customer table).

Question 10

Write any three MS Access objects and their uses.

Accepted Answer

Tables store data, queries retrieve/filter data, forms help data entry, and reports provide formatted output (any three).

Question 11

Write any three characteristics of DBMS.

Accepted Answer

Controlled access, reduced redundancy, data integrity, backup and recovery, and multi-user support (any three).

Question 12

Explain relational model basics with example (table, row, column).

Accepted Answer

Relational model stores data in tables. Columns are fields (Name, City), rows are records (one customer). Example: Customer table with CustomerID, Name, City.

Question 13

Explain the need/advantages of DBMS in business.

Accepted Answer

A DBMS is needed in business because business data is large and frequently updated.

Points (write in exam):
- Reduces data redundancy: avoids storing same data repeatedly.
- Improves data consistency: same value is maintained across tables.
- Better security: user permissions and controlled access.
- Fast retrieval and reporting: queries and reports for decisions.
- Backup and recovery: protects data from loss.
- Multi-user access: many departments can work on the same database.

Therefore, DBMS helps business operations, reporting and decision making.

Question 14

Explain keys in DBMS (primary, foreign, candidate, composite) with examples.

Accepted Answer

Keys are fields used to identify records and create relationships between tables.

Types:
- Primary key: uniquely identifies each record (CustomerID). It cannot be empty or duplicate.
- Candidate key: any field that can uniquely identify a record (Email or Aadhaar if unique).
- Composite key: combination of fields used together to uniquely identify (OrderID + ProductID).
- Foreign key: field in one table that refers to primary key of another table (CustomerID in Orders).

Keys maintain integrity and help connect business data across tables.

Question 15

Explain normalization and its need in DBMS (1NF, 2NF, 3NF overview).

Accepted Answer

Normalization is the process of organizing data in tables to reduce redundancy and avoid update problems.

Need/advantages:
- removes duplicate data and saves storage
- avoids insertion, update and deletion anomalies
- improves data accuracy and consistency
- makes database structure clear and scalable

Overview:
- 1NF: single value in each field, no repeating groups.
- 2NF: remove partial dependency (important with composite keys).
- 3NF: remove transitive dependency (non-key should not depend on non-key).

Example idea: keep Customer details in Customer table and Orders in Orders table, linked by CustomerID.

Database Basics for Business: DBMS Concepts, Tables, Queries, Forms and Reports (MS Access Overview)

8 more questions to unlock