Introduction to Database software management System
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:
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.
* Reduced app development period.