Advantages and disadvantages of relational database system?

Answer 1

A pivotal setup in designing a relation database is to design the relations making up the database. Although this might appear to be a simple task, many subtleties are waiting to trap the unwary designer. The Advantages to using a relational database system:

You use tables to create the relation. Inside the tables are primary and alternative keys.

The primary keys create the relation between the tables with the alternative keys. The disadvantage: You can lose information if the keys over lap in the requests made by the creator. Sometimes this is true and sometimes it is not. SQL is a type of database, is called structure query language. Which commonly is know to form the structure of the backbone for most relations database query systems. The popularity of this language is because the American Standard Institute standardized it. Another reason is that it was originally developed and marketed by IBM and has thus benefited from a high level of exposure.

Answer 2

A relational database is one that defines relationship between the tables. A relation database maintain data integrity and non redundancy. Due to complexity in relation there is a overhead while searching and processing .

Answer 3

Advantages: Provides data consistency, allows for data integrity constraints, supports complex queries for data analysis, and offers scalability through normalization.

Disadvantages: Can be complex to design and maintain, may not be as efficient for certain types of data structures like hierarchies or graphs, could experience performance issues with large datasets, and can be more rigid in terms of data structure compared to other database systems.