JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

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:

• 1. Arun K. Majundar and P. Bhattacharya, Database Management Systems, 2001.
• 2. Bipin C. Desai, An Introduction to Database Systems, 1990.

REFERENCES:

• 1. C J Date, An Introduction to Database Systems Vol-1, 1994.