explain any 3 differences between flat file and relational?
chapter - database
class 10th
please don't spam
Answers
Answer:
The answer is:
Explanation:
Flat file Database
⦿A flat-file database is a database stored in a file called a flat file.
⦿Records follow a uniform format, and there are no structures for indexing or recognizing relationships between records.
⦿Relationships can be inferred from the data in the database, but the database format itself does not make those relationships explicit.
Relational Database
⦿A relational database is a collection of information that organizes data points with defined relationships for easy access.
⦿In the relational database model, the data structures -- including data tables, indexes and views.
⦿It remain separate from the physical storage, allowing administrators to edit the physical data storage without affecting the logical data structure.
Please mark me as brainliest.
(((((1st)))))
A relational database is one that contains multiple tables of data that relate to each other through special key fields. Relational databases are far more flexible (though harder to design and maintain) than what are known as flat file databases, which contain a single table of data.
(((((2nd)))))
Flat file database:—A flat file database is a database designed around a single table.It stores and retrieves information but do not link different tables together.The flat file design puts all database information in one table or list,with fields to represent all parameters for example MS Excel.
(((((3rd)))))
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 and Oracle