COMPUTER SCIENCE AND ENGINEERING
DATABASE MANAGEMENT SYSTEM
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Field
|
|
|
Foreign key
|
|
|
Record
|
|
|
Primary key
|
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 table relationship is represented by a relationship line drawn between tables in the Relationships window.
Detailed explanation-3: -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-4: -A row is a single group of related data within a table. Relational databases contain tables with rows and columns (also known as records and fields, respectively). Columns are vertical, and hold a list of values all from the same field. Rows are your horizontal elements in a table.
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.