Search your topic here

Domains

DOMAIN

A domain is defined as the set of all unique values permitted for an attribute. The domain of a database attribute is the set of all allowable values for that attribute.

Example:

A field for gender may have the domain {male, female, unknown} where those three values are the only permitted entries in that column.

A domain of date is the set of all possible valid dates.

A domain of integer is all possible whole numbers.

A domain of day-of-week is Monday, Tuesday ... Sunday.




Read more from DBMS...

DATABASE MANAGEMENT SYSTEM

Unit 1: DATABASE CONCEPTS


Unit 2: DATA MODELS

Unit 3: DATABASE DESIGN CONCEPTS & NORMALIZATION

Unit 4: INTRODUCTION TO SQL

LEAVE A REPLY










Related topics

Please use contact page in this website if you find anything incorrect or you want to share more information about the topic discussed above.