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 Hr/Week, Practical Hr/Week, Total Marks, internal marks, theory marks, and credits do visit complete sem subjects post given below.
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. For all other Departmental Elective-V subjects do refer to Departmental Elective-V. The detail syllabus for database design (nptel) is as follows.
Module 1:
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.
Module 2:
Semantic Database Design
High-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
Module 3:
Relational Model, Languages and Systems
Relational 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)
Module 4:
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.
Module 5:
Storage and Indexing Structures
Storage 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
Module 6:
Transaction Processing and Concurrency Control
Transaction 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.
Concurrency 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
Module 7:
Database recovery techniques
Recovery concepts, Deferred updates technique, Immediate update technique, Shadow paging, ARIES recovery algorithm
Module 8:
Query Processing and Optimization
Translating SQL into relational algebra, Basic query operations, Heuristics in query optimization, Selectivity and cost estimates in query optimization, Semantic query optimization
Module 9:
Database Security and Authorization (1 session)
Discretionary access control, Mandatory access control and multilevel security, Statistical database security
Module 10:
Enhanced Data Models for specific applications
Active database concepts, Temporal databases, Spatial databases, multi-media databases
Module 11:
Distributed databases and issues
Data fragmentation, replication and allocation in distributed databases, Types of distributed database systems Query processing in distributed databases, Concurrency control and recovery in distributed databases
Text Books:
-
- Elmasri, Navathe. Fundamentals of Database Systems (Third Edition), Pearson Education, 2004.
http://nptel.ac-i
For detail syllabus of all other subjects of B.Tech Biotech, 2019-20 regulation do visit Biotech 8th Sem syllabus for 2019-20 Regulation.
Don’t forget to download iStudy for the latest syllabus, results, class timetable and more.