Bsc. I.T. - Database Management Systems
Bsc. I.T.

Database Management Systems Syllabus

I Introduction to Databases and Transactions: What is database system, purpose of database system, view of data, relational databases, database architecture, transaction management

Data Models: The importance of data models, Basic building blocks, Business rules, The evolution of data models, Degrees of data abstraction.

Database Design, ER Diagram and Unified Modeling Language: Database design and ER Model: overview, ER Model, Constraints, ER Diagrams, ERD Issues, weak entity sets, Codd’s rules, Relational Schemas, Introduction to UML
II Relational database model: Logical view of data, keys, integrity rules, Relational Database design: features of good relational database design, atomic domain and Normalization (1NF, 2NF, 3NF, BCNF).

Relational Algebra and Calculus: Relational algebra: introduction, Selection and projection, set operations, renaming, Joins, Division, syntax, semantics. Operators, grouping and ungrouping, relational comparison.

Calculus: Tuple relational calculus, Domain relational Calculus, calculus vs algebra, computational capabilities
III Constraints, Views and SQL: Constraints, types of constrains, Integrity constraints, Views: Introduction to views, data independence, security, updates on views, comparison between tables and views SQL: data definition, aggregate function, Null Values, nested sub queries, Joined relations. Triggers.
IV Transaction management and Concurrency: Control Transaction management: ACID properties, serializability and concurrency control, Lock based concurrency control (2PL, Deadlocks), Time stamping methods, optimistic methods, database recovery management.
V PL-SQL: Beginning with PL / SQL, Identifiers and Keywords, Operators, Expressions, Sequences, Control Structures, Cursors and Transaction, Collections and composite data types, Procedures and Functions, Exceptions Handling, Packages, With Clause and Hierarchical Retrieval, Triggers.

Database Management Systems Practicals

Practical NoDetails
1 SQL Statements – 1
a Writing Basic SQL SELECT Statements
b Restricting and Sorting Data
c Single-Row Functions
2 SQL Statements – 2
a Displaying Data from Multiple Tables
b Aggregating Data Using Group Functions
c Subqueries
3 Manipulating Data
a Using INSERT statement
b Using DELETE statement
c Using UPDATE statement
4 Creating and Managing Tables
a Creating and Managing Tables
b Including Constraints
5 Creating and Managing other database objects
a Creating Views
b Other Database Objects
c Controlling User Access
6 Using SET operators, Date/Time Functions, GROUP BY clause (advanced features) and advanced subqueries
a Using SET Operators
b Datetime Functions
c Enhancements to the GROUP BY Clause
d Advanced Subqueries
7 PL/SQL Basics
a Declaring Variables
b Writing Executable Statements
c Interacting with the Oracle Server
d Writing Control Structures
8 Composite data types, cursors and exceptions.
a Working with Composite Data Types
b Writing Explicit Cursors
c Handling Exceptions
9 Procedures and Functions
a Creating Procedures
b Creating Functions
c Managing Subprograms
d Creating Packages
10 Creating Database Triggers

Database Management Systems Reference Books

Title Database System and Concepts
Authors A Silberschatz, H Korth, S Sudarshan
Publisher McGraw-Hill
Edition 5th
Download Here
Title Database Systems
Authors Rob Coronel
Publisher Cengage Learning
Edition 12th
Download Here
Title Programming with PL/SQL for Beginners
Authors H. Dand, R. Patil and T. Sambare
Publisher X –Team
Edition 1st
Year 2011
Download Here
Title Introduction to Database System
Authors C.J.Date
Publisher Pearson
Edition 1st
Year 2003
Download Here