Database Management Systems Detailed Syllabus for Geo-Informatics and Surveying Technology M.Tech first year first sem is covered here. This gives the details about credits, number of hours and other details along with reference books for the course.
The detailed syllabus for Database Management Systems M.Tech 2017-2018 (R17) first year first sem is as follows.
M.Tech. I Year I Sem.
Course Objectives: to understand the role of Database Management to prepare spatial data base.
Course Outcomes: at the end of the course the student will able to Understand the components of Database management system and file management methods, Apply the concepts of SQL and its use to manage the databases, Carry out the Query, update a databases using SQL and Design and build a simple database system using DBMS software.
UNIT-I: Need for Data Base Management Systems (DBMS) Components of DBMS, Records and files, Data Models, Data Associations, Entities, Attributes and Associations, Relationships among entities, Data models classification
UNIT-II: File Organization, Constituents of file, Operations on files, Sequential files, Index- Sequential files, Direct files
UNIT-III: Relational Database, Attributes and domains, Tuples, Relations and their schemes, Relation Representation, Relational operations, Relational algebra, Relational calculus, Implementation
UNIT-IV: Relational Database Manipulation, Structured Query Language (SQL), Query Language (QUEL) Query-by-Example (QBE), Data Manipulation and retrieval using SQL.
UNIT-V: QUEL and QBE, Concepts of Relational database design, Introduction to Big Data Management
TEXT BOOKS:
- Arun K. Majundar and P. Bhattacharya, Database Management Systems, 2001.
- Bipin C. Desai, An Introduction to Database Systems, 1990.
REFERENCES:
- C J Date, An Introduction to Database Systems Vol-1, 1994.
For all other M.Tech 1st Year 1st Sem syllabus go to JNTUH M.Tech Geo-Informatics and Surveying Technology 1st Year 1st Sem Course Structure for (R17) Batch.
All details and yearly new syllabus will be updated here time to time. Subscribe, like us on facebook and follow us on google plus for all updates.
Do share with friends and in case of questions please feel free drop a comment.