102 DATA BASE MANAGEMENT SYSTEM (DBMS)

1. Basic Concepts of Database Management System.
1.1 Fundamental concepts of File and databases
1.2 Purpose of database system
1.3 Introduction to Data models
1.3.1 Conceptual Data model – E- R model
1.3.2 Record – base Data models – Hierarchical. Relation , Network
2. Features of Database Systems
2.1 Data abstraction & Data independence
2.2 Type of Database Languages : DDL, DML,TCL
2.3 Database users : Database manager, administrator and Users
2.4 Overall system structure.
3. Relational Commercial Language - SQL
5. Commercial DBMS : Microsoft Access / DB2
5.1 Basic Architecture as DBMS
5.2 Working with databases and tables.
5.3 Managing constrains and relationships.
5.4 Using SQL queries.
5.5 Introduction to other object : Forms , Reports, Macros, etc.
6. Integrity Constrains
6.1 Domain Constrains , key Constrains, Referential Integrity Constrains
6.2 Functional Dependencies
7. Relational Database Design
7.1 Pitfalls in relational database design
7.2 Normalization using Functional Dependencies
7.3 Normalization using Multi valued Dependencies
7.4 Normalization using Join Dependencies
7.5 Domain – Key normal form
8. [Self Study]
     Security features provided by access / DB2


Reference Books
1. Database System Concepts – SILBERSCHATZ , KORTH, SUDARSHAN- McGraw- Hill
2. An introduction to Database Systems- C.J.DATE – Addison Wesley
3. Database System : A practical approach to design implementation and management – THOMAS CONNOLLY , CAROLYN BEGG, Pearson Education
4. Access - The Complete Reference – Virginia Andersen – McGraw - Hill
5. Access Database Design & Programming – Steven Roman - O' Reilly
6. Microsoft Access : Bible – Cary N. Prague