Database Management Systems (2130703)   Old Code : 130703

8
Credit
4 + 0 + 4
Lect + Tuto + Pract
Teaching Scheme
70 + 20 + 10
ESE + PA + ALA
Theory Marks
20 + 10 + 20
ESE + OEP + PA
Practical Marks
ESE - End Semester Examination, PA - Progress Assessment, ALA - Active Learning Assignments, OEP -Open Ended Problem


Prerequisite

(1) Elementary knowledge about computers including some experience using UNIX or Windows.

(2) Computer Programming & Utilization

(3) Knowledge about data structures and algorithms, corresponding to the basic course on Data Structures and Algorithms.

Rationale

A database management system (DBMS) is designed to manage a large body of information. Data management involves both defining structures for storing information and providing mechanisms for manipulating the information. In addition, the database system must provide for the safety of the stored information, despite system crashes or attempts at unauthorized access. If data are to be shared among several users, the system must avoid possible anomalous results due to multiple users concurrently accessing the same data.

Examples of the use of database systems include airline reservation systems, company payroll and employee information systems, banking systems, credit card processing systems, and sales and order tracking systems.

A major purpose of a database system is to provide users with an abstract view of the data. That is, the system hides certain details of how the data are stored and maintained. Thereby, data can be stored in complex data structures that permit efficient retrieval, yet users see a simplified and easy-to-use view of the data. The lowest level of abstraction, the physical level, describes how the data are actually stored and details the data structures. The next-higher level of abstraction, the logical level, describes what data are stored, and what relationships exist among those data. The highest level of abstraction, the view level, describes parts of the database that are relevant to each user; application programs used to access a database form part of the view level.

Course Outcome

After learning the course the students should be able:

  1. Evaluate business information problem and find the requirements of a problem in terms of data.
  2. Understand the uses the database schema and need for normalization.
  3. Design the database schema with the use of appropriate data types for storage of data in database.
  4. Use different types of physical implementation of database
  5. Use database for concurrent use.
  6. Backup data from database.

Active Learning

Preparation of power-point slides, which include videos, animations, pictures, graphics for better understanding theory and practical work – The faculty will allocate chapters/ parts of chapters to groups of students so that the entire syllabus to be covered. The power-point slides should be put up on the web-site of the College/ Institute, along with the names of the students of the group, the name of the faculty, Department and College on the first slide. The best three works should submit to GTU.