Asked in
Database Programming
Database Design

Advantages and disadvantages of relational database system?


User Avatar
Wiki User
December 18, 2014 4:37AM

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 .

User Avatar
Wiki User
November 09, 2008 7:34PM

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.