{"id":24625,"date":"2020-07-20T07:39:44","date_gmt":"2020-07-20T07:39:44","guid":{"rendered":"https:\/\/www.inspirenignite.com\/jntuh\/database-management-systems-syllabus-for-mca-1st-year-2nd-sem-r19-regulation-jntuh\/"},"modified":"2020-07-20T07:39:44","modified_gmt":"2020-07-20T07:39:44","slug":"database-management-systems-syllabus-for-mca-1st-year-2nd-sem-r19-regulation-jntuh","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/jntuh\/database-management-systems-syllabus-for-mca-1st-year-2nd-sem-r19-regulation-jntuh\/","title":{"rendered":"Database Management Systems Syllabus for MCA 1st Year 2nd Sem R19 Regulation JNTUH"},"content":{"rendered":"

Database Management Systems detailed Syllabus for Master of Computer Applications(MCA), R19 regulation has been taken from the JNTUH<\/a> official website and presented for the students affiliated to JNTUH course structure. For Course Code, Subject Names, Theory Lectures, Tutorial, Practical\/Drawing, Credits, and other information do visit full semester subjects post given below. The Syllabus PDF files can also be downloaded from the universities official website.<\/p>\n

For all other MCA 1st Year 2nd Sem Syllabus for R19 Regulation JNTUH, do visit MCA 1st Year 2nd Sem Syllabus for R19 Regulation JNTUH <\/a>Subjects. The detailed Syllabus for database management systems is as follows. <\/p>\n

Course Objectives:<\/h4>\n

For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App<\/a>
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.<\/b>
\"Get<\/a>. <\/p>\n

Course Outcomes:<\/h4>\n
    \n
  1. Gain knowledge of fundamentals of DBMS, database design and normal forms<\/li>\n
  2. Master the basics of SQL for retrieval and management of data.<\/li>\n
  3. Be acquainted with the basics of transaction processing and concurrency control.<\/li>\n
  4. Familiarity with database storage structures and access techniques<\/li>\n<\/ol>\n

    Unit I<\/h4>\n

    Database<\/strong> System Applications: A Historical Perspective, File Systems versus a DBMS, the Data Model, Levels of Abstraction in a DBMS, Data Independence, Structure of a DBMS Introduction to Database Design: Database Design and ER Diagrams, Entities, Attributes, and Entity Sets, Relationships and Relationship Sets, Additional Features of the ER Model, Conceptual Design With the ER Model<\/p>\n

    Unit II<\/h4>\n

    For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App<\/a>
    It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.<\/b>
    \"Get<\/a>. <\/p>\n

    Unit III<\/h4>\n

    SQL: Queries, Constraints, Triggers:form of basic SQL query, UNION, INTERSECT, and EXCEPT, Nested Queries, aggregation operators, NULL values, complex integrity constraints in SQL, triggers and active data bases. Schema refinement: Problems caused by redundancy, decompositions, problems related to decomposition, reasoning about functional dependencies, FIRST, SECOND, THIRD normal forms, BCNF, lossless join decomposition, multi-valued dependencies, FOURTH normal form, FIFTH normal form.<\/p>\n

    Unit IV<\/h4>\n

    Transaction Concept, Transaction State, Implementation of Atomicity and Durability, Concurrent Executions, Serializability, Recoverability, Implementation of Isolation, Testing for serializability, Lock Based Protocols, Timestamp Based Protocols, Validation- Based Protocols, Multiple Granularity, Recovery and Atomicity, Log-Based Recovery, Recovery with Concurrent Transactions.<\/p>\n

    Unit V<\/h4>\n

    For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App<\/a>
    It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.<\/b>
    \"Get<\/a>. <\/p>\n

    Text Books:<\/h4>\n
      \n
    1. Database Management Systems, Raghurama Krishnan, Johannes Gehrke, 3rd Edition, Tata Mc Graw Hill<\/li>\n
    2. Database System Concepts, Silberschatz, Korth, 5th edition, Mc Graw hill.<\/li>\n<\/ol>\n

      Reference Books:<\/h4>\n
        \n
      1. Database Systems design, Implementation, and Management, Peter Rob and Carlos Coronel 7th Edition.<\/li>\n
      2. Fundamentals of Database Systems, Elmasri Navrate Pearson Education<\/li>\n
      3. Introduction to Database Systems, C.J.Date Pearson Education<\/li>\n
      4. Oracle for Professionals, The X Team, S.Shah and V. Shah, SPD.<\/li>\n
      5. Database Systems Using Oracle: A Simplified guide to SQL and PL\/SQL,Shah,PHI.<\/li>\n
      6. Fundamentals of Database Management Systems, M. L. Gillenson, Wiley Student Edition.<\/li>\n<\/ol>\n

        For detail Syllabus of all other subjects of Master of Computer Applications 1st Year, visit MCA 1st Year Syllabus<\/a> Subjects.<\/p>\n

        For all MCA results, visit JNTUH MCA all years, and semester results <\/a>from direct links.<\/p>\n","protected":false},"excerpt":{"rendered":"

        Database Management Systems detailed Syllabus for Master of Computer Applications(MCA), R19 regulation has been taken from the JNTUH official website and presented for the students affiliated to JNTUH course structure. […]<\/p>\n","protected":false},"author":2344,"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":[120,130],"tags":[],"class_list":["post-24625","post","type-post","status-publish","format-standard","hentry","category-1st-year","category-mca"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/posts\/24625","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/users\/2344"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/comments?post=24625"}],"version-history":[{"count":0,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/posts\/24625\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/media?parent=24625"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/categories?post=24625"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/tags?post=24625"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}