This is not official website of GTU, This is our sincere effort to help you more. [Official Websites: GTU  |   AICTE   |   JACPC   |   Results   |   GTUKnowledge   |   SPFU ]



Database Management System

Computer

  [ Back ]

Code : 130703 Common Name : DBMS Year : 2 Sem : 3
Theory Hours : 3 Practical Hours : 2 Tutorial Hours : 0 Credits : 5
Exam Marks : 70 Midsem Marks : 30 Practical Marks : 50 Total : 150


Syllabus Topics


Introductory concepts of DBMS
Introduction and applications of DBMS, Purpose of data base, Data Independence, Database System architecture- levels, Mappings, Database users and DBA



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, aggregation, reduction to E-R database schema



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, BCNF, Multivalued dependency, 4NF, Join dependency and 5NF



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, materialized views



Transaction Management
Transaction concepts, properties of transactions, serializability of transactions, testing for serializability, System recovery, Two- Phase Commit protocol, Recovery and Atomicity, Log-based recovery, concurrent executions of transactions and related problems, Locking mechanism, solution to concurrency related problems, deadlock, , two-phase locking protocol, Isolation, Intent locking



Security
Introduction, Discretionary access control, Mandatory Access Control, Data Encryption



SQL Concepts
Basics of SQL, DDL,DML,DCL, structure – creation, alteration, defining constraints – Primary key, foreign key, unique, not null, check, IN operator, aggregate functions, Built-in functions –numeric, date, string functions, set operations, sub-queries, correlated sub-queries, join, Exist, Any, All , view and its types., transaction control commands.



PL/SQL Concepts
Cursors, Stored Procedures, Stored Function, Database Triggers




Books

An introduction to Database Systems

C J Date - Wesley.

Database System Concepts

Abraham Silberschatz, Henry F. Korth & S. Sudarshan - McGraw Hill.

Understanding SQL

Martin Gruber, - BPB

SQL- PL/SQL

Ivan bayross

Oracle – The complete reference

TMH /oracle press

Exam Papers

Sem200920102011201220132014
3Dec - 2009
23-12-2009


Dec - 2010
16-12-2010


Mar - 2010
11-03-2010


Dec - 2011
17-12-2011


May - 2011
28-05-2011


Dec - 2012
05-01-2013


May - 2012
10-05-2012


Nov - 2013
30-11-2013


May - 2013
29-05-2013


May - 2014
28-05-2014



GTU Result

ExamTotalPassPass %FailFail %AA
9,1237,35780.641,76619.3626
10,6749,38787.941,28712.0655
10,4799,04986.351,43013.6545
9,5827,85882.011,72417.9924