COMPUTER SCIENCE AND ENGINEERING
DATABASE MANAGEMENT SYSTEM
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Domain
|
|
|
Relation
|
|
|
Set
|
|
|
Schema
|
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.