Syllabus
|
Course Code: IT-303 Course Name: Specialisation – E: INFORMATION TECHNOLOGY - Relational Database Management System |
||
| MODULE NO / UNIT | COURSE SYLLABUS CONTENTS OF MODULE | NOTES |
|---|---|---|
| 1 | RDBMS: Introduction – Database and DBMS Software, Three Layered Architecture, Evolution of Data Modeling-Object Oriented and Record Based models, E-R Model and E-R diagram. Hierarchical Model, Network Model and Relational Model; Normalisation techniques-First Normal Form, Second Normal Form and the Third normal Form. E.F. Codd‟s 12 Rules for a relational Database. Database concepts-Transaction Management, Commit and Rollback, Concurrency, Locking, Access Control, Data Integrity, Integrity Constraints, Auditing, Backup and Recovery; Data Dictionary-System Catalogue Distributed Database and Distributed Data Access. Introduction to Client-Server and ODBC connectivity, SQL: SQL Language-DML commands-Selection, Insert, Update, Delete retrieving data, summarizing data, adding data to the database, updating data to the database and deleting data. Simple queries to demonstrate use of WHERE, Arithmetic comparison and logical operators, ORDER BY, GROUP BY and Group Functions. Multi table queries, Sub-queries. Views DDL Commands-Table and View, Create, Alter, Drop Integrity Constraints; Transaction Processing-Commit, Rollback, Savepoint, LAB: SQL and MS Access. |
|
