What is the difference between an attribute and a domain?
Database Management System > DBMS Data Models > ER Diagrams
3411
Answer:
The attributes are the properties of an entity that characterize and describe it. Figure below shows the BOOK
entity b1
described by the attributes Book_title, Price
(in dollars), ISBN, Year, Page_count
and Category.
Each attribute can accept a value from a set of permitted values, which is called the domain or the value set of the attribute. For example, the domain of the attribute Page_count
is a set of positive integers. On the other hand, the category of a book can be a textbook, a language book or a novel. Thus, the domain of the attribute Category
is {Textbook, Language book, Novel}. Only one of these three permitted values can be assigned to the category attribute.
This Particular section is dedicated to Question & Answer only. If you want learn more about Database Management System. Then you can visit below links to get more depth on this subject.
Join Our telegram group to ask Questions
Click below button to join our groups.