- Database 1 Project Part 1 Design Er Diagram For A Pizza Place Database Your Er Diagram Should Include The Following 1 1 (87.56 KiB) Viewed 29 times
My dear friend, I ask you to solve all the parts completely and
correctly, and I do not want duplicate answers
Take full time dear sir Thank you very much.
I need full Answer .
Database 1 Project Part 1 Design ER Diagram for a pizza place database, your ER Diagram should include the following: 1- Branches 2- Employees 3- Customers 4- Pizza 5- Ingredients 6- orders • Think of attributes and relationships that you need to have in your ER Diagram. • Your ER diagram should include entities, attributes, relationship and cardinality constraints. Part 2 Map the ER diagram into relations. The outcome schema should have: Relations Primary key/ Foreign Key connections Part 3 1- Using Oracle SQLPlus, create tables that represent your schema. 2- Make sure to represent the primary keys/Foreign Keys in your DB. 3- Insert few records in each table. 4- Write a select statement that finds orders done by customer "Ahmad". 5- Write a select statement that finds orders for pizza "BBQ Chicken". 6- Write a select statement that finds ingredients for each pizza type.