This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: Suppose tables EMPLOYEE and CUSTOMER both store address information, and you want to send a letter ... (Read 51 times)

geoffrey

  • Hero Member
  • *****
  • Posts: 880
on: Jul 7, 2018
Suppose tables EMPLOYEE and CUSTOMER both store address information, and you want to send a letter to all employees and customers of your company to make a major announcement. Which SQL keyword would you most likely use here?
 
  A) INTERSECT
  B) UNION
  C) UNION ALL
  D) JOIN

Question 2

Explain the terms relation, tuple, and attribute.
 
  What will be an ideal response?


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

hramirez205

  • Sr. Member
  • ****
  • Posts: 345
Reply #1 on: Jul 7, 2018
Answer to Question 1

B

Answer to Question 2

The terms relation, tuple, and attribute are used primarily by database theoreticians. These terms are synonymous with the terms table, row, and column, respectively, in regards to a relational database. They are also equivalent to the terms file, record, and field, which tend to be used by many traditional data processing professionals.


geoffrey

  • Member
  • Posts: 880
Reply 2 on: Jul 7, 2018
Wow, this really help

scikid

  • Member
  • Posts: 300
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

The most dangerous mercury compound, dimethyl mercury, is so toxic that even a few microliters spilled on the skin can cause death. Mercury has been shown to accumulate in higher amounts in the following types of fish than other types: swordfish, shark, mackerel, tilefish, crab, and tuna.

Did you know?

More than 34,000 trademarked medication names and more than 10,000 generic medication names are in use in the United States.

Did you know?

According to the CDC, approximately 31.7% of the U.S. population has high low-density lipoprotein (LDL) or "bad cholesterol" levels.

Did you know?

Most strokes are caused when blood clots move to a blood vessel in the brain and block blood flow to that area. Thrombolytic therapy can be used to dissolve the clot quickly. If given within 3 hours of the first stroke symptoms, this therapy can help limit stroke damage and disability.

Did you know?

Though Candida and Aspergillus species are the most common fungal pathogens causing invasive fungal disease in the immunocompromised, infections due to previously uncommon hyaline and dematiaceous filamentous fungi are occurring more often today. Rare fungal infections, once accurately diagnosed, may require surgical debridement, immunotherapy, and newer antifungals used singly or in combination with older antifungals, on a case-by-case basis.

Everyday situations sometimes present opportunities for children to build information processing ... Everyday situations sometimes present opportunities for children to build information processing ...
Examples of four letter formats: (A) block style, (B) modified block style, (C) modified block style ... Examples of four letter formats: (A) block style, (B) modified block style, (C) modified block style ...
The vehicle emissions control information (VECI) sticker is placed under the hood. The vehicle emissions control information (VECI) sticker is placed under the hood.
The driver information display on a Chevrolet Impala with a 5.3 liter V-8 equipped with active fuel ... The driver information display on a Chevrolet Impala with a 5.3 liter V-8 equipped with active fuel ...
A form that the customer should fill out if there is a driveablilty concern to help the service ... A form that the customer should fill out if there is a driveablilty concern to help the service ...
The flow of genetic information in a typical cell The flow of genetic information in a typical cell
Video: Double Vacuum Process (Illustration No Audio)

For a complete list of videos, visit our video library