COMPUTER SCIENCE AND ENGINEERING
DATABASE MANAGEMENT SYSTEM
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
A field is all of the information about one person or one thing
|
|
A field is the collection of all the database records on one topic or subject
|
|
A field is one type or piece of information
|
|
None of the above
|
Detailed explanation-1: -Fields are the components that provide structure for a table. You can’t have a table without fields. For instance, you can create an empty table that has fields defined but no rows (records). In databases, fields are used to maintain relationships between tables.
Detailed explanation-2: -Relational databases use tables to store information. The standard fields and records are represented as columns (fields) and rows (records) in a table. With a relational database, you can quickly compare information because of the arrangement of data in columns.
Detailed explanation-3: -A data field represents an attribute (a characteristic or quality) of some entity (object, person, place, or event). Record-a record represents a collection of attributes that describe a real-world entity. A record consists of fields, with each field describing an attribute of the entity.