Database Management Composition

Database Management

Introduction to Database software management System

Objective

This unit will cover next topics:

5. Definition of a database.

2. Difference among relational database and file system. * Features of Relational Database.

* Tools for retaining and finding data from a relational database. On the completion of this kind of unit the learner will be able to: * В Differentiate between a database and file system.

Introduction to Database

A database is known as a collection of related information. For example , a mobile phone book can be described as database of names, details and cell phone numbers. В В

A data file is known as a single drive file that stores related information on a difficult disk or perhaps floppy diskette. For example , a phone publication database can be stored in just one data record. В В

A Database Management System (DBMS) is known as a software tool that facilitates creating, maintaining, and manipulating an information database. The two types of DBMS software program are:

2. Relational

5. Flat data file

Relational Databases Software

Relational database software program allows the user to work with several database files at the same time and share information throughout the files. В For example , to implement an accounting database system, В one requires relational capabilities to link together information that may be stored in the differentВ files. В An example of a relationalВ database software can be Microsoft Gain access to, Oracle, Sybase and В Paradox. В

Flat-file Database Software

A flat-file database plan, allows you create many databases but lets them work withВ only one record at a time. Using a flat -file database system, one can produce simple applications such as email list databases or perhaps personnel files. Advantages of the database strategy over traditional file-processing devices В

Pursuing are some of the huge benefits of utilizing a database over the traditional file-processing system: 2. Potential for enforcing standards.

2. Flexibility.

* Reduced app development period.

*...