Database Management Systems detail syllabus for Computer Science Engineering (Cse), 2019-20 scheme is taken from AKTU official website and presented for AKTU students. The course code (RCS-501), and for exam duration, Teaching Hr/Week, Practical Hr/Week, Total Marks, internal marks, theory marks, duration, and credits do visit complete sem subjects post given below.
For all other cse 5th sem syllabus for b.tech 2019-20 scheme aktu you can visit CSE 5th Sem syllabus for B.Tech 2019-20 Scheme AKTU Subjects. The detail syllabus for database management systems is as follows.
Unit I
For the complete syllabus, results, class timetable and more kindly download iStudy. It’s a lightweight, easy to use, no images, no pdfs platform to make student’s life easier.
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, 8 third normal forms, BCNF, inclusion dependence, loss less join decompositions, normalization using FD, MVD, and JDs, alternative approaches to database design
Unit IV
For the complete syllabus, results, class timetable and more kindly download iStudy. It’s a lightweight, easy to use, no images, no pdfs platform to make student’s life easier.
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.
Reference Books:
- Korth, Silbertz, Sudarshan, Database Concepts, McGraw Hill
- Date C J, An Introduction to Database Systems, Addision Wesley
- Elmasri, Navathe, Fundamentals of Database Systems, Addision Wesley
- O’Neil, Databases, Elsevier Pub.
- RAMAKRISHNAN”Database Management Systems”,McGraw Hill
- Leon & Leon,Database Management Systems, Vikas Publishing House
- Bipin C. Desai, An Introduction to Database Systems, Gagotia Publications
- Majumdar & Bhattacharya, Database Management System, TMH
- R.P. Mahapatra, Database Management System, Khanna Publishing House
- Course on ‘PHP & MySQL’, Spoken Tutorial MOOC
For detail syllabus of all other subjects of B.Tech Cse, 2019-20 scheme do visit Cse 5th Sem syllabus for 2019-20 scheme.
Don’t forget to download iStudy for the latest syllabus, results, class timetable and more.