Flat-file+database+versus+relational+database

Flat File Database Design vs. Relational Database Design

Flat file database dsign

A flat file database design is a database designed around a single table. The flat file design puts all database information in one table or list. For feilds to represent all parameters. A flat file may contain many feilds, often, with duplicate data that are prone to data corruption.

Designing flat file databases is simple and requires very little knowledge. Flat files can developed using just about any database system. Flat file databases can be created in relational database engines by not taking advantages of relational design concepts. Designing a Flat file databse takes less time than designing a relational database. media type="youtube" key="vAA1VVExV5Q" height="305" width="510"

Relational Database

A relational database, however, incorporates multiple tables together with methods for the tables to work together. the relationships between table data can be collated, merged, and displayed in database forms. Most relational databases offer functionality to share data :


 * Across networks
 * Over the internet
 * With laptops and other electronic devices, such as palm pilots.
 * With other software systems

Relational Databases allow you to define certain record feilds, as keys or indexes, to perform search queries, join table records and establish integrity constraints. media type="youtube" key="1GK3aGqTMDk" height="303" width="509"