MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

DATABASE MANAGEMENT SYSTEM

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
For each attribute of a relation, there is a set of permitted values, called the ____ of that attribute.
A
Domain
B
Relation
C
Set
D
Schema
Explanation: 

Detailed explanation-1: -“The set of permitted values for each attribute is called domain” or “A domain is referred to in a relation schema by the attribute name and has a set of associated values”. A domain D is a set of atomic values. By Atomic we mean that each value in the domain is individual as far as the relational model is concerned.

Detailed explanation-2: -Attributes take their values from underlying primitive domains called value-sets.

Detailed explanation-3: -The set of all possible values of data items is called domain. A relational table’s column structure is defined by a domain.

Detailed explanation-4: -Database Topic 11-A domain is defined as the set of all unique values permitted for an attribute.

Detailed explanation-5: -A row, or record, is also known as a tuple. The columns in a table is a field and is also referred to as an attribute.

There is 1 question to complete.