DBMS Topics
HubUnit 1 — Introduction to DBMS & Entity-Relationship ModelAdvantages and Disadvantages of DBMSAggregationCharacteristics of DBMSData IndependenceData ModelsDatabase Users and AdministratorsDBMS LanguagesER DiagramsEntity-Relationship ER ModelIntroduction to DBMSKeys in DBMSRelationships and CardinalitySchema and InstanceSpecialization and GeneralizationUnit 1 Summary — Introduction to DBMS & ER ModelThree-Level Architecture ANSI/SPARC ArchitectureWeak Entity SetUnit 2 — Relational Model & SQLConstraints in SQLCursorsDCL and TCL CommandsDDL CommandsDML CommandsDomain Relational Calculus DRCFunctions and Stored ProceduresJoins in SQLNested Queries SubqueriesRelational AlgebraRelational CalculusRelational ModelSQL IntroductionUnit 2 Summary — Relational Model & SQLTriggers in SQLTuple Relational Calculus TRCViews in SQLArmstrong's Axioms & Closure of AttributesBoyce-Codd Normal Form BCNFClosure of AttributesDependency PreservationFifth Normal Form 5NFFirst Normal Form 1NFFourth Normal Form 4NFFunctional DependencyLossless DecompositionMultivalued DependencyNormal Forms — OverviewNormalization — IntroductionSecond Normal Form 2NFUnit 3 Summary — NormalizationThird Normal Form 3NFUnit 4 — Transaction Management & Concurrency ControlACID PropertiesCheckpointsConcurrency Control & SerializabilityDeadlock in DBMSLock-Based Protocols & Two-Phase LockingLog-Based RecoveryRecovery SystemSerializabilityShadow PagingUnit 4 Summary — Transaction Management & Concurrency ControlTimestamp-Based ProtocolTransaction ManagementTransaction StatesTwo-Phase Locking 2PLUnit 5 — Storage & IndexingB+ TreeB-TreeCost EstimationDynamic HashingFile OrganizationHashing TechniquesIndexing — IntroductionMulti-Level IndexingQuery OptimizationQuery ProcessingSingle-Level IndexingStatic HashingUnit 5 Summary — Storage & IndexingUnit 6 — Advanced Topics in DBMSBig Data and DBMSCloud DatabaseData MiningData WarehouseDatabase SecurityDistributed DatabaseDistributed Query ProcessingDistributed DBMS Architecture, Fragmentation & ReplicationMongoDB — IntroductionNoSQL DatabaseReplication in Distributed DatabasesUnit 6 Summary — Advanced Topics in DBMSViva Voce — DBMSImportant Viva Questions — DBMSInterview Questions — DBMSViva Answers — DBMSDBMS Multiple Choice Questions MCQsDBMS Lab Programs
Database Users and Administrators
Last Updated : 21 May, 2026
Different people interact with a database system in different ways, with different levels of access and different goals. Understanding these roles is essential for proper
Unit 1455 words14 headingsTables includedExamples included
Overview
Different people interact with a database system in different ways, with different levels of access and different goals. Understanding these roles is essential for proper database design and security.
Categories of Database Users
1. Database Administrator (DBA)
The DBA is the central authority responsible for the overall management of the database system.
DBA Responsibilities
- Schema Definition
- Storage Structure & Access Method Definition
- Schema & Physical Organization Modification
- Granting Authorization for Data Access
- Routine Maintenance (Backup, Recovery)
- Performance Monitoring and Tuning
Key DBA Activities:
- Creating and modifying table schemas
- Defining security policies and granting permissions
- Monitoring database performance
- Performing scheduled backups
- Troubleshooting and disaster recovery
- Applying database patches and updates
2. Database Designers
Database designers are responsible for identifying the data to be stored and designing the structure of the database.
- Work closely with end users to understand requirements
- Create the ER (Entity-Relationship) model during design phase
- Convert ER model to relational schemas
- Ensure normalization and integrity constraints are applied
- May hand off the final schema to the DBA for implementation
3. End Users
End users are the people who interact with the database in their day-to-day work.
a) Naive / Parametric End Users
- Most common type
- Interact via pre-built application interfaces (forms, menus, buttons)
- No direct knowledge of SQL or DBMS
- Examples: Bank tellers, airline reservation agents, retail cashiers
b) Casual End Users
- Access the database occasionally for ad-hoc queries
- Knowledgeable enough to write simple SQL queries
- Examples: Managers pulling reports, analysts exploring data
c) Sophisticated End Users
- Familiar with DBMS features and SQL
- Write complex queries, stored procedures, and scripts
- Examples: Data analysts, business intelligence engineers
d) Standalone Users
- Use personal database applications
- Examples: Personal finance software, contact management apps
4. Application Programmers (System Analysts / Software Engineers)
- Write application programs that interact with the database via SQL embedded in code or APIs
- Use host languages (Java, Python, PHP, C#) combined with SQL
- May use ORM frameworks (Hibernate, SQLAlchemy, Entity Framework)
- Responsible for ensuring application-level data validation and efficient queries
5. System Analysts
- Determine user requirements
- Design the system (not just the database)
- Bridge between end users and application programmers
Interaction Diagram
DBMS
DBA
Full Access + Admin
Designer
Schema Design
Naive End User
GUI/App Only
Casual End User
SQL queries Ad-hoc
App Programmer
Embedded SQL
DBA Tools and Responsibilities in Detail
| Responsibility | Description |
|---|---|
| DDL Operations | CREATE, ALTER, DROP tables and schemas |
| User Management | CREATE USER, GRANT, REVOKE privileges |
| Space Management | Monitoring disk usage, adding tablespaces |
| Performance Tuning | Identifying slow queries, adding indexes |
| Backup Strategy | Full/incremental backups on schedule |
| Recovery Testing | Periodic restore drills |
| Security Auditing | Reviewing access logs for unauthorized attempts |
| Upgrade Management | Applying patches and version upgrades |
System Catalog (Data Dictionary)
The DBMS itself uses a special internal database called the system catalog or data dictionary that stores:
- Names of all tables, views, indexes
- Column names, data types, constraints
- User account information and privileges
- Statistical information (row counts, data distribution) used by the query optimizer
The DBA is the primary user of this catalog.
Exam Focus
Revise definitions, diagrams, examples, and short-answer points for Database Users and Administrators.
Interview Use
Prepare one clear explanation, one practical example, and one common mistake for this DBMS topic.
Search Terms
dbms, database management system, database notes, sql, unit, database, users, and
Related DBMS Topics
Continue learning this concept
Unit 1Advantages and Disadvantages of DBMSData is stored in a centralized location. Normalization ensures that each fact is stored only once, eliminating duplicate data across multiple files.Unit 1Relationships and CardinalityA relationship describes an association or connection between two or more entities in the ER model. In the relational model, relationships are implemented using foreign kUnit 1Schema and InstanceA schema is the overall logical structure or blueprint of a database. It defines:Unit 1Unit 1 — Introduction to DBMS & Entity-Relationship ModelThis unit introduces the fundamental concepts of database management systems, the architecture that underlies them, and the Entity-Relationship ER model used for conceptuUnit 1AggregationAggregation is an abstraction mechanism in the Extended ER EER model that allows a relationship set to be treated as a higher-level entity set. This makes it possible forUnit 1Characteristics of DBMSA DBMS has distinct characteristics that differentiate it from simple file-storage systems. These characteristics are what make a DBMS powerful, flexible, and reliable fo