Why do we designate one of the candidate keys of a relation to be the primary key? Discuss the characteristics of relations that make them different from ordinary tables and files.

Relational Model of Data

Define the following terms as they apply to the relational model of data: domain, attribute, n-tuple, relation schema, relation state, degree of a relation, relational database schema, and relational database state.

Why are tuples in a relation not ordered?

Why are duplicate tuples not allowed in a relation?

What is the difference between a key and a superkey?

Why do we designate one of the candidate keys of a relation to be the primary key?

Discuss the characteristics of relations that make them different from ordinary tables and files.

Discuss the various reasons that lead to the occurrence of NULL values in relations.

Discuss the entity integrity and referential integrity constraints. Why is each considered important?

Define foreign key. What is this concept used for?

What is a transaction? How does it differ from an Update operation?

Why do we designate one of the candidate keys of a relation to be the primary key? Discuss the characteristics of relations that make them different from ordinary tables and files.