1: A: Map the following ER to a minimum number of relational tables. Note that t

Question

1: A: Map the following ER to a minimum number of relational tables. Note that the mangles represent dependency (ie,, E1 and E3 depend on E2). B: For the database in 1A, write a SQL statement that returns the column f for those values of a that are 5. 2: A: Map the ER diagram to a minimum set of relational tables. In mapping inheritance, generate the subtype tables only. B: Write a SQL statement that returns the name of all customers and the balance of their account customers who have a banker named Jones.

Explanation / Answer

1B: select * from E3 where f="5";

2B: select name, balance from person, account where person.id=account.id and banker_name="Jones";

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.