COMPUTER SCIENCE AND ENGINEERING
DATABASE MANAGEMENT SYSTEM
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
An attribute is a table in a database and an entity is a field
|
|
|
An attribute is a record in a database and an entity is a table
|
|
|
An attribute is a field in a database and an entity is a table
|
|
|
None of the above
|
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 type typically corresponds to one or several related tables in database. Attribute. A characteristic or trait of an entity type that describes the entity, for example, the Person entity type has the Date of Birth attribute.
Detailed explanation-3: -Sometimes, the terms “field” and “attribute” are used interchangeably, and for most purposes, they are the same. However, field describes a particular cell in a table found on any row, and attribute describes an entity characteristic in a design sense.
Detailed explanation-4: -Entity Definition : Provides row-based access to metadata about standard and custom objects. Field Definition: Represents a standard or custom field, providing row-based access to field metadata.
Detailed explanation-5: -An entity resides in a table, it is a single set of information, i.e: if you have a database of employees, then an employee is an entity. A table is a group of fields with certain parameters. Basically everything is stored in a table, entities goes into tables.