You are tasked to design a new Customer Management System $($CMS$)$ for a small independent local outdoor store.

The CMS system allows the store owner to manage the store's inventory $($CRUD $($Create$,$ Read, Update & Delete$)).$ The store inventory is stored in a

separate Inventory SQL Database server $($ISQLDB$)$ that communicates with the CMS system. Before posting the inventory, the CMS system cross

reference all inventory data with the distributor's database system in order to provide accurate product information. Then, the CMS system exports

store inventory into the store's brick mortar Point of Sales System and the store's website.

Store managers executes a "Sales Analytics Report" with the CMS system twice a month. From the report, the CMS system generates a unique $5\%-$

$15\%$ unique coupon code that are targeted towards specific customer segments. The coupon code is attached to the bi monthly store e$-$newsletter that

is emailed to the store's subscribers $($you need to be a customer in order to subscribe to the e$-$newsletter$).$ The CMS system must have a feature to

enable store managers to prepare a bi monthly e$-$newsletter with good quality content. All customer info is store in the Customer SQL Database server

$($CSQLDB$)$ and accessible to the CMS system.

Another store manager's job is to generate a weekly Sales Performance Report for both brick mortar store and the website sales. For this functionality,

the CMS system imports all sales data from the store's brick mortar Point Of Sales System and the WebSales SQL Database server $($WSSQLDB$)$ that

stores all online sales transaction.

The CMS system also has a social media component that allows the store owner, store managers and store employees to upload social media

contents$($pictures$,$ comments, hashtags$).$ The CMS system then automatically post all the social media contents o the store's designated Instagram and

Facebook accounts. The CMS system also allows the store owners, store managers and store employees to write blog posts that will automatically be

uploaded to the store's website.