State the difference between the following:
a. Union and Intersection
b. product and join
c. selection and projection
a. The Union operation on two tables returns all rows from both the tables,
but it does not repeat the duplicate rows. The Intersection operation on
two table returns rows that exist in both tables involved.
b. A product of two table matches every row from the first table to each
and every row in the second table. The join operation on two tables joins
rows from two tables based on a common attribute, and the rows with
same common attribute value are joined to each other.
c. The Selection operation on a table returns rows that satisfy the supplied
criteria. The projection operation returns the attributes specified from a
table.
You might also like to view...
Which of the following allows you to establish a secure connection to a corporate network?
A. IDS B. VPN C. IPS D. DMZ
Run the man ls > ~/linux/ls.man command on your system. This command will put the man page for the ls command in the ls.man file in your ~/linux directory. Give the command for printing two copies of this file on a printer in your lab. What command did you use?
What will be an ideal response?