Let a and b be relations with the schemas A (name, address, title) and B(name, address, salary), respectively. Show how to express a natural full outer join b using the full outer join operation with an on condition and the coalesce operation. Make sure that the result relation does not contain two copies of the attributes name and address, and that the solution is correct even if some tuples in a and b have null values for attributes name or address.
Answer to relevant QuestionsGive an SQL schema definition for the employee database of Figure. Choose an appropriate domain for each attribute and an appropriate primary key for each relationschema.Consider the relational database of Figure where the primary keys are underlined. Give expressions in QBE for each of the following queries:a. Find all employees who earn more than the average salary of all employees of ...Describe how an arbitrary Data log rule can be expressed as an extended relational algebra view.Consider a view branch-cust defined as follows: create view branch-cust as select branch-name, customer-name from depositor, account where depositor.account-number = account.account-number Suppose that the view is ...Explain what is meant by repetition of information and inability to represent information. Explain why each of these properties may indicate a bad relationaldatabase design.
Post your question