Business Logic

Overview

At its core, the Print Shepherd site requires database interactions to support ecommerce transactions. This includes creating and maintaining data relating to customers, products, and orders.

Components

• Database: Print Shepherd runs on a MySQL 8.0 database (Production)
• Database Management Software: The MySQL database can be managed via phpMyAdmin
• Workflow: Primary database manipulation is completed through WordPress CMS.
• Triggers: The site provides product details through queries to product tables, customers have the option to create accounts to review purchase status/history, orders are created upon product purchases, customers can create product reviews, and products are created through WordPress/WooCommerce CMS.

Entity Relationship Diagram (ERD)