Question

what is the difference between flat database and relational database

Answer 1

Answer:

Explanation: A flat file database stores data in a single tables structures. A relational database uses multiple referencing record between tables. Table in bath organise records in rows, with each coluncolumn containing a single piece of data in the record.

Answer 2

The differences between flat database and relational database are:

• Flat database is used to store and keep the data in one single table structure whereas the data is stored in multiple tables in a relational database.
• Through several software applications the flat database can be easy but only RDBMS (Relational Database Management System) can be used in a relational database to access the data.

• Flat database is not complicated and very easy to use and it is portable as well but it is not as efficient and powerful as a relational database.

• Flat database is used by small organizations while the relational database is used by large organizations.