# Question

Design a relational database corresponding to the E-R diagram ofFigure.

## Answer to relevant Questions

In Chapter we saw how to represent many-to-many, many-to-one, one-tomany, and one-to-one relationship sets. Explain how primary keys help us to represent such relationship sets in the relational model.Using the bank example, write relational-algebra queries to find the accounts held by more than two customers in the following ways:a. Using an aggregate function.b. Without using any aggregate functions.Let R = (A, B) and S = (A, C), and let r(R) and s(S) be relations. Write relational-algebra expressions equivalent to the following domain-relationalcalculus expressions: a. {< a > | ∃ b (< a, b >∈ r ∧ b = ...Let R = (A, B, C), and let r1 and r2 both be relations on schema R. Give an expression in SQL that is equivalent to each of the following queries. a. r1 ∪ r2 b. r1 ∩ r2 c. r1 − r2 d. II AB(r1) 1 ...Give 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.Post your question

0