Course Name: CS3700 : Introduction to Database Systems

Description: Introduction - General introduction to database systems; Database - DBMS disctinction, approaches to building a database, data models, database management system, three-schema architecture of a database, challenges in building a DBMS, various components of a DBMS. E/R Model - Conceptual data modeling - motivation, entities, entity types, various types of attributes, relationships, relationship types, E/R diagram notation, examples. Relational Data Model - Concept of relations, schema-instance distinction, keys, referential integrity and foreign keys, relational algebra operators: selection, projection, cross product, various types of joins, division, example queries, tuple relation calculus, domain relational calculus, converting the database specification in E/R notation to the relational schema. SQL - Introduction, data definition in SQL, table, key and foreign key definitions, update behaviors. Querying in SQL - basic select-from-where block and its semantics, nested queries - correlated and uncorrelate

Slot: D

RoomNo: CS24

Instructor: Sreenivasa Kumar P

Period: JUL-NOV 2013

This page was created on: Thursday 19th of September 2013 09:34:00 PM