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