Question

Differentiate between flat file and relational database.

Answer 1

Answer:

flat file database is a database designed around a single table. it store and retrieve information but do not linked different tables together. the flat file design puts all database information in one table only with field to represent all parameters for example MS Excel 2nd relational database a relational database stores the data in several tables and link those tables together to get a common piece of information. it links tables together, so that different information from different tables can be assessed easily. it also reduces duplicity of data. for example Microsoft access, Microsoft SQL, Oracel.