Co-Authored By:
Asked by: Añes Saanen
technology and computing databasesWhat are the advantages of relational database model?
Keeping this in view, what are the advantages of relational model?
Advantages of using Relationalmodel This can improve the performance of the model.Query capability: It makes possible for a high-level query languagelike SQL to avoid complex database navigation. Data independence:The structure of a database can be changed without having to changeany application.
Simply so, what are the advantages of using a relational database?
The other important advantages of relationaldatabases include their performance, power, and support to newhardware technologies, as also flexibility and a capacity to meetall types of data needs. These databases are scalableand provide support for the implementation of distributedsystems.
Below are some of the characteristics of relationaldatabases and the relational model.
- The use of keys. Each row of data in a table is identified by aunique "key", called the primary key.
- Avoiding data redundancy.
- Constraining the input.
- Maintaining data integrity.
- Rights.
- Structured Query Language (SQL)
- Portability.