KEMBAR78
DBMS | PDF | Databases | Spreadsheet
Scribd
Upload
15 views5 pages

DBMS

A Database Management System (DBMS) is software that facilitates the creation, management, retrieval, and manipulation of databases, with key functions including data storage, user access control, and backup. A query is a command used to request specific information from a database, while computerized accounting systems use software to manage financial transactions. Spreadsheets are digital tools organized in rows and columns for data manipulation and analysis, widely used in various fields for tasks like budgeting and data management.

Uploaded by

umar ali
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
15 views5 pages

DBMS

A Database Management System (DBMS) is software that facilitates the creation, management, retrieval, and manipulation of databases, with key functions including data storage, user access control, and backup. A query is a command used to request specific information from a database, while computerized accounting systems use software to manage financial transactions. Spreadsheets are digital tools organized in rows and columns for data manipulation and analysis, widely used in various fields for tasks like budgeting and data management.

Uploaded by

umar ali
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 5

1. What is DBMS?

Dbms stands for database management system. It is a


software system that allows users to create, manage,
retrieve, and manipulate databases easily and effectively.
In short it is the tool that helps us to store and handle
large amount of data in a standard way.
Examples of dbms:
MySQL
Postgre SQL
Oracle Database
Microsoft SQL server
Main functions of dbms:
®data storage, retrival, and update
®user access control and security
®backup and recovery
®data integrity and consistency
®handling multiple users at the same time
2. What is query?

In tech or data terms, it's usually used to describe a


question you ask a database to get specific results. For
example, in SQL (Structured Query Language), you
might write a query like:
1. In Databases (like SQL):
A query is a command you write to retrieve, insert,
update, or delete data.
Common types:
 SELECT – to fetch data
 INSERT – to add new data
 UPDATE – to modify data
2. In Search Engines:
A query is the words or phrase you type
into Google (or any search engine) to
find information.
Example:
Typing "best pizza near me" into Google is a search
query.
3. in Programming (APIs or Data Science):
Queries can also refer to requests for data from APIs or
data frames.
.

🧠 Summary:
A query is just a question or request made to get specific
information—from a database, system, or tool.
3. What is computerized accounting system?
A computerised accounting system is an accounting
system that uses computer software to record, store,
and process financial transactions. Instead of
manually entering data into books or ledgers,
everything is done using specialized accounting
software like QuickBooks, Tally, Xero, or Sage.

4. What is spreadsheet?
A spreadsheet is a digital tool, typically organized in
rows and columns, used for organizing,
manipulating, and analyzing data. It functions as a
computerized version of paper-based accounting
worksheets, allowing users to enter data, perform
calculations, and visualize information.
Here's a more detailed breakdown:
 Structure:
Spreadsheets are characterized by their grid-like
structure, where data is arranged in rows and
columns, creating individual cells.
 Data Storage:
Each cell can hold various types of data, including
numbers, text, and the results of formulas.
 Calculations:
Spreadsheets excel at performing calculations using
formulas and functions, allowing for automatic
updates when data changes.
 Data Analysis:
They offer tools for analyzing data, including sorting,
filtering, and creating charts and graphs.
 Applications:
Spreadsheets are widely used in various fields,
including finance, business, and education, for tasks
like budgeting, tracking expenses, and managing
data.

5. Create a student database table where the column


names are as follows--
Name
Class
Student_id
Ph_no
Address

You might also like