Discuss the types of relational databases and their advantages Essay

Discuss the types of relational databases and their advantages - Essay Example In this scenario, the Join function is used to unite relations, the project operation is performed to identify attributes and the select queries are performed for accessing data. However, like other database models, a relational database also supports several other functions such as insert, update and delete (Oak, 2011). In relational databases, normalization plays a very important role. In addition, the relational activities, facilitated by the relational databases work in an excellent way with normalized tables. Additionally, relational databases support dynamic views, which is an important concept of databases. Though, in a relational database, a view is not acknowledged as an element of the physical design, since it is dynamic. In addition, views can divide data, combine and shorten several unnecessary relations, which reduce the data storage requirements. Another important advantage of relational database is that it uses SQL that is a simple and human-readable language (Oak, 2011). Moreover, relational databases offer an excellent security because they support access permissions, which facilitate the database administrator to apply need-based permissions in order to get access to the data stored in database tables. Furthermore, relational databases offer high level performance, power, and facilities to latest hardware technologies as well as a capability to deal with all types of data and users requirements (Oak,