This topic contains a solution. Click here to go to the answer

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

ETearle

  • Hero Member
  • *****
  • Posts: 580
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
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
Wow, this really help


diana chang

  • Member
  • Posts: 288
Reply 3 on: Yesterday
Excellent

 

Did you know?

Excessive alcohol use costs the country approximately $235 billion every year.

Did you know?

Your heart beats over 36 million times a year.

Did you know?

In the United States, there is a birth every 8 seconds, according to the U.S. Census Bureau's Population Clock.

Did you know?

In the United States, an estimated 50 million unnecessary antibiotics are prescribed for viral respiratory infections.

Did you know?

It is believed that humans initially contracted crabs from gorillas about 3 million years ago from either sleeping in gorilla nests or eating the apes.

For a complete list of videos, visit our video library