COMPUTER APPLICATIONS
DATABASE MANAGEMENT SYSTEMS
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: -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-2: -Difference Chart In the relational data model, an entity is represented as a record in an entity set. In the relational data model, a field represents an attribute. A row in a database table is an entity.
Detailed explanation-3: -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.
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.