Briefly explain each of the following database terms. Use no more than 2-3 lines for each term.
1. Deletion Anomaly
2. Domain Constraint
(B)
Research Question.
The Join operation in SQL joins the data for from two table to make one intermediate table. Join expressions can be complex with multiple conditions to control the joining of tupples. In addition to standard joins, there are also specialiased Joins available.
For this task, you have to find out what a "Right Join" is.
There are two parts requires in your answer.
• First describe what a Right Join does and what output it produces.
• Second is to given an example of when a right join woud be useful.
Note that you do not need to write any SQL to answer this question.
In most cases, you should be able to complete this question in a couple of paragraphs. Any answer over half a page long will attract a deduction. There is no requirement to supply references for this question. Database Concepts Study Period 2 Assignment 2 Page 3 of 8 Due : 11:59, Sunday