Download Project Databases Report Pizzeria Ordering System

Transcript
25
ingredients
from the
database
Employee adds
ingredients to
the database
Add
ingredients
ingredients
from the
database
Employee
adds
ingredients to
the database
ingredients
-Employee views
ingredients
Employee logs in
-Employee goes to
ingredients
-Employee adds
ingredients
- Add new Ingredient
26
Employee
deletes
ingredients
from the
database
Deletes
ingredients
Employee
deletes
ingredients
from the
database
Employee logs in
-Employee goes to
ingredients
-Employee deletes
ingredients
- Delete Ingredient
Where IngredientId is Ingredient
to be deleted
27
Employee edits
ingredients
from the
database
Edits
ingredients
Employee
edits
ingredients
from the
database
Employee logs in
-Employee goes to
ingredients
-Employee edits
ingredients
- Update Ingredient
Where IngredientId is Ingredient
to be edited
28
Employee
views non pizza
products from
the database
Views non
pizza products
Employee
adds non pizza
products to the
database
Employee logs in
-Employee goes to
non pizza products
-Employee views
non pizza products
- Select NonPizza
29
Employee adds
non pizza
products to the
database
Adds non pizza Employee
products
adds non pizza
products to the
database
-Employee logs in
-Employee goes to
non pizza products