BOE067 Basics of Data Base Management System Syllabus
AKTU B.Tech · 3rd Year · Unit-wise syllabus (effective 2024-25)
BOE067 Basics of Data Base Management System (also written as KOE067) is a subject in the 3rd year of the AKTU B.Tech programme, prescribed by Dr. A.P.J. Abdul Kalam Technical University with an L-T-P of 3-0-0. The syllabus is divided into 5 units: Introduction, Relational Database Concepts and Data Base Design & Normalization, Structured Query Language (SQL) and PL/SQL, Transaction Processing Concepts and Concurrency Control Techniques. The complete unit-wise topic list, course outcomes and reference books are given below, taken from the official AKTU syllabus effective from 2024-25.
BOE067 Subject Details
| Subject Code | BOE067 / KOE067 |
|---|---|
| Subject Name | Basics of Data Base Management System |
| University | Dr. A.P.J. Abdul Kalam Technical University (AKTU) |
| Course | B.Tech (Bachelor of Technology) |
| Year / Semester | 3rd Year |
| L-T-P | 3-0-0 |
| Total Units | 5 |
| Scheme Effective From | 2024-25 |
| Last Verified | 2026-08-17 |
BOE067 Basics of Data Base Management System Unit-Wise Syllabus
Official AKTU syllabus (effective 2024-25) — 5 units.
Unit 1: Introduction
Introduction: An overview of database management system, database system vs file system, database system concepts and architecture, views of data – levels of abstraction, data models, schema and instances, data independence, database languages and interfaces, data definition languages, DML, overall database structure, transaction management, storage management, database users and administrator. Data Modeling using the Entity Relationship Model: ER model concepts, notation for ER diagram, mapping constraints, keys, concepts of super key, candidate key, primary key, generalization, aggregation, reduction of an ER diagrams to tables, extended ER model, relationships of higher degree.
Unit 2: Relational Database Concepts · Data Base Design & Normalization
Relational Database Concepts: Introduction to relational database, relational database structure, relational model terminology – domains, attributes, tuples, relations & relationaldatabase schema, integrity constraints, entity integrity, referential integrity, keys constraints, domain constraints, Relational algebra - relational calculus, tuple and domain calculus, basic operations – selection and projection, set-theoretic operations, join operations. Data Base Design & Normalization: Functional dependencies, normal forms, first, second, & third normal forms, BCNF, inclusion dependence, loss less join decompositions,normalization using FD, MVD, and JDs, alternative approaches to database design
Unit 3: Structured Query Language (SQL) · PL/SQL
Structured Query Language (SQL): Basics of SQL, DDL, DML, DCL, advantage of SQL, SQL data type and literals, types of SQL commands, SQL operators and theirprocedure, tables – creation & alteration, defining constraints, views and indexes, queries and sub queries, aggregate functions, built-in functions, insert, update and delete operations, joins, unions, intersection, minus, transaction control commands. PL/SQL: Introduction, features, syntax and constructs, SQL within Pl/SL, DML in PL/SQL Cursors, stored procedures, stored function, database triggers, indices
Unit 4: Transaction Processing Concepts · Concurrency Control Techniques
Transaction Processing Concepts: Transaction concepts, properties of transaction, testing of serializability, Serializability of schedules, conflict & view serializable schedule, recoverability, recovery from transaction failures, two-phase commit protocol, log based recovery, checkpoints, deadlock handling. Concurrency Control Techniques: Concurrency control, locking techniques for concurrency control, time stamping protocols for concurrency control, validation based protocol, multiple granularity, multi-version schemes, recovery with concurrent transaction.
Unit 5
Database Security – Types of security, system failure, backup & recovery techniques, authorization & authentication, system policies, levels of security – physical, OS, network & DBMS, privileges – grant & revoke. Recent Trends in Database Management Systems: Centralized and Client-Server Architectures, Distributed Databases, Object-Oriented Database, Spatial & Temporal Databases, Decision Support Systems, Data Analysis, Data Mining & Warehousing, Data Visualization, Mobile Databases, OODB & XML Databases, Multimedia & Web Databases, Spatial and Geographical Databases, Web and Mobile Databases, Active Databases
BOE067 Course Outcomes
- At the end of course , the student will be able to:
- CO 1 Describe the features of a database system and its application and compare various K2
- CO 2 types of data models. K5, K6
- CO 3 Construct an ER Model for a given problem and transform it into a relation database K5, K6
- CO 4 schema. K2, K3
- Formulate solution to a query problem using SQL Commands, relational algebra, tuple
- calculus and domain calculus.
- Explain the need of normalization and normalize a given relation to the desired normal form.
- CO 5 Explain different approaches of transaction processing and concurrency control. K2
BOE067 Reference Books
- Elmasri, Navathe, “Fundamentals of Database System”, Addision Wesley.
- Korth, Silbertz, Sudarshan, “Database Concepts”, McGraw Hill.
- Bipin C. Desai, “An Introduction to Database System”, Galgotia Publication.
- Majumdar & Bhattacharya, “ Database Management System”, McGraw Hill.
- Date C.J., “An Introduction to Database System”, Addision Wesley.
- Ramakrishnan, Gehrke, “Database Management System”, Mc Graw Hill.
- Atul Kahate, “Introduction to Database Management Systems”, Pearson Education.
- Paul Beynon Davies, “Database System”, Palgrave Macmillan.
- Bharti P.K., “ An Introduction to Database Systems”, JPNP.
- Rajesh Narang, “Database Management System”, PHI.
- Singh, S.K., “Database System Concepts – design & application”, Pearson Education.
- Leon & Leon, “Database Management Systems”, Vikas Publishing House.
- O’Neil, “Databases”, Elsevier Pub.
- Ivan Bayross, “SQL, PL/SQL – The Programming Language of Oracle”, BPB Publications.
- P.S. Deshpande, “SQL and PL/SQL for Oracle 10g, Black Book”, Dreamtech Press.
- George Koch, Kevin Loney, “Oracle: The Complete Reference”, McGraw Hill.
- Coronel, Morris and Rob, “Database Principles: Fundamentals of Design, Implementation and Management”,
- Gillenson, Paulraj Ponniah, “Introduction to Database Management”, Wiley.
- G. K. Gupta, “Database Management Systems”, McGraw Hill.
- Shraman Shah, “Oracle for Professional”, SPD.
Frequently Asked Questions about BOE067
What is the syllabus of BOE067 Basics of Data Base Management System?
The AKTU BOE067 Basics of Data Base Management System syllabus is divided into 5 units: Introduction; Relational Database Concepts and Data Base Design & Normalization; Structured Query Language (SQL) and PL/SQL; Transaction Processing Concepts and Concurrency Control Techniques. The complete topic list for each unit is published on this page, taken from the official Dr. A.P.J. Abdul Kalam Technical University syllabus effective from 2024-25.
How many units are there in BOE067?
BOE067 Basics of Data Base Management System has 5 units in the AKTU syllabus, with an L-T-P (Lecture-Tutorial-Practical) structure of 3-0-0.
Is BOE067 the same subject as KOE067?
Yes. AKTU renumbered its B.Tech subject codes from the 2022-23 session onwards, so the same subject appears as BOE067 and KOE067 depending on the scheme year. The syllabus content is the same.
Where can I download BOE067 previous year question papers?
AKTU B.Tech previous year question papers for every semester are available to download free on Ryzenstudy, with no login or registration required.
Is this the official AKTU syllabus for BOE067?
Yes. Every topic on this page is taken from the official Dr. A.P.J. Abdul Kalam Technical University syllabus document (AKTU B.Tech 3rd Year CS / Computer Engineering / CSE Syllabus), effective from 2024-25. A direct link to the original AKTU PDF is provided at the top of this page. Last verified on 2026-08-17.
Related AKTU Syllabus
Source: Dr. A.P.J. Abdul Kalam Technical University official syllabus — AKTU B.Tech 3rd Year CS / Computer Engineering / CSE Syllabus, effective from 2024-25. Ryzenstudy is not affiliated with AKTU. Content last verified on 2026-08-17.