DBMS Basics - Interview Questions and Answers

The collections of entities of a particular entity type are grouped together into an entity set.

An entity set may not have sufficient attributes to form a primary key, and its primary key compromises of its partial key and primary key of its parent entity, then it is said to be Weak Entity set.

It is a particular property, which describes the entity.

A relation Schema denoted by R(A1, A2, ..., An) is made up of the relation name R and the list of attributes Ai that it contains. A relation is defined as a set of tuples. Let r be the relation which contains set tuples (t1, t2, t3, ..., tn). Each tuple is an ordered list of n-values t=(v1,v2, ..., vn).

It is the number of attribute of its relation schema.

It is an association among two or more entities.