FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 2: The Relational Model 1: Introduction, QBE, and Relational Algebra

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Essay

Review LaterAdd Note

Review Later

List the six properties that define a relation in a two-dimensional table.

Correct Answer

verified

A relation is a two-dimensional table in...

View Answer

Show Answer

Question 22

True/False

Review LaterAdd Note

Review Later

The primary key of a table is the row or rows that uniquely identify a given column in that table.

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

In relational algebra, what command causes only certain columns to be included in the new table?

Which operation will allow you to extract data from more than one table?

Which term is another word for a row in a table?

Which of the following is true if two tables have the same number of columns and their corresponding columns represent the same type of data?

The compound criteria (conditions) are created by using which of the following two keywords?

What is the difference between an AND criterion and an OR criterion?

The concept of grouping means that statistics will be calculated for individual records.

What type of query changes data?

The field on which records are sorted is called the composite primary key.

The relational operators are +, *, %, and /.

A column whose value uniquely identifies a given row in the table is the secondary key.

Based on the tables below, which command creates a new table named CustSales that combines the Customer and SalesPerson tables based on SalesPersonNum??Customer (CustomerNum, CustomerName, Street, City, State, PostalCode, SalesPersonNum) ?SalesPerson (SalesPersonNum, LastName, FirstName)

When some of the entries in a structure contain repeating groups and thus are not single-valued, the structure is called a(n) ____________________.

Which of the following is the column or collection of columns that uniquely identifies a given row in that table?

A query is a question represented in a way that the DBMS can recognize and process.

How do you refer to a column named State in a table named Client?

In the Access Query window, the upper portion of the window contains the design grid.

The attributes of an entity become the fields or columns in a table.