In what ways does the relational model favor data retrieval over modification? S

Question

Explanation / Answer

The relational model is based on branches of mathematics called set theory and predicate logic. The basic idea behind the relational model is that a database consists of a series of unordered tables (or relations) that can be manipulated using non-procedural operations that return tables. This model was in vast contrast to the more traditional database theories of the time that were much more complicated, less flexible and dependent on the physical storage methods of the data. It is commonly thought that the word relational in the relational model comes from the fact that you relate together tables in a relational database. The relational model can be applied to both databases and database management systems (DBMS) themselves. The benefits of a database that has been designed according to the relational model are numerous. Some of them are: -> Data entry, updates and deletions will be efficient. -> Data retrieval, summarization and reporting will also be efficient. -> Since the database follows a well-formulated model, it behaves predictably. -> Since much of the information is stored in the database rather than in the application, the database is somewhat self-documenting. -> Changes to the database schema are easy to make. The relational model is centered on the idea that: the organization of data into collections of two-dimensional tables called “relations.” Originally, the relational data model was developed for databases — that is, information stored over a long period of time in a computer Database system — and for database management systems, the software that allows people to store, access, and modify this information. Hope it helps you understand about the relational model and its usgae.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.