Course Contents

10:18 AM
Database Management systems 1. Introduction : 1.1 Approach to Data Management 1.2 Advantages of Database Systems 1.3 Functio...

1.3 Functions of DBMS

10:12 AM
The functions performed by a typical DBMS are the following: Data Definition The DBMS provides functions to define the structure of...

2.1 Clustering

10:07 AM
This chapter discusses the issues related to how the data is physically stored on the disk and some of the access mechanisms commonly used...

2.2 Indexing

10:07 AM
Indexing is another common method for making retrievals faster. Consider the example of CUSTOMER table used above. The following query is b...

2.3 Hashingd

10:07 AM
Hashing is yet another method used for making retrievals faster. This method provides direct access to record on the basis of the value of a...

3.3 Integrity Rules

10:01 AM
The following are the integrity rules to be satisfied by any relation. • No Component of the Primary Key can be null. • The Database ...

4.1 SQL Overview

10:00 AM
The components of SQL are a. Data Manipulation Language – Consists of SQL statements for operating on the data (Inserting, Modifying, D...
Powered by Blogger.