Database Management Systems (3130703)   Old Code : 2130703

5
Credit
4 + 0 + 2
Lect + Tuto + Pract
Teaching Scheme
70 + 30 + 0
ESE + PA + ALA
Theory Marks
30 + 0 + 20
ESE + OEP + PA
Practical Marks
ESE - End Semester Examination, PA - Progress Assessment, ALA - Active Learning Assignments, OEP -Open Ended Problem


Prerequisite
Basic knowledge of Computer Programming
Rationale
Database is an integral part of real life application system. The course will enable student understand the different issues involved in the design and implementation of a database system. Student will learn the physical and logical database designs, database modeling, relational, hierarchical, and network models. Student will learn to use data manipulation language to query, update, and manage a database. Student will understand essential DBMS concepts such as: database security, integrity, concurrency, storage strategies etc. The students will get the hands on practice of using SQL and PL/SQL concepts.
Course Outcome
 Sr.  No.  CO statement  Marks % weightage
CO-1  For a given query write relational algebra expressions for that query and optimize the developed expressions 10
CO-2  For a given specification of the requirement design the databases using ER method and normalization 20
CO-3  For a given specification construct the SQL queries for Open source and Commercial DBMS -MYSQL, ORACLE, and DB2 20
CO-4  For a given query optimize its execution using Query optimization
algorithms
10
CO-5  For a given transaction-processing system, determine the transaction atomicity, consistency, isolation, and durability 10
CO-6  Implement the isolation property, including locking, time stamping based on concurrency control and Serializability of scheduling 20

Active Learning
1. https://www.tutorialspoint.com/dbms/ 2. https://www.w3schools.com/sql/ 3. https://www.codecademy.com/learn/learn-sql