Database Management Systems detail syllabus for Information Technology (It), 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 it 5th sem syllabus for b.tech 2019-20 scheme aktu you can visit IT 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, 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, Galgotia 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 It, 2019-20 scheme do visit It 5th Sem syllabus for 2019-20 scheme.
Don’t forget to download iStudy for the latest syllabus, results, class timetable and more.