DATABASE MANAGEMENT SYSTEM (CSE410)
UNIT 1-Introduction to Database Management System:
Database System environment. File oriented Approach .Database Approach .Users of DBMS. Intended use of DBMS. Benefit of using database approach. Concepts of Client Server Architecture and distributed system.
UNIT 2-Database System Concept and Application:
Date Models, Schemes and instances.DBMS architecture and Independence .Database Languages and Interfaces.The database system environment. Classification of DBMS
UNIT 3-E-R diagram:
Defining relations, Entity Set, E-R Model concept with examples.
UNIT 4-SQL:
Data definition in SQL ,Queries in SQL.Create, Update, Insert statements in SQL.Views in SQL. Specifying additional constraints as assertions. Specifying indexes.
UNIT 5-Functional Dependencies and Normalization for Relational Database:
Functional dependencies, Normal forms based on primary keys,General definitions of second and third normal forms, BoyeCodd normal form.
UNIT 6-Transaction Processing Concepts:
Introduction to transaction processing,Transaction and System concept, Desirable properties of transactions, Schedules and recover ability.
UNIT 7-Concurrency Control Techniques:
Basic Concepts; Concepts of Locks : live lock, dead lock; Serializability
UNIT 8-Security and Integrity:
Security and integrity violation, Authorization, Authorization and Views,Granting of Privileges, Security specification in SQL,Encryption.
UNIT 9-Distributed Databases:
Principles of distributed database; data fragmentations, transparency, integrity, allocation of fragments, translation of global query to fragment query; concurrency control – elementary ideas
PRACTRICAL
1.Oracle :
Introduction to Oracle. Datatypes and attributes constraints, primary key, unique, foreign key, check, not null
2.Introduction to Structured Query Language (SQL):
Data definition language (DDL) - Create, alter, drop table. Data manipulation language (DML) - Select, insert, update, delete. Data control language - Grant, revoke Creating and deleting views, index.
3.Introduction to PL/SQL:
Block structure, variable and types, looping constructs, expression and operators, functions. Cursors variable, cursor fetch, loops. procedure, functions, triggers. Error handling and exceptions 3.5 Composite datatypes
4.Developer 2000/IDS:
Oracle forms - Form modules, blocks, items, windows, canvas views, triggers, master detail forms, menu, alert, LOV. Oracle reports – report generation with parameters.
5.Visual Basic:
Windows programming. Creation of forms, menus, etc. Basic Programming Constructs of Visual Basic-Array handling Common controls of Visual Basic-Creation of Label control, command button, textbox, checkbox, option button, frame, list box, combo box, scroll bars, timer, shape, line. File System Control - Dirlist box, dDrivelist box, filelist box, and synchronization of above controls Common Dialog Controls, Connectivity with Databases (with RDBMS like Oracle), Ideas on implementing ODBC Object Orientation in Visual Basic, Creation of Active X Control using Visual Basic
6. DBA function :
Installation of Oracle & D2K. Creation of a database. Routine maintenance of database. Backup & Recovery of database. Concept of inet.ora
REFERENCE BOOKS
1. Fundamentals of Database System - by Elmasri and Navathe - Addison-Wesley
2. An Introduction to Database Systems – by C.J. Date – Addison-Wesley
3. Principles of Database Systems – by John E. Hopcroft & Jeffrey D. Ullman – Galgotia Pub.
4. Developing personal oracle7 applications – by David Lockman – Sams Pub.
5. Oracle8 DBA handbook – by Kevin Loney – TMH
LIST OF EQUIPMENT
Hardware : Unix/Windows based Client-Server environment (for detail, please refer Annex – I)
Software : Oracle & D2K/IDS (Latest Version)