Data Base Management System detailed Syllabus for Industrial Engineering & Management (IEM), 2018 scheme has been taken from the VTUs official website and presented for the VTU students. For Course Code, Subject Names, Teaching Department, Paper Setting Board, Theory Lectures, Tutorial, Practical/Drawing, Duration in Hours, CIE Marks, Total Marks, Credits and other information, visit full semester subjects post given below. The Syllabus PDF files can also be downloaded from the official website of the university.
For all the other VTU IEM 6th Sem Syllabus for BE 2018 Scheme, visit Industrial Engineering & Management 6th Sem 2018 Scheme.
For all the (Professional Elective-1) subjects refer to Professional Elective-1 Scheme. The detail syllabus for data base management system is as follows.
Course Learning 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 pdfs platform to make students’s lives easier.
.
Module-1
DATABASES AND DATABASE USERS: Introduction, characteristics of data base approach, intended uses of a DBMS, advantages and implication of database approach. DATABASE SYSTEMS CONCEPTS AND ARCHITECTURE: Data models, Schemas and instances, DBMS architecture and data independence, database languages and interfaces, database system environment, classification of data base management systems.
Module-2
DATA MODELING: High level conceptual data models for database design. Entity types, entity sets, attributes, and keys. Relationships, relationship types, roles and structural constraints. Weak entity types. ER diagrams RECORD STORAGE AND PRIMARY FILE ORGANIZATION: Secondary storage devices, buffering of blocks, placing file records on disk, operations on files, heap files and sorted files, hashing techniques.
Module-3
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 pdfs platform to make students’s lives easier..
Module-4
Structured Query Language (SQL): Data definition in SQL2. Basic and complex queries in SQL. Insert, delete, update statements, and views in SQL, embedded SQL. DATABASE DESIGN: Design guidelines for relational schemes, functional Dependencies, normalization -1st, 2nd, 3rd, 4th, and 5th normal forms. Database design process, factors influencing physical database design guidelines and guidelines for relational systems.
Module-5
SYSTEM IMPLEMENTATION: System cat log for RDBMS, transaction processing and system concepts, properties of transactions, brief discussion on concurrency, control and recovery techniques, database security and authorization.
Course Outcomes:
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 pdfs platform to make students’s lives easier..
Question Paper Pattern:
- The question paper will have ten full questions carrying equal marks.
- Each full question will be for 20 marks.
- There will be two full questions (with a maximum of four sub- questions) from each module.
- Each full question will have sub- question covering all the topics under a module.
- The students will have to answer five full questions, selecting one full question from each module.
Text Books:
- Fundamentals of database systems -Ramez Elmasri and Shamkanth B. Navathe – Addison Wesley Publishing Company – 6th Edition.
- Database Management System – Raghu Ramakrishnan and Johannes Gehrke – TATA McGraw Hill -3rd Edition – ISBN 0-07-1231511
Reference 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 pdfs platform to make students’s lives easier..
For the detail Syllabus of all other subjects of BE (IEM) 6th Sem, visit Industrial Engineering & Management 6th Sem Subjects.
For all (CBSE & Non-CBSC) BE/B.Tech results, visit VTU BE/B.Tech all semester results.