Consider the following E$/$R$,$ in which a person prefers a certain coffee at a specific coffee

shop. For example, Dakota prefers the Latt$$ at Starbucks and the Cappuccino at

Caribou$$s$.$Consider the following $\frac{E}{R},$ in which a person prefers a certain coffee at a specific coffee

shop. For example, Dakota prefers the Latte at Starbucks and the Cappuccino at

Caribou's.

We wish to convert the above ER diagram to its relational Database scheme.

Indicate the primary keys $($by underlying$)$

Indicate the foreign keys $($using arrows$).$

Write The DDL queries for all relations.