virtualgate's picture

 Introduction to DBMS

Introduction to Database Management System
Content covered: 
  • This lecture is overview of the course Database Management System
  • Suppose, you want to access some website like "http://www.techtud.com/" then you make a request through the browser , this request goes to server which has got business logic but no data , so it further requests database server , which responds back by sending data to server , which ultimately responds to user by providing him a webpage.
  • Following topics will be covered in upcoming videos:
  1. Introduction
  2. ER Model
  3. Relational Database Model
  4. Database Design
  5. SQL
  6. Transaction Management
  7. Concurrency Control
  8. File Structure
  9. Index Structure for file
More Less
6Comments
Lecture on Database & DBMS
Content covered: 
  • In this video we will be discussing about DB (Database) and DBMS (Database Management System).
  • DB is a collection of related data.
  • Data are facts that can be recorded , ex. age of person.
  • Data should have implicit meaning.
  • Data should be related.

Properties of DB:

  • logically coherent collection.
  • some aspects of real world, mini world, representation of real purpose problems.
  • data could range in size from few KBs toTBs and complexity.

What is DBMS?

  • DBMS is a software collection of programs that enables user to create and manage database.
  • DBMS System =Database + DBMS s/w

 

More Less
4Comments
Lecture on Database vs Filesystem
Content covered: 

This lecture explains the difference between Database and Filesystem, and discusses about the features of Database.

More Less
2Comments
Lecture on Data Model
Content covered: 
  • This lecture explains the concept of Data Model.
  • Data Model basically tells about structure, introduces you to abstraction and tells how data is stored and processed in the system.
  • 3 types of Data Model exists:
  1. Hierarchical Model
  2. Network Model
  3. Relational Model

Hierarchical Model:

  • ‚Äčit was first proposed by IBM.
  • it is a tree like structure, one parent may have multiple child but child will have only one parent.
  • one to many relationship exists.

Network Model:

  • it is a graph like structure.
  • child may have multiple parents.
  • m:n relationship exists.

Relational Model:

  • Data is organised in form of 2D tables.
  • Ex. : MySQL, Oracle,..
  • Relationship among table exists.
More Less
2Comments
Lecture on Schema, Instance & Metadata
Content covered: 
  • This lecture describes the idea of Schema, Instance, and Metadata.

Schema:

  • ‚ÄčIt is basically description of database.
  • It is specified during database design and is expected not to be changed frequently.

Instance: It is snapshot of Database at a particular point of time, also known as current set of occurence.

Metadata: It is basically data about data.It has complete description of data.

More Less
1Comment
Lecture on Data Independence
Content covered: 
  • In this lecture the concept of Data Independence has been explained.
  • Data Independence: Capacity of changing some part of schema without affecting entire schema either by deleting old database or creating new database.
  • 3 levels of schema are:
  1. Application Schema: application programs run at this level
  2. Logical/Conceptual Schema: relationship exists
  3. Physical Schema: Storage level
  • Logical Data Independence: Capacity of changing conceptual level /logic without affecting application program
  • Physical Data Independence: Capacity of changing physical schema without affecting logical schema.
More Less
0Comment
Lecture on Database Abstraction
Content covered: 

This lecture describes the concept of Database Abstraction.

More Less
0Comment
Lecture on Database Users
Content covered: 
  • This lecture discusses the roles of different Database Users.
  • Different types of database users are:
  1. Naive user: Uses interactive GUI to do work .Ex: filling up form
  2. Application programmer: Writes application programs.
  3. Sophisticated user: can make query directly through the query processor
  4. Specialised User: develops knowledge based system, computer aided design, expert system
  5. Administrative User: he has all the permissions, can create and modify schema, can define access method, can grant permission to other users, can do routine maintenance like clearing of logs,....
More Less
0Comment
Lecture on Database Architecture
Content covered: 

This lecture explains about Database Architecture.

More Less
1Comment

  • This quiz contains 5 questions on the topic Introduction to DBMS
  • Learn well before you attempt the quiz
  • You can attempt the quiz unlimited number of times.

Difficulty Level:  basic