Explain about database and DBMS.
ans:-
Database: - Database is a collection of data for one or more multiple uses in very well organized format.
Or
Simply well organized collection of data is database.
One way of classifying databases involves the type of content, for example: bibliographic, full-text, numeric, and image. Databases consist of software-based "containers" that are structured to collect and store information so users can retrieve, add, update or remove such information in an automatic fashion. Database programs are designed for users so that they can add or delete any information needed. The structure of a database is tabular, consisting of rows and columns of information.
Advantages
- Reduced data redundancy
- Improved data security
- Reduced data entry, storage, and retrieval costs
- Facilitated development of new applications program
- improved data integrity (integrity:data should be accurate & accurate; it is done by providing some checks
- multiple users.
Disadvantages
- Database systems are complex, difficult, and time-consuming to design
- Substantial hardware and software start-up costs
- Initial training required for all programmers and users
Database Management System (DBMS):-It’s a set of computer programs that controls the creation, maintenance, and the use of the database with computer as a platform or of an organization and its end users.
A DBMS is a system software package that helps the use of integrated collection of data records and files known as databases. It allows different user application programs to easily access the same database. DBMSs may use any of a variety of database models, such as the network model or relational model. In large systems, a DBMS allows users and other software to store and retrieve data in a structured way. Instead of having to write computer programs to extract information, user can ask simple questions in a query language.
Its roles can be listed as given below.
1. provides an interface to the user as well as to application
2. lets user to create,maintain databases.
3. provides high integrity and security to its data.
4. provides sharing facility to many users.
5. provides relationships between tables.
6. provides access level to different users.
7. maintains integrity,consistency of data etc
Disadvantages:
1.initial setup is expensive
2. training to staffs has to be provided
3.database failures.
4.data conversion( computer file into database file which takes more time)
