What do you understand database users?

What do you understand by database users ? Describe

the different types of database users.

What do you understand database users

Database users :-

Database users are the one who use and take the benefits of database. The

different types of users depending on the need and way of accessing the

database are :

1.Application programmers :

a. They are the developers who interact with the database by means

of DML queries.

b. These DML queries are written in the application programs like C,

C++, JAVA, Pascal etc.

c. These queries are converted into object code to communicate with

the database.

2. Sophisticated users :

a. They are database developers, who write SQL queries to select/

insert/delete/update data.

b. They directly interact with the database by means of query language

like SQL.

c. These users can be scientists, engineers, analysts who thoroughly

study SQL and DBMS to apply the concepts in their requirement.

3. Specialized users :

a. These are also sophisticated users, but they write special database

application programs.

b. They are the developers who develop the complex programs

according to the requirement.

4. Standalone users :

a. These users will have standalone database for their personal use.

b. These kinds of database will have predefined database packages

which will have menus and graphical interfaces.

5. Native users :

a. These are the users who use the existing application to interact

with the database.

b. For example, online library system, ticket booking systems, ATMs


Ques.Who are data administrators ? What are the functions

of database administrator ?


Database administrators :- Database administrators are the personnel’s who has control over data andprograms used for accessing the data.

Functions/role of database administrator (DBA) :

1. Schema definition :

a. Original database schema is defined by DBA.

b. This is accomplished by writing a set of definitions, which are

translated by the DDL compiler to a set of labels that are permanently

stored in the data dictionary.

2. Storage structure and access method definition :

a. The creation of appropriate storage structure and access method.

b. This is accomplished by writing a set of definitions, which are

translated by the data storage and definition language compiler.

3. Schema and physical organization and modification :

a. Modification of the database schema or the description of the physical

storage organization.

b. These changes are accomplished by writing a set of definition to do

modification to the appropriate internal system tables.

4. Granting of authorization for data access :

DBA grants different types of authorization for data access to the various users of the database.

5. Integrity constraint specification :

DBA carry out data administration in data dictionary such as defining constraints.


What is a DBMS ?Advantages.

What is a DBMS

What is a (DBMS)?Advantages. Today I am Discussed about DBMS and its advantages , disadvanges.

What is data base management system.

  • Database management system (DBMS) is software used to manage databases. For example, MySQL, Oracle are commercial databases used in various applications.
  • DBMS provides an interface to perform various operations such as creating databases, storing data, updating data, creating tables in the database, etc.
  • Ensuring database protection and security. Data consistency is also maintained with multiple users.

The Data base system allows users to:

Data Definition: Used to create, modify and delete database objects, which defines the organization of data in the database.

Update Data: Used to insert, modify and delete the current data in the database.

Data Retrieval: Used to retrieve data from the database that can be used by applications for various purposes.

User Management: Used to enroll and monitor users, maintain data integrity, enforce data security, handle concurrency control,

monitor performance, and restore information damaged by unexpected errors.

What are the advantages and disadvantages of DBMS?

DBMS Benefits:


  • Database Backup: It controls data redundancy as it stores all data in one database file and this stored data is placed in database.
  • Data Sharing: In DBMS authorized users of an organization can share data among multiple users.
  • Easy maintenance: Due to the centralized nature of the database system, it can be easily maintained.
  • Reduced Time: Reduced development time and maintenance requirements.
  • Backup: Provides a backup and restore subsystem that automatically backs up data from hardware and software failures and restores data when needed.
  • Multiple User Interfaces: Provide different types of user interfaces, such as graphical user interfaces, application program interfaces.

DBMS Disadvantages:


  • Hardware and Software Cost: For the DBMS software to run, but high data processor speed and large memory size are required.
  • Size: Requires a lot of disk space and a lot of RAM to work efficiently.
  • Complexity: Database systems create additional complexity and requirements.
  • Major Outage Impact: Power outage affects database heavily as in most companies all data is stored in database and if database gets
  • corrupted due to power cut or database failure, data can be lost forever.

Thanks for readings this post