You have just been hired as database designer to implement a Wholesale Management System Database Project which needs to meet the following requirements (items 1 - 9). Design and create tables as you deem appropriate.

Your stakeholders are not DB designer, hence; they do not all the details of a DB. Thus, at times you might have to add your own components or fields to make sense of the tables and the queries you are creating.

Your success is measured by how well you implement each of the required elements based on what we have learned in this course.

Here are the requirements provided by the stakeholders (the wholesaler company):

1. Maintain the details of stocks (all products) like their ID, product name, quantity in stock, unit price, etc (Table: Stock)
2. Create or import your own data for tables when needed
3. Maintain the details of company product buyers who are tasked with purchasing required stocks. Data fields like buyer ID, first name, last name, and personal address including city, state, and zip code. (at least 5 records) (Table: Buyers)
4. Details of 10 - 15 clients/customers i.e., client ID, organization's name, complete address (Table: Clients)
5. List of defaulters/delinquent customers who have not paid their balance, include client ID, organization's name and the pending balance (Query: Delinquents)
6. List of all payments paid or pending, include client ID, organization's name, order ID, total amount for each order, amount paid for each order and the status field indication either paid or int fully paid (Query: Payment Status)
7. The stock that buyers, for the company, need to order for the business entity, if quantity falls below 10 units for each single item, include buyer ID, first and last names, product name, and the manufacturer or supplier of that product (Query: Low Stock)
8. Profit calculation for a month, include month and sum of total for each month fields (Query: Monthly profit)
9. Create a form displaying all the information of each customer with their photos (Form: Customer Profile)