Introduction to Database Management
INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS
By
Mohammed Sanaulla Khan
SID: 1120297
Mohammed Mudassaruddin
SID: 1111422
Abstract
A collection of programs that enables you to store, modify, and extract information from a database. There are many different types of DBMSs, ranging from small systems that run on personal computers to huge systems that run on mainframes. The following are examples of database applications: ✓ computerized library systems ✓ automated teller machines ✓ flight reservation systems ✓ computerized parts inventory systems
From a technical standpoint, DBMSs can differ widely. The terms relational, network, flat, and hierarchical all refer to the way a DBMS organizes information internally. The internal organization can affect how quickly and flexibly you can extract information.
Introduction
A database consists of four elements as given, 1. Data 2. Relationships 3. Constraints 4. Schema
1) Data ➢ Data are binary computer representations of stored logical entities. ➢ Software is divided into two general categories-data and programs. ➢ A program is a collection of instruction for manipulating data. ➢ Data exist is various forms- as numbers tents on pieces of paper, as bits and bytes stored in electronic memory or as facts stored in a persons mind.
2) Relationships ➢ Relationships explain the correspondence between various data elements.
3) Constraints ➢ Are predicates that define correct database states.
4) Scheme ➢ Schema describes the organization of data and relationships within the database. ➢ Schema defines various views of the database for the use of various system components of the database management system and for the application’s security. ➢ A schema separates physical aspects of data storage form the logical aspects of data representation.
[pic]
Types of schema ➢ Internal schema: defines how and where the data are
By
Mohammed Sanaulla Khan
SID: 1120297
Mohammed Mudassaruddin
SID: 1111422
Abstract
A collection of programs that enables you to store, modify, and extract information from a database. There are many different types of DBMSs, ranging from small systems that run on personal computers to huge systems that run on mainframes. The following are examples of database applications: ✓ computerized library systems ✓ automated teller machines ✓ flight reservation systems ✓ computerized parts inventory systems
From a technical standpoint, DBMSs can differ widely. The terms relational, network, flat, and hierarchical all refer to the way a DBMS organizes information internally. The internal organization can affect how quickly and flexibly you can extract information.
Introduction
A database consists of four elements as given, 1. Data 2. Relationships 3. Constraints 4. Schema
1) Data ➢ Data are binary computer representations of stored logical entities. ➢ Software is divided into two general categories-data and programs. ➢ A program is a collection of instruction for manipulating data. ➢ Data exist is various forms- as numbers tents on pieces of paper, as bits and bytes stored in electronic memory or as facts stored in a persons mind.
2) Relationships ➢ Relationships explain the correspondence between various data elements.
3) Constraints ➢ Are predicates that define correct database states.
4) Scheme ➢ Schema describes the organization of data and relationships within the database. ➢ Schema defines various views of the database for the use of various system components of the database management system and for the application’s security. ➢ A schema separates physical aspects of data storage form the logical aspects of data representation.
[pic]
Types of schema ➢ Internal schema: defines how and where the data are