Data base Management System (IT-405) - B Tech RGPV AICTE Flexible Curricula Notes -->

Wednesday, March 13, 2019

Data base Management System (IT-405)
 B.Tech RGPV notes AICTE flexible curricula Bachelor of technology

Course Objectives:

The main objectives of the course are
1. To understand fundamental knowledge of file system, database concepts and use of relational database.
2. To study of different data model and conceptual design using ER diagram.
3. Students can use SQL operations to manipulate the database and learn how to design and create a good database using functionaldependencies and normalization.
4. The course provides an overview of transaction management, concurrency control, distributed database and Big Data.

rgpv bhopal, diploma, rgpv syllabus, rgpv time table, how to get transcript from rgpv, rgpvonline,rgpv question paper, rgpv online question paper, rgpv admit card, rgpv papers, rgpv scheme

B.Tech RGPV notes AICTE flexible curricula Bachelor of technology


Basic Concepts: Introduction to DBMS, File system vs DBMS, Advantages of database systems, Database System architecture, Data models, Schemas and instances, Data independence, Functions of DBA and designer, Entities and attributes, Entity types, Key attributes, Relationships, Defining the E-R diagram of database.

Relational Model: Structure of relational databases, Domains, Relations, Relational algebra – fundamental operators and syntax, relational algebra queries, Entity-Relationship model :Basic concepts, Design process, constraints, Keys, Design issues, E-R diagrams, weak entity sets, extended E-R features –generalization, specialization and aggregation

SQL: Data definition in SQL, update statements and views in SQL: Data storage and definitions, Data retrieval queries and update statements, Query Processing & Query Optimization: Overview, measures of query cost, selection operation, sorting, join, evaluation of expressions, transformation of relational expressions, estimating statistics of expression results, evaluation plans. Case Study of ORACLE and DB2.

Relational Database design: Functional Dependency –definition, trivial and non-trivial FD, closure of FD set, closure of attributes, irreducible set of FD, Normalization –1NF, 2NF, 3NF, Decomposition using FD-dependency preservation, lossless join, BCNF, Multi-valued dependency, 4NF, Join dependency and 5NF

Introduction of transaction, transaction processing and recovery, Concurrency control: Lock management, specialized locking techniques, concurrency control without locking, Protection and Security Introduction to: Distributed databases, Basic concepts of object oriented data base system.


Course Outcomes:

After successful completion of this course, the students would be able to:
1. Compare file system and DBMS and explain how DBMS is better than traditional File Processing Systems.
2. Analyze the physical and logical database designs, database modeling, relational, hierarchical, and network models
3. Analyze and renovate an information model into a relational database schema and to use a DDL, DML and DCL utilities to implement the schema using aDBMS.
4. Formulate data retrieval queries in SQL and Relational Algebra.
5. Demonstrate an understanding of functional dependencies, normalization theory and apply such knowledge to the design of adatabase.
6. Demonstrate and explain terms like Transaction Processing, Concurrency Control, distributed database and big data

Reference Books:

1. Korth, Silbertz, Sudarshan, “Database Concepts”, McGrawHill.
2. Elmasri, Navathe, “Fundamentals of Database Systems”, Pearson.
3. Ivan Bayross, “SQL, PL/SQL the Programming Language of Oracle”, BPB publications.
4. S. Sharma, J. Agrawal, S. Agrawal, “Advanced Database Management System”, Dreamtech Press.
5. Leon & Leon, “Fundamental of Data Base Management System”,TMH

List of Experiments:

1. To perform various SQL Commands of DDL, DML, DCL.
2. Write SQL Commands such as Insertion, deletion and updation for anyschema.
3. To execute Nested Queries, Join Queries, order-by, having clause and string operation.
4. To perform set operators like Union, Intersect, Minus on a set of tables.
5. To execute various commands for GROUP functions (avg, count, max, min, Sum).
6. Write a PL/SQL block for transaction application usingTriggers.
7. Write a DBMS program to prepare report for an application using function.
8. Designing of various Inputscreens/Forms.
9. Create reports using database connectivity ofFront end with back end.
10. Create database Design with normalization and implementing in anyapplication.

You May Also Like

Follow Author Here:



Yup, everything is free....


User doesn't have to register for accessing the files, all the files are free & universally accessible without any condition or restriction.


Our webpages are responsive & user-friendly, which means it will automatically adjust according to your device screen size and you will find stuff without ant hustle.


All the files are uploaded on our super-fast servers so that they can be easily downloaded with high speed.


For providing a better experience to our users we are developing our Android application, the application will have a lot of awesome features so stay tuned ;).


Our AI-powered Chatbots are always here to help you so, feel free to ask any question or report if you face any problem. Our team also monitors all chatbots traffic & they will contact you if chatbot fails to help.

Contact Us