Consider the following

(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.

Consider the following 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. 1) Indicate the primary keys (by underlying) 2) Indicate the foreign keys (using arrows). 3) Write The DDL queries for all relations