Analysis and Specification (Database Design) for Web App

Job ID: 34594549

Budget: $250 – $750 AUD

Looking for assistance to develop the following design artifacts for a database for a web application:

Information Flow Diagram (IFD)
Enhanced Entity-Relationship (EER) Diagram
Data Types
Business Logic Constraints (logic which cannot be reflected in the EER model)
Task Decomposition (TD): rules of thumb/oval diagrams- both single and decomposed
Abstract Code (AC) pseudo-code: input validation/error handling, how to navigate between tasks

Emphasis is on the EER and AC components. Please note EER surrogate keys should not be used on the EER diagram. Also the EER should not be auto-generated by any tool such as MySQL workbench, use crows-feet notation, or deviates from the notation supplied in the example attached.

It's preferable that for EER be supplied via draw.io or LucidCharts.

Project specification is attached, please review to determine specifics of the requirements of these artifacts.