• 01666-222229
  • info@practicise.com
  • Sircl Tech Pvt. Ltd, Red Light Chowk, Sirsa
Search
Close this search box.
Course Content
Detailed Content of Database Management System
0/1
DBMS Syllabus for Diploma
00:00
Database
0/3
What is Database?
00:00
Related Definitions to Database
00:00
Database System
00:00
Introduction To DBMS
0/3
What is DBMS?
00:00
Advantages & Disadvantages of DBMS
00:00
DBMS Users
00:00
Data Models
0/6
Classification Of Data Models
00:00
Relational Data Model
00:00
Network Model
00:00
Hierarchical Model
00:00
Object-Oriented Model
00:00
Difference Between E-R Model and Relational Model
00:00
Data Modeling Using E-R Model
0/6
What is E-R Model?
00:00
Components of ER Diagram
00:00
Integrity Constraints of Relationships in E-R Model
00:00
Difference Between Entity, Entity Set and Entity Type
00:00
Difference between Strong Entity & Weak Entity
00:00
Attributes and Domains
00:00
Relational Model
0/6
What is Relational Model?
00:00
Advantages & Disadvantages of Relational Model
00:00
Relational Algebra Operations
00:00
Types of Keys in Relational Model
00:00
Anomalies in Relational Model
00:00
Difference Between DBMS and RDBMS
00:00
Normalization
0/4
What is Normalization?
00:00
Reasons Why We Require Normalization
00:00
What is Dependency and Type of Dependencies
00:00
FD8 Normalization OR Normal Forms in DBMS
00:00
SQL Query
0/1
Types of SQL Query
00:00
DBMS
About Lesson

DMBS Users:

Database users are categorized based on their interaction with the user. These are seven types of database users in DPMS:

1. Database Administrator (DBA):

Database Administrator (DBA) a person/team who defines the schema and also controls the three levels of database.

The DBA will then create a new account id and password for the user if he/she need to access the database.

DBA is also responsible for providing security to the database and he allows only the authorized users to access/modify the database.

  • DBA also monitors the recovery and backup and provide technical support.
  • The DBA has a DBA account in the DBMS which called a system or superuser account.
  • DBA repairs damage caused due to hardware and/or software failures.

2. Naive/Parametric End Users:

Parametric End Users are the unsophisticated we don’t have any DBMS knowledge, but they frequently use the database application in their daily life to get to the desired results.

For example: Railway’s ticket booking users are naive users, Clerks in any bank is a naive user because they don’t have any DBMS knowledge, but they still use the database and perform their given task.

3. System Analyst:

System Analyst is a user who analyzes the requirements of parametric end users. They check whether all the requirements of end users are satisfied.

4. Database Designers:

Database Designers are the users who design the structure of database which includes tables indexes, views, constraints, triggers, stored procedures. He/She controls what data must be stored and how the data items to be related.

5. Application Program:

Application program is the Back-End Programmers who writes the code for the application programs. They are the computer professionals. These programs could be the written in programming languages such as Visual Basic, Developer, C, FORTON, COBOL, etc.

5. Casual Users/Temporary Users:

Casual Users are the users who occasionally use/access the database but each time when they access the database, they require the new Information.

For Example: Middle or Higher-Level Manager.

Previous
Next