Question

What are some advantaes of using a DBMS? When might it not be best to use...

What are some advantaes of using a DBMS?
When might it not be best to use a database


Homework Answers

Answer #1

ANS:

DBMS: It is database management software to store data,retrive, modify the data in the form of tables.

Advantage of using DBMS software:

  1. 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.
  2. 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.
  3. Lack Data redundancy : Data redundancy problems may be reduced by DBMS software, you can store your data uniquely.
  4. 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.
  5. 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.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
What is a Database Management System? What are the three principle components of a DBMS ?...
What is a Database Management System? What are the three principle components of a DBMS ? Explain the functions of each of them.
What is a DBMS? Briefly describe the components of a DBMS. What are entity-relationship diagrams and...
What is a DBMS? Briefly describe the components of a DBMS. What are entity-relationship diagrams and how are they used? What symbol is used for a relationship? What is an associative entity? Provide an example. What is cardinality, and what symbols do you use in the crow’s foot notation method? What are data warehousing and data mining? How do businesses use these tools?
please unique answer, no handwriting, for safeAssign Pilgirism submission.API style In DBMS, what would you use...
please unique answer, no handwriting, for safeAssign Pilgirism submission.API style In DBMS, what would you use to obtain information about the current logical structure of the database? How this information is recorded in the DBMS and who is responsible to maintain it? Question Two Consider the following schema: Student(id, name) Registration(id, code) Course(code, instructor) Explain how we can violate the foreign key constraint from the id attribute of Registration to the Student relation. Give the following queries in the relational...
Name some bacterial structures that might be useful to target when using fluorescent antibodies designed for...
Name some bacterial structures that might be useful to target when using fluorescent antibodies designed for diagnosis, and justify your choices.
What are some reasons why a company might use classified stock?
What are some reasons why a company might use classified stock?
consider when you might use a scatterplot versus a histogram. What kinds of variables lend themselves...
consider when you might use a scatterplot versus a histogram. What kinds of variables lend themselves to each representation type? What business applications are best suited to each means of representation?
What are some ways you might use a regression analysis in your business?
What are some ways you might use a regression analysis in your business?
What are some of the best examples of chemical processes I can use in a safety...
What are some of the best examples of chemical processes I can use in a safety project that especially need more safety measures?
When expanding globally, under what conditions might it be in the best interest of the firm...
When expanding globally, under what conditions might it be in the best interest of the firm to buy an existing company in the host country? A. The firm has substantial market share in that country B. You are a direct competitor to the firm in that country C. Government regulations prevent you from entering the country any other way D. All of the above are correct
Outline some specific steps an organization might take to perform data cleansing to ensure the accuracy...
Outline some specific steps an organization might take to perform data cleansing to ensure the accuracy and completeness of its customer database before adding this data to a data warehouse. How would you decide when the data is accurate enough?
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT