What is differentiate between the flat file and database?
Answers
Difference Between Flat File & Relational Database. A flat file database stores data in a single table structure. ... Tables in both organize records in rows, with each column containing a single piece of data in the record. Table structures in databases organize data in rows and columns.
Answer:
flat file database
it is relative li a simple database system which stores all the data in a single table...a flat file refers to a data file that contains records which have a small fixed number of fields without any structured relationships example MS Excel
relation database
a relation database is a type of database that stores data in several tables..these tables are related to one another in such a way that whenever there is a need the data can be joined and information can be accessed from them at once....the relationship between the different tables can be defined by their common fields...the main advantage of using relational database is that we are not required to enter repetitive information in tables again and again which in turn saves time example oracle, base , MS access , Sybase , MS SQL....