The Curiosity Shop Data Model

March 5, 2022  The Curiosity Shop is expanding its database applications to include a simplified inventory system and employee and customer data storage. Management would like to see an entity-relationship diagram that establishes a blueprint for the new design. The shop has provided sample tables for Sales and Purchased Items with some overlapping columns and […]

Fab Flowers Ordering and Delivery System: Data Flow Diagrams

September 19, 2021 Fab Flowers’ fleet of 500 vehicles delivers gifts and flowers to customers in seven states. Several steps occur for this complicated ordering and delivery system to work smoothly.  A data flow diagram (DFD) is a visual flow chart that defines the data flows, processes, and stores involved in managing a multi-state operational […]