a) E. F. Codd proposed a Relational data model that presents the database as a set of Relations.

Question

Define the following relational terms and comment on the differences between these terms and the way that data is represented in a flat file.
i) Tuple;

ii) Attribute;

iii) Domain;

iv) Relation;

v) Primary Key.

b) Logical/Physical data independence is an important characteristic supported by a Relational database system.
Explain why Logical and Physical data independence is important.

c) Concurrency control of transactions is another important characteristic supported by a Relational database system.
Describe the so-called ACID properties of transactions and explain why they are important in concurrency control.

Leave an answer

Sorry, you do not have permission to answer to this question .