Course description

Introduction to Databases;Data Models,Entity-Relationship (ER) Model; SQL; Enhanced Entity Relationship (EER) Model; Relational Data Model; The Relational Algebra; Relational Data Model in SQL;Functional;Dependencies & Normalization;Physical Design;Indexing; Database Transactions & Concurrency Control; SQL Interaction with Programming Interfaces;NoSQL and applications

Scope

The rapid computerization of all the personal, organizational and governance work flow are needing to store data properly. Now a days each event we do online like social network, online banking, online shopping and so on, the activity data is going to be stored in some database. On the other hand, the current development of technology is highly aligned with the Data Science and Machine Learning; Both the interconnected fields are need collection historical data. But most of the data in the world are neglected or hard to use. Most of the business decisions and strategies are made based on the historical data. If data is stored scientifically then it may be the most precious property in the future. Therefore, the study of database is become very essential part of computer science; and data engineering become a most preferred profession.

This course will illustrate the theory studied in the DBMS classes. The aim of this course is to study of storing, manipulating and accessing data efficiently using SQL.

The course provides a general overview of the nature and purpose of database systems. It is explained how the concept of a database system has developed, what the common features of database systems are, what a database system does for the user, and how a database system interfaces with operating systems.

Objective

The course is designed to provide complete knowledge of C language. Students will be able to develop logic which will help them to create programs, applications in C. Also by learning the basic programming constructs they can easily switch over to any other language in future.

Outcomes

• Design and manage database with SQL.
• Explain different types of physical implementation of database
• Explain and design the database schema and need for normalization.
• Implement relational databases using a RDBMS

Teaching & Learning Plan

During an average week, students were expected to spend at least 12 hours on the course.

Text Book

T1 Fundamentals of Database Systems (6th Edition) ISBN-13: 978-0136086208 Navathe Pearson Education

Reference Book

R1 Database System Concepts 6th Edition by Abraham Silberschatz Professor (Author), Henry F. Korth (Author), S. Sudarshan (Author) Publisher: McGraw-Hill Education; 6 edition (January 27, 2010);ISBN-10: 0073523321, ISBN-13: 978-0073523323

R2 Silberschatz, Korth and Sudarshan TMH; NoSQL with MongoDB in 24 Hours by Brad Dayley