3.Database

In simplest terms a Database is a vessel that store data. In actuality it is some form of a computer file. A simple Notepad file (.txt) can be used to store some data. Same is true for Microsoft Excel file or Microsoft Access file. Such kind of Database is called "Flat File" Database due to its flat structure and inability to hold any relation between data entities. With growth in volume and complexity of data soon this model was also outgrown to a Relational Database.

A Relational database is a database which allows the relations among data entities. e.g. you want to sore Customers and their Addresses. In a flat file database model the only way to do this is to store them together side by side in the same file. But in a relational database they can be stored in different files but can still maintain the relationship. The major work for relational database was done by Edgar F. Codd and all relational databases follow his 12 rules to varying degrees.

A Relational Database is the highest level of technology available in Data Storage to date. It is basically a collection of files which help store, retrieve and change information easily while still maintaining relationships among data entities. It can be kept secure, replicated and shared easily. You still with me?




Watch Your Bottom Line Improve In Just 30 Days!
Amazing new Invoice and Expense software does all the work for you.
TooLERP Screen Shot

Esitmates
Invoices
Receipts
Expenses
Liabilities
Reports

Windows Linux Mac
MySQL Ruby Apache
Simple and Easy
Download and Unzip
TooLERP Box