DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Record
|
|
|
Primary Key
|
|
|
Table
|
|
|
Field
|
Detailed explanation-1: -The correct answer is Field. The columns in the tables are called fields. A field contains a specific piece of information within a record.
Detailed explanation-2: -At the top of each column in a table, a column designation/head is given to explain the figures of the column. This column heading is known as ‘caption’.
Detailed explanation-3: -A column is a list of values, usually belonging to a particular field, displayed vertically in a table. In a relational database table, values within a column each correspond to a different record. Values in a column share a data type.
Detailed explanation-4: -Columns (really column names) being referred to as field names (common for each row/record in the table). Then a field refers to a single storage location in a specific record (like a cell) to store one value (the field value).
Detailed explanation-5: -Fields are basically columns in a table with specific information about the data.