Explain the basic results that come from the restrict, project, and join functions.

What will be an ideal response?


A restrict extracts selected rows from a table-records that satisfy prescribed conditions-to create a new table.
A project extracts selected attributes (columns) from a table to create a new table.
A join builds a new table, from two existing tables, by matching rows on a value of a common attribute.

PTS: 1

Computer Science & Information Technology

You might also like to view...

Which layer does wireless communication rely heavily upon?

A. MAC sublayer of the Network layer B. MAC sublayer of the Data Link layer C. LLC sublayer of the Data Link layer D. LLC sublayer of the Transport layer

Computer Science & Information Technology

How does the unified device model facilitate kernel support for hot swappable devices?

What will be an ideal response?

Computer Science & Information Technology

A physical music CD is an example of intellectual property.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

The first U.S. law to define computer trespass is:

a. Federal Information Security Management Act b. Sarbanes-Oxley Act c. Computer Fraud and Abuse Act d. Computer Misuse Act

Computer Science & Information Technology