Introduction To Database Management System

Paper Code: 
EMS 423
Credits: 
4
Contact Hours: 
60.00
Objective: 

This course has been designed to introduce the students to applications of systems designed to manage the data resources of organizations. It provides them an opportunity to study the hands-on implementation of a data base in corporate environment.

12.00
Unit I: 
File System and Databases

Introduction to files and file system, Introduction to data base concept, Database Models, Types of Database Systems: Client Server, Object Oriented, Distributed DBMS, Advantages of DBMS. Introduction to MS-Access, Database creation in MS-Access, creating tables, entering data into table, editing data, viewing records, sorting records.
 

12.00
Unit II: 
Database Architecture & Relational Database Model

Database hierarchy, data duplication, data inconsistency, lack of data integration, data dependence,
Database Architecture: Database Abstraction, Data Independence, Integrity Rules, Relational Database, Keys: Primary Key, Foreign Key, Alternate Key, Candidate Key.functional dependency.
 

12.00
Unit III: 
Database Design & Working with the Database Objects

E-R Model, Designing Tables from the ER model, functional dependencies   Normalization: 1NF, 2NF, 3NF,Querying a data base, Creating forms, Generating reports in MS- Access, Role of DBA.
 

12.00
Unit IV: 
Structured Query Language

Creating tables, Select Statement, Handling Null Values, definition of DML and DDL,ORDER BY clause, WHERE clause, GROUP BY clause, Relational Operators, Logical Operators, SQL Operators, Numeric Functions, String Functions, Date Functions, Joining Tables, Views.
 

12.00
Unit V: 
Database Security and Administration

Database Security, Access Control, Access Controls on Views and Integrity Constraint, client –server model, Recovery Techniques
 

References: 

Text Books:

  1. Ramakrishna and Geherke, Database Management Systems, Tata  Mc Graw Hill Pub. Co. Ltd. 2011.
  2. Ivan BayRoss, Database Technologies, Sybex Computer Books Inc.2011
  3. Ramez Elmasri and Shamkant B. Navathe, “Fundamental Database Systems”, Third Edition, Pearson Education, 2011.

Other Readings:

  1. Database System Concepts, Silberschatz, Korth, Sudarshan, Tata Mc GrawHill Pub. Co. Ltd.2011
  2. Mastering Access 2011 – Simpson Alan, Robinson, & Celeste.