RCS501 DMS Syllabus
AKTU INFORMATION TECHNOLOGY(IT) RCS501 DMS Syllabus for all 5 units are provided Below. Download link for IT 5th SEM RCS501 DATABASE MANAGEMENT SYSTEMS Syllabus is listed down for students to make perfect utilization and score maximum marks with our study materials.
UP Technical University INFORMATION TECHNOLOGY (IT) 5th SEM RCS501 DMS – DATABASE MANAGEMENT SYSTEMS Syllabus
RCS501:Database Management Systems
UNIT I
Introduction: Overview, Database system Vs file system, Database system concept and architecture, data model schema and instances, data independence and database language and interfaces, data definitions language, DML, Overall Database Structure. Data Modeling using the Entity Relationship Model: ER model concepts, notation for ER diagram, mapping constraints, keys, Concepts of Super Key, candidate key, primary key, Generalization, aggregation, reduction of an ER diagrams to tables, extended ER model, relationship of higher degree.
UNIT II
Relational Data Model and Language: Relational data model Concepts, integrity constraints, entity integrity, referential integrity, Keys constraints, Domain constraints, relational algebra, relational calculus, tuple and domain calculus. Introduction on SQL: Characteristics of SQL, advantage of SQL. SQl data type and literals. Types of SQL commands. SQL operators and their procedure. Tables, views and indexes. Queries and sub queries. Aggregate functions. Insert, update and delete operations, Joins, Unions, Intersection, Minus, Cursors, Triggers, Procedures in SQL/PL SQL
UNIT III
Data Base Design & Normalization: Functional dependencies, normal forms, first, second, third normal forms, BCNF, inclusion dependence, loss less join decompositions, normalization using FD, MVD and JDs alternative approaches to database design
UNIT IV
Transaction Processing Concept: Transaction system, Testing of serializability, serializability of schedules, conflict & view serializable schedule, recoverability, Recovery from transaction failures, log based recovery, checkpoints, deadlock handling. Distributed Database: distributed data storage, concurrency control, directory system.
UNIT V
Concurrency Control Techniques: Concurrency Control, Locking Techniques for concurrency control, Time stamping protocols for concurrency control, validation based protocol, multiple granularity, Multi version schemes, Recovery with concurrent transaction, case study of Oracle.
References:
1. Korth, Silbertz, Sudarshan,” Database Concepts”, McGraw Hill
2. Date C J, “An Introduction to Database Systems”, Addision Wesley
3. Elmasri, Navathe, “ Fundamentals of Database Systems”, Addision Wesley
4. O’Neil, Databases, Elsevier Pub.
5. RAMAKRISHNAN”Database Management Systems”,McGraw Hill
6. Leon & Leon,”Database Management Systems”, Vikas Publishing House
7. Bipin C. Desai, “ An Introduction to Database Systems”, Galgotia Publications
8. Majumdar & Bhattacharya, “Database Management System”, TMH
9. R.P. Mahapatra, Database Management System, Khanna Publishing House
If you require any other notes/study materials, you can comment in the Below section.
Search Terms
AKTU 5th SEM IT DMS Syllabus
RCS501 DATABASE MANAGEMENT SYSTEMS Syllabus free download
UP Technical University IT DMS Syllabus
RCS501 Syllabus, DMS Unit-wise Syllabus – IT 5th Semester
