ANS:
DBMS: It is database management software to
store data,retrive, modify the data in the form of tables.
Advantage of using DBMS software:
- Security: To store the data in
DBMS is much secure to store data in a traditional way. Whatever
data access whenever it is modifying all records may get in the
proper manner.
- Easy to store and
Fetching the data: Using DBMS software you can save much
time to store and fetch data. Only one query can fetch your data
from a large table.
- Lack Data
redundancy : Data redundancy problems may be reduced by
DBMS software, you can store your data uniquely.
- Data
Integrity: Whatever data you are accessing and storing
nothing will change automatically, your data will be accurate as
you have stored.Example: If in your account has 50$ and you have
fetched 20$ so 30$ will remain in your account, not less than or
greater than.
- No
inconsistency: DBMS stored data in a consistent way.
Suppose in school management student roll number defines all
information of a student, you define roll number as unique key, if
school assign, assigned roll number to another student, database
will give error and not store this type of entries.
When might it not be best to use a database
Database is mainly required where large data has to be
maintained and stored. Database is costly and its maintenance is
hard require technical people to manage it
If data is not large and working in a very small organization or
business ,coaching then it is best not to use a database.
Example: If you have a small vegetable shop or
grocery shop you can maintain your customer account in a copy pen
or excel sheet. No need to store customer data in the database.
Thank you have a Good Day.