Q. How many types of keys in Database Design?

View solution

Q. The minimal set of super key is called

View solution

Q. Foreign key is the one in which the ________ of one relation is referenced in another relation.

View solution

Q. Domain constraints, functional dependency and referential integrity are special forms of _________.

View solution

Q. Which one of the following uniquely identifies the elements in the relation?

View solution

Q. A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.

View solution

Q. Which one of the following attribute can be taken as a primary key ?

View solution

Q. Which one of the following cannot be taken as a primary key ?

View solution

Q. A attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation .

View solution

Q. The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as primary key is called

View solution

Q. The ______ is the one in which the primary key of one relation is used as a normal attribute in another relation .

View solution

Q. A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.

View solution

Q. Row is synonymous with the term:

View solution

Q. The primary key is selected from the:

View solution

Q. Which of the following is a group of one or more attributes that uniquely identifies a row?

View solution

Q. A relation is considered a:

View solution

Q. In the relational model, relationships between relations or tables are created by using:

View solution

Q. Table is synonymous with the term:

View solution

Q. Which of the following is not a restriction for a table to be a relation?

View solution

Q. A key:

View solution