Introduction To Database Management System (Functional Electives IT & Systems)

Paper Code: 
MBS - 424
Credits: 
4.0
Contact Hours: 
40.00
Max. Marks: 
100.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.
6.00
Unit I: 
File System and Databases

Introduction to files and file system, Database System, Database Models, Types of Database Systems: Client Server, Distributed DBMS, Advantages of DBMS.

5.00
Unit II: 
The Relational Database Model

Database Architecture: Database Abstraction, Data Independence, Integrity Rules, Relational Database, Keys: Primary Key, Foreign Key, Alternate Key, Candidate Key.

5.00
Unit III: 
Database Design

E-R Model, Designing Tables from the ER model, Normalization: 1NF, 2NF, 3NF

14.00
Unit IV: 
Structured Query Language

Creating tables, Select Statement, Handling Null Values, ORDER BY clause, WHERE clause, GROUP BY clause, Relational Operators, Logical Operators, SQL Operators, Numeric Functions, String Functions, Date Functions.

10.00
Unit V: 
Database Security and Administration

Database Security, Access Control, Integrity Constraint, The DBA’s Managerial Role.

Essential Readings: 
  • Ramakrishna and Geherke, Database Management Systems, Tata  Mc Graw Hill Pub. Co. Ltd.
  • Ivan BayRoss, Database Technologies, Sybex Computer Books Inc.
  • Ramez Elmasri and Shamkant B. Navathe, “Fundamental Database Systems”, Third Edition, Pearson Education, 2003.
References: 
  1. Database System Concepts, Silberschatz, Korth, Sudarshan, Tata Mc GrawHill Pub. Co. Ltd.