GITAM University Syllabus BE 8th Sem Data Base Management System

GITAM University Syllabus

Data BaseManagement System

VIII th Semester

 

B.Tech. (BT) VIII Semester

EURBT 852: Data Base Management System
Code: EURBT 852 Category: IE
Credits: 4 Hours : 4 per week

Prerequisite: File processing

UNIT I:
Introduction to DBMS – Overview, File system vs DBMS, Advantages of DBMS,
Storage data, queries, Transaction Management, DBMS Structure
UNIT II:
E-R model Entities, Attributes and Entity sets, Relation ship and Relationship sets,
Features of ER model, Conceptual database design with ER model.
UNIT III:
Relational model – integrity constraints over relations and enforcement, Querying
relation data, Logical database design, views, destroying/altering tables and views.
Relational algebra and calculus
UNIT IV:
SQL – Basic SQL, Query, union, intersect, except, Nested Queries, Aggregated
Operation, Null values, Embedded SQL, cursors, ODBC and JDBC, Triggers and
Active database, designing active databases
UNIT V:
Transaction management, concurrency control & crash recovery – Transaction
concept, transactions and schedules, concurrent execution of transactions, lock –
based concurrency control, crash recovery.
Case Study: Oracle (SQL, PL/SQL & Triggers)
Text Book:
1. Database Management Systems – Raghu Ramakrishnan and Johannes Gehrke
McGraw-Hill
2. Data System Concepts – H.F.Korth and A.Silberschatz McGraw-Hill
Reference Book:
1. Fundamentals of Database System – R.El. Masri and S.B.Navathe

1 thought on “GITAM University Syllabus BE 8th Sem Data Base Management System”

Leave a Comment