Question

What is relational data model? write advantages and disadvantages of relational data model.​

Answer 1

$\sf{ANSWER}$

$\sf\large\underline{Relational\:Data\:Model-}$

• This is the most widely used data base model that represents data as well as relationship among  data in the form of tables.
• It looks like a file. Constraints are stored in a meta-data table. This is a very simple model and is  based on a proven mathematical theory.
• Most relational data bases have high-level query languages and support a limited form of user  views. Usually, the conceptual and internal schemas are not distinguishable, and a single DDL is  used to describe all aspects of the database structure.

$\sf\large\underline{Advantages\:of\:Relational\:Data\:Model-}$

• The relational data model can be implemented with a personal computer having limited main  memory and processing capability.
• Very effective for small databases.
• Much easier to use because it enables a computer system to accommodate a variety of enquiries in  an efficient manner.
• Very easy to represent the logical relationship among the data items since it use primary key to  represent record relationships instead of pointers.
• Relational model is very useful for representing most of the real world objects and the relationships  among them.

$\sf\large\underline{Disvantages\:of\:Relational\:Data\:Model-}$

• In this model, as the size of the database increases, several problems may come into existence –  system slowdown, performance degradation and data corruption.