Find Database Management System(DBMS) important question and answers for BCA, BSC, MCA students.
1. What are the disadvantages of File processing?
2. What is DBMS? Explain advantages and disadvantages of DBMS.
3. What are the different components of DBMS?
4. Explain different types of databases.
6.What are the functions of DBMS?
Add a comment
The file processing system method of organizing and managing data was a definite improvement over the manual system. The traditional file processing system well in data management for a long time.
However, there exist different disadvantages of file system data management.
In the article problems with the traditional File Processing System, you have seen the different problems with the existing traditional File Processing system. So, to overcome those problems, the Database Management System was Introduced.
"A database management system (DBMS) is a collection of programs that manages the database structure and controls access to the data stored in the database".
The DBMS serves as the intermediary between the user and the database. The database structure itself is stored as a collection of files, So, we can access the data in those files through the DBMS.
The DBMS receives all application requests and translates them into the complex operations required to fulfill those requests. The DBMS hides much of the database’s internal complexity from the application programs and users.
Add a comment
Different Database Types
A DBMS can support many different types of databases. There exist different database types according to the number of users, the database location(s), and the expected type and extent of use.
The number of users determines whether the database is classified as single-user or multiuser.
Single User Database:
Add a comment
The term database system refers to an organization of components that define and regulate the collection, storage, management, and use of data within a database environment.
The five major components of database management system are
Hardware,
Software,
People,
Procedures, and
Data.
Add a comment
DBMS performs several important functions that guarantee the integrity and consistency of the data in the database. The most important functions of Database Management System are
Data Dictionary Management,
Data Storage Management,
Data Transformation and Presentation,
Security Management,
Multi user Access Control,
Backup and Recovery Management,
Data Integrity Management,
Database Access Languages andApplication Programming Interfaces and
Database Communication interfaces.
What is Data model and the importances of Data Models in DBMS
Data models can facilitate interaction among the designer, the applications programmer, and the end user.
A well-developed data model can even foster improved understanding of the organization for which the database design is developed. In short, data models are a communication tool.
Relationship and types of Relationships in DBMS:
A relationship describes an association among entities. For example, a relationship exists between customers and agents that can be described as follows: an agent can serve many customers, and each customer may be served by one agent.
Data models use three types of relationships: one-to-many, many-to-many, and one-to-one.
Add a commentAdvertisement
