Database Management Systems Syllabus
Unit | Details |
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 No | Details |
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 |
Year | |
Download Here |
Title | Database Systems |
Authors | Rob Coronel |
Publisher | Cengage Learning |
Edition | 12th |
Year | |
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 |