COMPUTER APPLICATIONS
DATABASE MANAGEMENT SYSTEMS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Field
|
|
|
Attribute
|
|
|
Column
|
|
|
Tuple
|
|
|
Entity
|
Detailed explanation-1: -A row, or record, is also known as a tuple. The columns in a table is a field and is also referred to as an attribute.
Detailed explanation-2: -In a relational database, a tuple contains all the data for an individual record. For example, in a database containing client contact information, the fields may be categories such as name, phone number, email address and mailing address, while a tuple for that database could be: Bill Gates. 206-555-1234.
Detailed explanation-3: -The relational data model represents a table of values (or data table). Each row of the table, therefore, represents a collection of related data values and hence typically corresponds to real world entity or relationship. Formally, a row is called a tuple.