Database Systems detailed syllabus scheme for B.Tech Computer Engineering (CE), 2019-20 onwards has been taken from the DBATU official website and presented for the Bachelor of Technology students. For Subject Code, Course Title, Lecutres, Tutorials, Practice, Credits, and other information, do visit full semester subjects post given below.
For all other DBATU Syllabus for Computer Engineering 5th Sem 2019-20, do visit CE 5th Sem 2019-20 Onwards Scheme. The detailed syllabus scheme for database systems is as follows.
Database Systems Syllabus for Computer Engineering (CE) 3rd Year 5th Sem 2019-20 DBATU
UNIT 1
For the complete syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdf platform to make students’s lives easier.
.
UNIT 2
Relational query languages: Relational algebra, Tuple and domain relational calculus, SQL3, DDL and DML constructs, Open source and Commercial DBMS – MYSQL, ORACLE, DB2, SQL server.
UNIT 3
Relational database design: Domain and data dependency, Armstrong’s axioms, Normal forms, Dependency preservation, Lossless design.
UNIT 4
For the complete syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdf platform to make students’s lives easier..
UNIT 5
File Organization and Indexing: Indices, B-trees, hashing.
UNIT 6
Transaction processing: Concurrency control, ACID property, Serializability of scheduling, Locking and timestamp based schedulers, Multi-version and optimistic Concurrency Control schemes, Database recovery.
Text Books:
For the complete syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdf platform to make students’s lives easier..
Reference Books:
- Joel Murach, Murach’s Oracle SQL and PL/SQL for Developers, Mike Murach & Associates, 2nd Edition, 2014.
- Wiederhold, Database Design, McGraw-Hill Publication, 2nd Edition, 1983.
- Navathe, Fundamentals of Database System, Addison-Wesley Publication, 6th Edition, 2012.
- Mark L. Gillenson, Fundamentals of Database Management System, Wiley Publication, 2nd Edition, 2011.
- J. D. Ullman, Principles of Database and Knowledge – Base Systems, Vol 1, Computer Science Press.
- Serge Abiteboul, Richard Hull, Victor Vianu, Foundations of Databases, Reprint by Addison-Wesley.
For detail syllabus of all other subjects of Computer Engineering (CE) 5th Sem 2019-20 regulation, visit CE 5th Sem Subjects syllabus for 2019-20 regulation.