A database is an organized collection of related data stored so that it can be accessed, updated and managed easily. A DBMS (Database Management System) is the software that helps users and applications to create, store, retrieve, secure, and maintain databases.
In business, databases are used to store and manage:
This topic covers DBMS concepts and how business users work with databases using MS Access (tables, queries, forms and reports).
Businesses handle data continuously (orders, bills, payments, inventory, HR records). A database helps by:
Metadata means “data about data”. It includes details such as field names, data types, validation rules, keys and relationships. In MS Access, table design and relationships store metadata.
Integrity means data is correct and reliable. Common types:
Common models:
Why relational is preferred in business:
Example (Customer table):
Business importance: constraints prevent wrong billing, duplicate customers, invalid dates/amounts and reporting errors.
Referential integrity ensures that a foreign key value must exist as a primary key value in the parent table.
Example: if an Order has CustomerID = 5, then CustomerID 5 must exist in the Customers table. This prevents orphan records.
In MS Access, referential integrity is enforced via Relationships by checking:
Normalization is organizing data into proper tables to reduce redundancy and improve integrity.
Access the complete note and unlock all topic-wise content
It's free and takes just 5 seconds
Get instant access to notes, practice questions, and more benefits with our mobile app.
Download this note as PDF at no cost
If any AD appears on download click please wait for 30sec till it gets completed and then close it, you will be redirected to pdf/ppt notes page.
A database is an organized collection of related data stored so that it can be accessed, updated and managed easily. A DBMS (Database Management System) is the software that helps users and applications to create, store, retrieve, secure, and maintain databases.
In business, databases are used to store and manage:
This topic covers DBMS concepts and how business users work with databases using MS Access (tables, queries, forms and reports).
Businesses handle data continuously (orders, bills, payments, inventory, HR records). A database helps by:
Metadata means “data about data”. It includes details such as field names, data types, validation rules, keys and relationships. In MS Access, table design and relationships store metadata.
Integrity means data is correct and reliable. Common types:
Common models:
Why relational is preferred in business:
Example (Customer table):
Business importance: constraints prevent wrong billing, duplicate customers, invalid dates/amounts and reporting errors.
Referential integrity ensures that a foreign key value must exist as a primary key value in the parent table.
Example: if an Order has CustomerID = 5, then CustomerID 5 must exist in the Customers table. This prevents orphan records.
In MS Access, referential integrity is enforced via Relationships by checking:
Normalization is organizing data into proper tables to reduce redundancy and improve integrity.
If customer address/phone is stored in every invoice row, updates become inconsistent. Normalization stores customer details once in Customers table and links orders using CustomerID.
Exam line: “Normalization reduces redundancy and avoids insertion, update and deletion anomalies.”
SQL (Structured Query Language) is used to create and manipulate data in RDBMS.
-- Example: list customers from Pune
SELECT CustomerID, Name, Phone
FROM Customers
WHERE City = 'Pune'
ORDER BY Name;
MS Access is a desktop DBMS tool used for small-to-medium business databases.
A query is a request to retrieve or modify data.
Business uses: outstanding payments list, low-stock products, top customers, monthly sales totals.
A form is a user-friendly screen for entering/editing data.
Advantages:
Examples: customer registration form, invoice form, stock entry form.
A report is formatted output for printing/sharing.
Features:
Examples: invoice print, monthly sales report, stock valuation report.
Businesses must protect financial/customer data:
Conceptually, DBMS supports multi-user access and prevents conflicts (locking/transactions in larger DBMS).
A database is the collection of tables and records. A DBMS is the software that defines tables, controls access, enforces rules, and helps retrieve data using queries.
Primary key is like a unique identity number. Foreign key is the linking number that connects related tables so that data is not repeated.
Businesses typically enter data through forms, store it in tables, analyze using queries, and present results using reports.
From this topic
DBMS reduces redundancy, improves consistency, provides security, enables fast retrieval and reports, supports backup and recovery, and supports multi-user access (any three).
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).
A DBMS is needed in business because business data is large and frequently updated.
Points (write in exam):
Therefore, DBMS helps business operations, reporting and decision making.