COMPUTER SCIENCE AND ENGINEERING
DATA STRUCTURES
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Attribute and Entity
|
|
Entity Set
|
|
Field
|
|
Record
|
Detailed explanation-1: -Entity and Attributes are two essential terms of a database management system (DBMS). The main difference between the Entity and an attribute is that an entity is a real-world object, and attributes describe the properties of an Entity. The Entity may be tangible or intangible.
Detailed explanation-2: -An entity set is a collection of similar types of entities. An entity set may contain entities with attribute sharing similar values. For example, a Students set may contain all the students of a school; likewise a Teachers set may contain all the teachers of a school from all faculties.
Detailed explanation-3: -An entity type is described by a set of attributes called “schema". The set of entities pertaining to a particular entity type share the same set of attributes.
Detailed explanation-4: -For instance, PERSON denotes the entities of an entity-set with attributes NAME and AGE, while ASSIGNED denotes the relationships between the entities of entity-sets PERSON and PROJECT. Attributes take their values from underlying primitive domains called value-sets.