{"id":4465,"date":"2020-02-08T06:00:07","date_gmt":"2020-02-08T06:00:07","guid":{"rendered":"https:\/\/www.inspirenignite.com\/up\/database-management-systems-cse-5th-sem-syllabus-for-aktu-b-tech-2019-20-scheme\/"},"modified":"2020-02-08T06:00:07","modified_gmt":"2020-02-08T06:00:07","slug":"database-management-systems-cse-5th-sem-syllabus-for-aktu-b-tech-2019-20-scheme","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/up\/database-management-systems-cse-5th-sem-syllabus-for-aktu-b-tech-2019-20-scheme\/","title":{"rendered":"Database Management Systems CSE 5th Sem Syllabus for AKTU B.Tech 2019-20 Scheme"},"content":{"rendered":"

Database Management Systems detail syllabus for Computer Science Engineering (Cse), 2019-20 scheme is taken from AKTU<\/a> 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.<\/p>\n

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<\/a>. The detail syllabus for database management systems is as follows.<\/p>\n

Unit I<\/h4>\n

For the complete syllabus, results, class timetable and more kindly download iStudy<\/a>. It’s a lightweight, easy to use, no images, no pdfs platform to make student’s life easier.<\/b><\/p>\n

Unit II<\/h4>\n

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\n<\/p>\n

Unit III<\/h4>\n

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\n<\/p>\n

Unit IV<\/h4>\n

For the complete syllabus, results, class timetable and more kindly download iStudy<\/a>. It’s a lightweight, easy to use, no images, no pdfs platform to make student’s life easier.<\/b><\/p>\n

Unit V<\/h4>\n

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.\n<\/p>\n

Reference Books:<\/h4>\n
    \n
  1. Korth, Silbertz, Sudarshan, Database Concepts, McGraw Hill<\/li>\n
  2. Date C J, An Introduction to Database Systems, Addision Wesley<\/li>\n
  3. Elmasri, Navathe, Fundamentals of Database Systems, Addision Wesley<\/li>\n
  4. O’Neil, Databases, Elsevier Pub.<\/li>\n
  5. RAMAKRISHNAN”Database Management Systems”,McGraw Hill<\/li>\n
  6. Leon & Leon,Database Management Systems, Vikas Publishing House<\/li>\n
  7. Bipin C. Desai, An Introduction to Database Systems, Gagotia Publications<\/li>\n
  8. Majumdar & Bhattacharya, Database Management System, TMH<\/li>\n
  9. R.P. Mahapatra, Database Management System, Khanna Publishing House<\/li>\n
  10. Course on ‘PHP & MySQL’, Spoken Tutorial MOOC<\/li>\n<\/li>\n<\/ol>\n

    For detail syllabus of all other subjects of B.Tech Cse, 2019-20 scheme do visit Cse 5th Sem syllabus for 2019-20 scheme<\/a>.<\/p>\n

    Don’t forget to download iStudy<\/a> for the latest syllabus, results, class timetable and more.<\/p>\n","protected":false},"excerpt":{"rendered":"

    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 […]<\/p>\n","protected":false},"author":2300,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[40,49],"tags":[],"class_list":["post-4465","post","type-post","status-publish","format-standard","hentry","category-5th-sem","category-cse"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/up\/wp-json\/wp\/v2\/posts\/4465","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inspirenignite.com\/up\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inspirenignite.com\/up\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/up\/wp-json\/wp\/v2\/users\/2300"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/up\/wp-json\/wp\/v2\/comments?post=4465"}],"version-history":[{"count":0,"href":"https:\/\/www.inspirenignite.com\/up\/wp-json\/wp\/v2\/posts\/4465\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/up\/wp-json\/wp\/v2\/media?parent=4465"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/up\/wp-json\/wp\/v2\/categories?post=4465"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/up\/wp-json\/wp\/v2\/tags?post=4465"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}