MIT1005

DBMS & SQL Programming
Code: 
MIT1005
Year / Semester: 
1st Semester
Objective: 

To equip student with knowledge of DBMS and working in SQL.

Credits: 
3

Introduction

An overview of database management system, database system Vs file system, Database system concepts and architecture, data models schema and instances, data independence and database language and interfaces, Data definitions language, DML, Overall Database Structure.

Data Modeling using the Entity Relationship Model

ER model concepts, notation for ER diagram, mapping constraints, keys, Concepts of Super Key, candidate key, primary key, Generalization, aggregation, reduction of an ER diagrams to tables, extended ER model, relationships of higher degree.

Relational data Model and Language

Relational data model concepts, integrity constraints: entity integrity, referential integrity, Keys constraints, Domain constraints, relational algebra, relational calculus, tuple and domain calculus,

Introduction to SQL

Characteristics of SQL. Advantage of SQL. SQL data types and literals. Types of SQL commands.

Query by Example (QBE)

Introduction, SELECT Queries in QBE, Make-Table Query, DELETE Query, UPDATE Query, APPEND Query, Conclusion, Exercise SQL operators and their procedure. Tables, views and indexes. Queries and sub queries. Aggregate functions. Insert, update and delete operations. Joins, Unions, Intersection, Minus, Cursors in SQL.

Suggested Readings: 
  1. Fundamental of Database System,Elmasre,Navathe,Pearson edu. ,India
  2. Database system Concept,Korth,TMH
  3. Aspects of Database and Program security,B.Sudhir Kr. Reddy
  4. SQL,PL/SQL The programming language of Oracle by Ivon Bayross