Differentiate between Flat File Database and Relational database. Give example for both. | question and answer !
Question:-
Differentiate between Flat File Database and Relational database. Give example for both.
Answer:-
Flat File Database:- It is relatively a simple database system which stores all the data in a single table. A flat file refers to data files that contain records which have a small, fixed number of fileds, without any structured relationships. E.g., MS excel.
Relational Database:- A relational 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 fileds. The main advantages of using a relational database is that we are not required to enter repetitive in tables again and again, which in turn saves time. E.g., Oracle, base, ms access, sybase, MS SQL.
Differentiate between Flat File Database and Relational database. Give example for both.
Answer:-
Flat File Database:- It is relatively a simple database system which stores all the data in a single table. A flat file refers to data files that contain records which have a small, fixed number of fileds, without any structured relationships. E.g., MS excel.
Relational Database:- A relational 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 fileds. The main advantages of using a relational database is that we are not required to enter repetitive in tables again and again, which in turn saves time. E.g., Oracle, base, ms access, sybase, MS SQL.
No comments