BASICS OF DATABASE MANAGEMENT SYSTEM (KOE-067)
B.Tech Semester VI – Theory Examination (2021–22)
Database Management System is a fundamental subject in computer science and information technology that deals with the systematic storage, retrieval, manipulation, and management of data. In modern computing environments, data is one of the most valuable resources, and DBMS provides a structured and secure way to manage large volumes of data efficiently. This subject introduces the concepts of database architecture, data models, SQL, transactions, normalization, concurrency control, security, backup, and recovery.
The uploaded question paper clearly shows that the examination focuses on basic DBMS concepts, database architecture, relational model, SQL operations, transaction management, normalization, locking mechanisms, data modeling, constraints, and recovery techniques. To score well, answers must be written in clear, connected paragraphs, with proper explanation of concepts, examples wherever required, and correct technical terminology.
SECTION A – FUNDAMENTAL DBMS CONCEPTS
(Based on Section A on Page-1)
A Database Management System (DBMS) is software that allows users to define, create, maintain, and control access to databases. It acts as an interface between users and the physical database, ensuring data consistency, security, and efficient access.
The difference between a Database System and a File System lies in data organization and control. A file system stores data in separate files with little or no relationship among them, leading to redundancy and inconsistency. A database system, on the other hand, stores data in an integrated manner, reduces redundancy, and provides mechanisms for data sharing and integrity enforcement.
A Tuple represents a single row in a relational table and contains a set of related attribute values that describe one entity instance.
Logical data independence refers to the ability to change the logical schema without affecting application programs. This is important because it allows database designers to modify the structure of the database without rewriting existing applications.
The need for Structured Query Language (SQL) arises because it provides a standard way to define, manipulate, and control data in a relational database. SQL enables users to perform queries, updates, insertions, and deletions efficiently.
Views and indexes in SQL serve different purposes. A view is a virtual table created from one or more base tables to simplify data access and enhance security, while an index improves data retrieval speed by providing a faster access path to table rows.
Serializability ensures that concurrent execution of transactions produces the same result as some serial execution order, thereby maintaining database consistency.
The properties of a transaction, known as ACID properties, include atomicity, consistency, isolation, and durability. These properties ensure reliable transaction execution.
Database security refers to the protection of data against unauthorized access, misuse, or modification using authentication, authorization, and encryption mechanisms.
The need for backup and recovery arises because databases are vulnerable to failures such as system crashes, power failures, and human errors. Backup and recovery mechanisms help restore the database to a consistent state after failure.
SECTION B – DATABASE ARCHITECTURE, TRANSACTIONS & ABSTRACTION
(Based on Section B on Page-1)
Centralized and Client–Server architectures represent two important database system designs. In centralized architecture, the database resides on a single system, while in client–server architecture, the database server manages data and multiple clients access it over a network. Client–server architecture improves scalability, performance, and security in large organizations.
A Relational Database Schema defines the structure of a relational database using tables, attributes, and relationships. It provides a logical blueprint for organizing data.
Integrity constraints ensure data accuracy and consistency. These constraints enforce rules such as entity integrity and referential integrity.
A Transaction is a sequence of database operations that performs a logical unit of work. Transaction properties can be explained using examples such as money transfer between bank accounts, where either the entire transaction completes successfully or none of it does.
A Log is a record of all database modifications. It plays a critical role in recovery. In deferred database modification, changes are written to the database only after transaction commit, whereas in immediate database modification, changes are written immediately but recorded in the log for recovery.
The principles of views of data relate to how users perceive the database. This leads to the concept of levels of abstraction, which include physical level, logical level, and view level. These levels simplify database design and usage.
SECTION C – NORMALIZATION AND CONCURRENCY CONTROL
(Based on Section C on Page-1)
The need for database normalization arises to eliminate data redundancy and update anomalies. First Normal Form (1NF) ensures atomic attribute values, while Second Normal Form (2NF) eliminates partial dependency. These concepts are best explained using practical examples involving relational tables.
Two Phase Locking (2PL) is a concurrency control protocol that ensures serializability. In this protocol, a transaction follows a growing phase where it acquires locks and a shrinking phase where it releases locks, preventing conflicts between concurrent transactions.
DATA MODELING, SQL & CONSTRAINTS
(Based on Page-2 of the paper)
Data Modeling using the Entity Relationship (ER) Model is a conceptual design technique that represents entities, attributes, and relationships. ER diagrams help in visualizing database structure before implementation.
The insert, update, and delete operations in SQL allow modification of database records. These operations are essential for maintaining dynamic data.
Referential integrity and domain constraints ensure that relationships between tables remain valid and attribute values remain within defined domains.
Data Mining, Data Warehousing, and Data Visualization are advanced database concepts. Data mining extracts hidden patterns, data warehousing integrates historical data for analysis, and data visualization presents data graphically for better understanding.
FUNCTIONAL DEPENDENCIES, STORED PROGRAMS & RECOVERY
A Functional Dependency describes the relationship between attributes in a table and is fundamental to normalization. Key constraints and domain constraints define uniqueness and valid data ranges.
Stored procedures, stored functions, and database triggers are database programs that enhance performance and automation.
Recovery with concurrent transactions ensures that even in the presence of multiple transactions and system failures, the database can be restored to a consistent state using logs and checkpoints.
HOW TO WRITE DBMS ANSWERS IN THE EXAM
In DBMS, never write answers in short bullet points. Always begin with a clear definition, followed by detailed explanation, examples, and relevance. Use correct terminology such as schema, transaction, normalization, concurrency, integrity, and recovery. Examiners give maximum weightage to conceptual clarity, logical flow, and correct explanation of database mechanisms.
