DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Column
|
|
|
Key
|
|
|
Row
|
|
|
Entry
|
Detailed explanation-1: -A in a table represents a relationship among a set of values. Explanation: Column has only one set of values. Keys are constraints and row is one whole set of attributes. Entry is just a piece of data.
Detailed explanation-2: -A relation is a relationship between sets of values. In math, the relation is between the x-values and y-values of ordered pairs. The set of all x-values is called the domain, and the set of all y-values is called the range.
Detailed explanation-3: -A table relationship is represented by a relationship line drawn between tables in the Relationships window.
Detailed explanation-4: -Each row in a table represents a set of related data, and every row in the table has the same structure. For example, in a table that represents companies, each row would represent a single company.
Detailed explanation-5: -In a relational database, each row in the table is a record with a unique ID called the key. The columns of the table hold attributes of the data, and each record usually has a value for each attribute, making it easy to establish the relationships among data points.