This unit will cover following topics:
* Definition of a database.
* Difference between relational database and file system. * Advantages of Relational Database.
* Tools for maintaining and retrieving data from a relational database. At the completion of this unit the learner will be able to : * Differentiate between a database and file system.
Introduction to Database
A database is a collection of related information. For example, a phone book is a database of names, addresses and phone numbers.
A data file is a single disk file that stores related information on a hard disk or floppy diskette.For example, a phone book database would be stored in a single data file.
A Database Management System (DBMS) is a software tool that facilitates creating, maintaining, and manipulating an information database. The two types of DBMS software are:
* Flat file
Relational Database Software
Relational database software allows the user to work with several database files at the same time and share information across the files. For example, to implement an accounting database system, one requires relational capabilities to link together information that is stored in the different files. An example of a relational database software would be Microsoft Access, Oracle, Sybase and Paradox.
Flat-file Database Software
A flat-file database program, allows the user to create many databases but lets him/her work with only one file at a time. Using a flat -file database program, one can create simple applications such as mailing list databases or personnel files. Advantages of the database approach over traditional file-processing systems
Following are some of the advantages of using a database over a traditional file-processing system: * Potential for enforcing standards.
* Reduced application development time.