draw an er diagram with rhe informtion provided. Entities:Beach Coffee CartsCoffee ShopsProducts (Iced coffee, flavors, creamers, breakfast items, etc.)SalesSuppliesWarehouseEmployees Attributes could include:For Beach Coffee Carts and Coffee Shops: Location, Street, Shop Name, etc.For Products: Product ID, Name, Type, Price, etc.For Sales: Transaction ID, Date and Time, Product(s) Sold, Quantity, Employee ID, etc.For Supplies: Supply ID, Name, Quantity, Location, Supplier, etc.For Warehouse: Warehouse ID, Location, Storage capacity, etc.For Employees: Employee ID, Name, Role, Sales Performance, etc. RelationshipsBeach Coffee Carts and Coffee Shops have a "Location" relationship with Sales.Products are sold in Sales transactions.Supplies are stored in the Warehouse.Employees have a "Role" relationship with the type of work they do.Employees are associated with Sales transactions

An Entity Relationship (ER) Diagram can be defined in such a way that it is a type of flowchart that…

Answered: draw an er diagram with rhe informtion…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Concept explainers

Question

draw an er diagram with rhe informtion provided.

Entities:

Beach Coffee Carts
Coffee Shops
Products (Iced coffee, flavors, creamers, breakfast items, etc.)
Sales
Supplies
Warehouse
Employees

Attributes could include:

For Beach Coffee Carts and Coffee Shops: Location, Street, Shop Name, etc.
For Products: Product ID, Name, Type, Price, etc.
For Sales: Transaction ID, Date and Time, Product(s) Sold, Quantity, Employee ID, etc.
For Supplies: Supply ID, Name, Quantity, Location, Supplier, etc.
For Warehouse: Warehouse ID, Location, Storage capacity, etc.
For Employees: Employee ID, Name, Role, Sales Performance, etc.

Relationships

Beach Coffee Carts and Coffee Shops have a "Location" relationship with Sales.
Products are sold in Sales transactions.
Supplies are stored in the Warehouse.
Employees have a "Role" relationship with the type of work they do.
Employees are associated with Sales transactions

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-engineering and related others by exploring similar questions and additional content below.

Recommended textbooks for you

Computer Networking: A Top-Down Approach (7th Edi…

Computer Engineering

ISBN:

9780133594140

Author:

James Kurose, Keith Ross

Publisher:

PEARSON