EC 46 B: Database Management Syllabus for EL 7th Sem 2017 DBATU (Elective-IX)

Database Management detailed syllabus scheme for Electronics Engineering (EL), 2017 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 7th Sem Scheme of Electronics Engineering (EL), 2017 Onwards, do visit EL 7th Sem Scheme, 2017 Onwards. For the Elective-IX scheme of 7th Sem 2017 onwards, refer to EL 7th Sem Elective-IX Scheme 2017 Onwards. The detail syllabus for database management is as follows.

Database Management Syllabus for Electronics Engineering (EL) 4th Year 7th Sem 2017 DBATU

Database Management

Course Objectives:

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.
.

Course Outcomes:

Understand the basic concepts and appreciate the applications of database systems.
Understand the basics of SQL and construct queries using SQL.
Be familiar with a commercial relational database system (Oracle) by writing SQL using the system.
Be familiar with the relational database theory, and be able to write relational algebra expressions for queries.
Understand sound design principles for logical design of databases, including the E-R method and normalization approach.
Be familiar with basic database storage structures and access techniques: file and page organizations, indexing methods including B-tree, and hashing.
Understand the basics of query evaluation techniques and query optimization.
Be familiar with the basic issues of transaction processing and concurrency control.

Unit 1

Introduction to DBMS
Relational Model:
Basic concepts, Attributes and Domains, Codd’s Rules, Relational Integrity: Domain, Entity, Referential Integrities, Enterprise Constraints, Views, Schema Diagram.

Unit 2

Unit 3

Relational Database Design
Purpose of Normalization, Data Redundancy and Update Anomalies, Functional Dependencies: Basic concepts, closure of set of functional dependencies, closure of attribute set, canonical cover, Decomposition: lossless join decomposition and dependency preservation, The Process of Normalization: 1NF, 2NF, 3NF, BCNF, 4NF, 5NF.

Unit 4

File Systems and Query Processing
Overview, Measures of query cost, Selection and join operations, Evaluation of Expressions, Introduction to Query Optimization, Estimation, Transformation of Relational Expressions.

Unit 5

Unit 6

Object-Oriented Databases and Database Architectures
Centralized and Client-Server Architectures, 2 Tier and 3 Tier Architecture, Introduction to Distributed Database systems. Introduction to data mining using association rules, introduction to data warehousing and its components.

Reference/Text Book:

Silberschatz A., Korth H., Sudarshan S., “Database System Concepts”, 5th Edition, McGraw Hill Publishers, 2002, ISBN 0-07-120413-X
Elmasri R., Navathe S., “Fundamentals of Database Systems”, 4* Edition, Pearson Education, 2003, ISBN 8129702282.
Rab P. Coronel C. “Database Systems Design, Implementation and Management”, 5th Edition, Thomson Course Technology, 2002, ISBN 981-243-135-7
Connally T., Begg C., “Database Systems”, 3rd Edition, Pearson Education, 2002, ISBN 81-7808-861-4
Date C., “An Introduction to Database Systems”, 7th Edition, Pearson Education, 2002, ISBN 81 -7808-231- 4
Ramkrishna R., Gehrke J., “Database Management Systems”, 3rd Edition, McGraw-Hill, 2003, ISBN 0-07- 123151 -XAtulKahate, Introduction to Database Management System, 3rd Edition, Pearson Education

For detail syllabus of all subjects of Electronics Engineering (EL) 7th Sem 2017 onwards, visit EL 7th Sem Subjects of 2017 Onwards.

InI MH