DATABASE MANAGEMENT SYSTEM
(130703)
Computer
|
Theory Hours |
: |
3 |
|
Paractical Hours |
: |
2 |
|
Tutorial Hours |
: |
0 |
|
Credits |
: |
5 |
|
Exam Marks |
: |
70 |
|
Midsem Marks |
: |
30 |
|
Practical Marks |
: |
50 |
|
Total |
: |
150 |
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
GTU Result
| Exam | Total | Pass | Pass % | Fail | Fail % | AA | AB | BB | BC | CC | CD | DD | FF |
|
| 9,123 | 7,357 | 80.64 | 1,766 | 19.36 | 26 | 175 | 684 | 1,637 | 2,372 | 1,177 | 1,286 | 1,766 |