Unit-1
Introduction to Database System
Dr. Virendra Singh Kushwah
Senior Assistant Professor Grade-I
School of Computing Science and Engineering
Virendra.Kushwah@vitbhopal.ac.in
General Information
• Each student has to take class on time.
• After 10 Minutes of starting the class, attendance will be taken
and thereafter no one will get attendance. No excuses will be
stand.
• In between you can ask question, if you have any problem but do
not ask unnecessary or meaningless question.
• Notes and other study materials will be shared by google
classroom and link is already shared on MS-Team.
• Internal assessment will be conducted during the semester via
Quizzes, Assignments, Lab viva, Tutorials etc.
• This is an LTP (04 credit course) so practical will be conducted
after learning the concepts.
Pre-requisites
• The proper understanding of data structures and algorithms will help
you to understand the DBMS quickly.
Course Objectives
• Advantages of using a DBMS rather than a file system.
• Designing an Entity-Relationship model for a real life application.
• Mapping a database schema from ER model.
• Evaluating relational schemas for design qualities
• Optimize a query.
• Basic concepts on transaction processing, concurrency control and recovery.
• Fundamental view on unstructured data and its management.
• Storage of databases and techniques to access them using various algorithms
Expected Outcomes
• Explain the role of a database management system in an organization.
• Describe the structure and operation of the relational data model.
• Construct database queries using Structured Query Language (SQL).
• Design and implement a database project depending on the business
requirements, considering various design issues.
• Implement the concept of a database transaction and related
database facilities, including concurrency control, backup and
recovery.
Reference Books
• R. Elmasri & S. B. Navathe, Fundamentals of Database Systems,
Addison Wesley, 7th Edition, 2015.
• A. Silberschatz, H. F. Korth & S. Sudershan, Database System
Concepts, McGraw Hill, 6 th Edition 2010
Summary of so far discussion
• 1. We have seen course objectives to understand following points:
• DBMS is better than file system.
• ER model is needed to represent database schema(structure) in graphically.
• Transformation should be proper.
• Analyzing database schema
• Query must be optimized.
• 2. Expected outcomes can be as follows:
• Opportunities in DBMS
• Structure of DBMS
• Construct SQL (Structure Query Language)
Introduction to Database system
• Data
• Database
• Database system
• Database Management System
Introduction to Database system
• Data
• Database
• Database system
• Database Management System
Database: What
• Database
• is collection of related data and its metadata organized in a structured
format for optimized information management
• Database Management System (DBMS)
• is a software that enables easy creation, access, and modification of
databases
• for efficient and effective database management
• Database System
• is an integrated system of hardware, software, people, procedures, and data
• that define and regulate the collection, storage, management, and use of
data within a database environment