Crows foot notation and uml class diagram notation notationthe chen notation model
Conceptual Design
There are different entity-relationship models (ERM) that could be used for the Cougar Pizza Pie database design. However, the various ERM’s should be assessed for their design applicability in relevance to the database design. Below are examples of Chen’s Notation, Crow’s Foot Notation and UML Class Diagram Notation.
Crow's Foot Notation
Crow’s Foot Notation represent entities as boxes, and relationships as lines between the boxes. Different shapes at the ends of these lines represent the cardinality of the relationship.
Data Sets
Entities: Customer, Orders, Employees, Sales, PizzaOrdered, PizzaType, Toppings, DeliveryStatus
CustomerLastName Customer last name
CustomerPhone Customer phone number
Orders Orders placed by customers.
OrderID (PK) ID for each order
TakeoutDateTime Date and time of take out order
PickupDateTime Date and time of order pick up
PizzaOrdered Pizza order for customer.
OrderID (PK) ID for each order
PizzaTypeCode (PK) Code for type of pizza ordered
PizzaTypePrice Price of each type of pizza
ToppingsNumber (PK) Sequence number of toppings to be put on pizza
ToppingsCode Code for each topping
TotalSalesID Total Sales
Hour Hourly sales
Dependency Diagrams