Question

Map the E-R diagram and relational schema.
Joe's Pizzeria keeps track of its EMPLOYEES, ORDERS, PIZZERIAS (locations), MENU ITEMS, and
INGREDIENTS.
For each employee, Joe's Pizzeria keeps track of unique employee id and employee name.
For each order, Joe's Pizzeria keeps track of unique order number, Date/Time (date and time
combined) of each order, and the amount of the order.
For each pizzeria, Joe's Pizzeria keeps track of unique pizzeria ID, address, and manager.
For each menu item, Joe's Pizzeria keeps track of unique item ID and item name.
For each ingredient, Joe's Pizzeria keeps track of unique SKU number, ingredient name, brand name,
and supplier.
Each pizzeria has at least one employee; an employee works at exactly one pizzeria.
An employee can process many orders but doesn't need to process any. Each order can only be
processed by one employee.
Each order occurs at (at most) one pizzeria. A pizzeria must have at least one order occur there.
An order must sell at least one menu item. A menu item can be sold in many orders, but need not be
sold in any
A menu item is made with one or more ingredients; an ingredient is used to make one or more menu
items.​

Answer 1

Answer:

sorry too long and don't know

Explanation:

please mark me as brainliest and vote me and thank my answer also follow me please