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 […]

Hullabaloo Party Supplies Order System: The SDLC Process

October 10, 2021 Hullabaloo Party Supplies (HPS) provides and distributes party supplies, operating out of 13 nationwide locations. After considering the advantages of shifting markets from business-to-business to business-to-consumer, management has decided to design an online ordering system to accommodate the new need.  The software development lifecycle (SDLC) consists of five main elements crucial to […]

Business Intelligence/Business Analytics System Implementation

August 1, 2021 This was one of my early essays in management information systems.  I chose to evaluate a small web agency business.  According to the article, Business Intelligence vs. Business Analytics by Harvard Business Analytics Program (2018), business intelligence is “the use of data to manage day-to-day operational management within a business” (para. 3). […]

A Study of Profitability Ratios

December 5, 2021 Three things an organization needs to prove to investors, lenders, and shareholders are  1) profitability, 2) liquidity, and 3) solvency. We do these measurements with a series of ratios obtained through close analysis of the balance sheet and income statement. Each ratio tells a different part of the whole story. Analysts look […]