{"id":3658,"date":"2020-02-07T07:07:09","date_gmt":"2020-02-07T07:07:09","guid":{"rendered":"https:\/\/www.inspirenignite.com\/up\/database-design-nptel-biotech-8th-sem-syllabus-for-aktu-b-tech-2019-20-scheme-departmental-elective-v\/"},"modified":"2020-07-05T01:18:42","modified_gmt":"2020-07-05T01:18:42","slug":"database-design-nptel-biotech-8th-sem-syllabus-for-aktu-b-tech-2019-20-scheme-departmental-elective-v","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/up\/database-design-nptel-biotech-8th-sem-syllabus-for-aktu-b-tech-2019-20-scheme-departmental-elective-v\/","title":{"rendered":"Database Design (Nptel) Biotech 8th Sem Syllabus for AKTU B.Tech 2019-20 Scheme (Departmental Elective-V)"},"content":{"rendered":"

Database Design (Nptel) detail syllabus for Biotechnology (Biotech), 2019-20 scheme is taken from AKTU<\/a> official website and presented for AKTU students. The course code (RBT084), and for exam duration, Teaching Hr\/Week, Practical Hr\/Week, Total Marks, internal marks, theory marks, and credits do visit complete sem subjects post given below.<\/p>\n

For all other biotech 8th sem syllabus for b.tech 2019-20 scheme aktu you can visit Biotech 8th Sem syllabus for B.Tech 2019-20 Scheme AKTU Subjects<\/a>. For all other Departmental Elective-V subjects do refer to Departmental Elective-V<\/a>. The detail syllabus for database design (nptel) is as follows.<\/p>\n

Module 1:<\/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

Module 2:<\/h4>\n

Semantic Database Design
\nHigh-level conceptual modeling, ER Modeling concepts, ER Diagrams, Cardinality constraints, Higher-order relationships, Enhanced ER Model (EER), Weak-entity types, Subclasses and inheritance, Specialization and Generalization, Modeling of UNION types using categories<\/p>\n

Module 3:<\/h4>\n

Relational Model, Languages and Systems
\nRelational algebra: Relational model concepts, Relational integrity constraints, Update operations on relations, Relational algebra model, ER to relational mapping SQL (2 sessions): Data definition in SQL, Queries and update statements, Views, Integrity constraints, Specifying indexes, Embedded SQL. IBM DB2 case study (2 sessions): Architecture of DB2, Data definition and manipulation in DB2. EER to Relational mapping (1 session)<\/p>\n

Module 4:<\/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

Module 5:<\/h4>\n

Storage and Indexing Structures
\nStorage structures: Secondary storage devices, Buffering of blocks, File Organization, Heaps, Sorted Files, Hashing and overflow handling techniques, Dynamic hashing, Extensible hashing, Other file organizations. Indexing methods (3 sessions): Basic terminology, Primary indexes, Clustering index, Secondary index, Multilevel indexes, ISAM, B-trees, B+ trees, inserting and searching algorithms for B+ trees, Other indexing methods<\/p>\n

Module 6:<\/h4>\n

Transaction Processing and Concurrency Control
\nTransaction Fundamentals (3 sessions): OLTP environments, Concurrency issues, need for transactions, Necessary properties of transactions (ACID properties), Transaction states, serializability, Serial schedules, Conflict serializability, View serializability, Recoverable and non-recoverable schedules, Cascading rollbacks, Cascadeless schedules.
\nConcurrency control (3 sessions): Serialized and non-serialized schedules, Testing for serializability, Locking, Lock compatibility matrix, Locking and serializability, Deadlocks and starvation, Two-phase locking (2PL) protocol, Conservative, strict and rigorous 2PL, 2PL with lock conversions, Timestamp-ordering based protocol, Multiversioning protocol, Multi-granularity locking, Deadlock prevention protocols, Wait-die and wound-wait schemes, Time-out based schemes, Deadlock recovery, Nested transactions<\/p>\n

Module 7:<\/h4>\n

Database recovery techniques
\nRecovery concepts, Deferred updates technique, Immediate update technique, Shadow paging, ARIES recovery algorithm<\/p>\n

Module 8:<\/h4>\n

Query Processing and Optimization
\nTranslating SQL into relational algebra, Basic query operations, Heuristics in query optimization, Selectivity and cost estimates in query optimization, Semantic query optimization<\/p>\n

Module 9:<\/h4>\n

Database Security and Authorization (1 session)
\nDiscretionary access control, Mandatory access control and multilevel security, Statistical database security<\/p>\n

Module 10:<\/h4>\n

Enhanced Data Models for specific applications
\nActive database concepts, Temporal databases, Spatial databases, multi-media databases<\/p>\n

Module 11:<\/h4>\n

Distributed databases and issues
\nData fragmentation, replication and allocation in distributed databases, Types of distributed database systems Query processing in distributed databases, Concurrency control and recovery in distributed databases<\/p>\n

Text Books:<\/h4>\n
    \n
  1. \n
      \n
    1. Elmasri, Navathe. Fundamentals of Database Systems (Third Edition), Pearson Education, 2004.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n

      http:\/\/nptel.ac-i<\/p>\n

      For detail syllabus of all other subjects of B.Tech Biotech, 2019-20 regulation do visit Biotech 8th Sem syllabus for 2019-20 Regulation<\/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 Design (Nptel) detail syllabus for Biotechnology (Biotech), 2019-20 scheme is taken from AKTU official website and presented for AKTU students. The course code (RBT084), and for exam duration, Teaching […]<\/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":[45],"tags":[],"class_list":["post-3658","post","type-post","status-publish","format-standard","hentry","category-biotechnology"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/up\/wp-json\/wp\/v2\/posts\/3658","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=3658"}],"version-history":[{"count":0,"href":"https:\/\/www.inspirenignite.com\/up\/wp-json\/wp\/v2\/posts\/3658\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/up\/wp-json\/wp\/v2\/media?parent=3658"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/up\/wp-json\/wp\/v2\/categories?post=3658"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/up\/wp-json\/wp\/v2\/tags?post=3658"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}