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

Author Question: Parenthesis represent an optional element in the data dictionary. Indicate whether the statement ... (Read 51 times)

ETearle

  • Hero Member
  • *****
  • Posts: 580
on: Jul 7, 2018
Parenthesis represent an optional element in the data dictionary.
 
  Indicate whether the statement is true or false

Question 2

Briefly explain the difference between an inner and an outer join.
 
  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

morganmarie791

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

TRUE

Answer to Question 2

Inner joins return all the related tables from the two tables involved in the join. They do not return any records that do not have a related record. Outer joins return all the records from one of the tables in the join even if they do not have a related record in the other table. In the second table only the related records are returned.


ETearle

  • Member
  • Posts: 580
Reply 2 on: Jul 7, 2018
Thanks for the timely response, appreciate it

Liddy

  • Member
  • Posts: 342
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

In most cases, kidneys can recover from almost complete loss of function, such as in acute kidney (renal) failure.

Did you know?

When intravenous medications are involved in adverse drug events, their harmful effects may occur more rapidly, and be more severe than errors with oral medications. This is due to the direct administration into the bloodstream.

Did you know?

Glaucoma is a leading cause of blindness. As of yet, there is no cure. Everyone is at risk, and there may be no warning signs. It is six to eight times more common in African Americans than in whites. The best and most effective way to detect glaucoma is to receive a dilated eye examination.

Did you know?

Recent studies have shown that the number of medication errors increases in relation to the number of orders that are verified per pharmacist, per work shift.

Did you know?

Patients who have undergone chemotherapy for the treatment of cancer often complain of a lack of mental focus; memory loss; and a general diminution in abilities such as multitasking, attention span, and general mental agility.

The carbon cycle. Numbers are storage as 1015 g or fluxes as 1015 g per year (data from Schlesinger The carbon cycle. Numbers are storage as 1015 g or fluxes as 1015 g per year (data from Schlesinger
Extent of agricultural activity across the planet (data from Foley et al. 2005). Extent of agricultural activity across the planet (data from Foley et al. 2005).
Graphing Psychological Data Graphing Psychological Data
data data
Type III curve. Mortality is highest early in life. Data for a desert shrub (Cleome droserifolia). Type III curve. Mortality is highest early in life. Data for a desert shrub (Cleome droserifolia).
Satellite data showing net primary production. Productivity is coded as red (highest) down through o Satellite data showing net primary production. Productivity is coded as red (highest) down through o
Video: What is an ecosystem?

For a complete list of videos, visit our video library