-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Aug 29, 2025 at 03:03 PM
-- Server version: 8.0.42
-- PHP Version: 8.2.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `ihub`
--

-- --------------------------------------------------------

--
-- Table structure for table `accepted_proposals`
--

CREATE TABLE `accepted_proposals` (
  `id` int NOT NULL,
  `full_name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `business_idea_title` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `phone` varchar(15) COLLATE utf8mb4_general_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `accepted_proposals`
--

INSERT INTO `accepted_proposals` (`id`, `full_name`, `business_idea_title`, `phone`, `email`) VALUES
(10, 'ARKO SETH ESSEL ', 'THE FARMER\'S FRIEND', '0242220351', 'arkosethessel@gmail.com '),
(11, 'Blay, David ', '2 in 1 Organic fertilizer and pesticide ', '0592226550', 'blaykakudavid@gmail.com'),
(12, 'Dabuu Daniel Mckeown', 'Mckeown Global Company Limited', '0541446681', 'ddmckeown1@gmail.com'),
(13, 'Joel Nana Kwamina Otuu ', 'Waste Wealth Composting ', '0501849333', 'quashiejoel80@gmail.com'),
(14, 'Francis Baah Ofosuhene', 'E-Learning Platform for Parents with Children from Early Childhood to High School', '0555690392', 'fb.ofosuhene@gmail.com'),
(15, 'WISDOM AWUMEY', 'Happily', '0546687530', 'wisdomawumey@gmail.com'),
(22, 'Blay, David ', '2 in 1 Organic fertilizer and pesticide ', '0592226550', 'blaykakudavid@gmail.com'),
(23, 'Solomon Bonney', 'BREADYSHOP LTD(fish and food processing)', '0244091707', 'solomonbonney20@gmail.com '),
(24, 'Daniel Appianing ', 'KAD Fish Farms: Sustainable Fish Farming for the Future ', '0544904311', 'danielappianing43@gmail.com'),
(25, 'Isaac Arthur', 'PLASTIGEM', '0540796861', 'isaacart18@gmail.com'),
(26, 'Kporxah George ', 'God and Glory Tomatoes Factory ', '0542200615', 'kporxahgeorge@gmail.com'),
(27, 'Bismark Dwamena Augustine ', 'Mini importation Pre-Order', '0553030454', 'bismarkdwamena8080@gmail.com'),
(28, 'Dankwah Godfred ', 'Freeman Palm Tree Planting and Palm Oil Production', '0550430920', 'Dankwahgodfred47@gmail.com'),
(29, 'Sika Kove And Ezekiel Kwandoh', 'BotaniCalm ,A natural soother for burns, scars and acnes', '0549501995', 'koveblaise222@gmail,com'),
(30, 'Farouk Nuhhu Billa', 'The entrepreneur using modern day innovation ideas, technology to discount Pension?s Retirement benefits for the Ghanaian worker through PENSION SOLUTION SERVICES.', '0244579151', 'virginvestment@gmail.com'),
(35, 'Nii Barnor jonathan', 'None ', '0243658609', 'niibarnorjonathan@gmail.com'),
(36, 'Dr. Dza', 'None ', '0559615170', 'mdza@uew.edu.gh ');

-- --------------------------------------------------------

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int NOT NULL,
  `username` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `username`, `password`) VALUES
(1, 'admin', '$2y$10$D2D6N4/SXzJLPNymAvV.IuTfDE00K51UIZvIlj5MhzN4vIIHSQdrS'),
(2, 'admin1', '$2y$10$ET.4YE4iKpNmd4w4bkONiefhlhRJn0o0AO0Mqk0Wgff6RUOAFNWQO');

-- --------------------------------------------------------

--
-- Table structure for table `assessments`
--

CREATE TABLE `assessments` (
  `id` int NOT NULL,
  `proposal_id` int NOT NULL,
  `assessor_id` int NOT NULL,
  `idea_novelty` int NOT NULL,
  `idea_breakthrough` int NOT NULL,
  `idea_competitors` int NOT NULL,
  `idea_technology_solution` int NOT NULL,
  `idea_novel_future` int NOT NULL,
  `market_need` int NOT NULL,
  `market_problem` int NOT NULL,
  `market_present_future` int NOT NULL,
  `market_share` int NOT NULL,
  `market_risk` int NOT NULL,
  `market_timing` int NOT NULL,
  `return_resources` int NOT NULL,
  `return_profit` int NOT NULL,
  `return_investors` int NOT NULL,
  `return_team_capacity` int NOT NULL,
  `advantage_competitors` int NOT NULL,
  `advantage_better` int NOT NULL,
  `advantage_protectable` int NOT NULL,
  `impact_sdg` int NOT NULL,
  `impact_jobs` int NOT NULL,
  `remarks` text COLLATE utf8mb4_general_ci,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `assessments`
--

INSERT INTO `assessments` (`id`, `proposal_id`, `assessor_id`, `idea_novelty`, `idea_breakthrough`, `idea_competitors`, `idea_technology_solution`, `idea_novel_future`, `market_need`, `market_problem`, `market_present_future`, `market_share`, `market_risk`, `market_timing`, `return_resources`, `return_profit`, `return_investors`, `return_team_capacity`, `advantage_competitors`, `advantage_better`, `advantage_protectable`, `impact_sdg`, `impact_jobs`, `remarks`, `created_at`) VALUES
(11, 2, 5, 2, 2, 2, 1, 1, 4, 2, 4, 3, 2, 2, 3, 3, 1, 4, 1, 1, 1, 1, 3, NULL, '2024-08-05 21:26:19'),
(12, 13, 5, 2, 1, 2, 0, 2, 2, 3, 2, 2, 1, 1, 3, 2, 1, 3, 3, 2, 1, 3, 2, NULL, '2024-08-06 15:18:20'),
(13, 14, 5, 3, 4, 4, 4, 3, 3, 4, 4, 4, 4, 5, 5, 4, 5, 3, 4, 4, 3, 4, 3, NULL, '2024-08-06 15:22:01'),
(14, 6, 9, 1, 1, 1, 1, 1, 2, 2, 2, 2, 3, 2, 3, 3, 2, 3, 4, 3, 5, 4, 4, NULL, '2024-08-06 15:23:56'),
(15, 25, 5, 3, 3, 2, 2, 3, 2, 3, 2, 2, 2, 0, 4, 3, 2, 3, 1, 1, 1, 4, 4, NULL, '2024-08-06 15:27:07'),
(16, 26, 5, 4, 4, 3, 3, 3, 4, 4, 4, 4, 4, 3, 4, 4, 4, 3, 4, 4, 4, 5, 4, NULL, '2024-08-06 15:30:55'),
(17, 9, 9, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 3, 1, 2, 2, 2, 3, NULL, '2024-08-06 15:38:25'),
(18, 32, 5, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, NULL, '2024-08-06 15:59:29'),
(19, 3, 6, 3, 2, 2, 2, 2, 2, 2, 2, 2, 3, 3, 1, 1, 2, 2, 3, 3, 1, 3, 3, NULL, '2024-08-06 16:38:41'),
(20, 12, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2024-08-06 16:40:34'),
(21, 15, 6, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 3, 1, 1, 1, 2, 3, NULL, '2024-08-06 16:43:20'),
(22, 27, 6, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NULL, '2024-08-06 16:45:19'),
(23, 33, 6, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 3, 2, 2, 3, 1, 1, 2, 2, 2, NULL, '2024-08-06 16:48:23'),
(24, 39, 6, 3, 3, 3, 3, 2, 3, 3, 3, 3, 3, 3, 3, 3, 3, 4, 2, 3, 3, 3, 3, NULL, '2024-08-06 16:52:47'),
(25, 45, 6, 1, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 3, 3, 2, 4, 1, 1, 1, 1, 3, NULL, '2024-08-06 16:55:48'),
(26, 51, 6, 1, 2, 2, 2, 2, 1, 2, 2, 2, 2, 2, 3, 3, 2, 4, 1, 2, 2, 2, 3, NULL, '2024-08-06 16:58:41'),
(27, 57, 6, 1, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 1, 1, 2, 4, 1, 1, 1, 2, 3, NULL, '2024-08-06 17:01:13'),
(28, 63, 6, 3, 4, 3, 4, 3, 3, 4, 4, 4, 4, 4, 4, 4, 4, 5, 3, 4, 3, 4, 4, NULL, '2024-08-06 17:05:00'),
(29, 70, 6, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 3, NULL, '2024-08-06 17:06:53'),
(30, 76, 6, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 2, 3, 3, 3, 4, 2, 2, 2, 3, 3, NULL, '2024-08-06 17:10:26'),
(31, 82, 6, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 2, 4, 3, 2, 4, 2, 2, 1, 1, 3, NULL, '2024-08-06 17:12:15'),
(32, 88, 6, 1, 1, 1, 1, 1, 1, 1, 3, 2, 2, 2, 4, 3, 2, 2, 1, 1, 1, 2, 3, NULL, '2024-08-06 17:14:37'),
(33, 94, 6, 4, 4, 4, 4, 3, 4, 4, 4, 3, 4, 4, 4, 4, 4, 5, 3, 3, 3, 4, 4, NULL, '2024-08-06 17:19:22'),
(34, 101, 6, 3, 3, 3, 3, 2, 3, 3, 4, 4, 4, 4, 4, 4, 4, 5, 3, 3, 3, 4, 4, NULL, '2024-08-06 17:23:28'),
(35, 18, 9, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, NULL, '2024-08-06 20:00:35'),
(36, 21, 9, 2, 2, 1, 1, 1, 2, 2, 2, 2, 2, 1, 2, 1, 1, 2, 2, 2, 2, 2, 2, NULL, '2024-08-06 20:30:07'),
(37, 24, 9, 2, 2, 2, 2, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 3, 2, NULL, '2024-08-06 20:39:30'),
(38, 30, 9, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 3, 2, NULL, '2024-08-06 20:57:07'),
(39, 36, 9, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 1, 2, 2, 2, NULL, '2024-08-06 21:01:53'),
(40, 42, 9, 2, 3, 2, 1, 2, 3, 2, 3, 2, 3, 3, 3, 3, 2, 2, 2, 2, 2, 3, 3, NULL, '2024-08-06 21:16:13'),
(41, 48, 9, 2, 2, 2, 2, 2, 3, 3, 3, 2, 2, 2, 2, 3, 3, 2, 2, 2, 3, 3, 3, NULL, '2024-08-06 21:25:32'),
(42, 54, 9, 3, 3, 3, 2, 2, 3, 2, 2, 2, 2, 2, 3, 2, 2, 2, 3, 3, 2, 4, 3, NULL, '2024-08-06 21:40:23'),
(43, 60, 9, 2, 2, 2, 2, 2, 0, 2, 3, 2, 2, 2, 3, 3, 3, 2, 2, 2, 3, 4, 4, NULL, '2024-08-06 21:51:37'),
(44, 67, 9, 2, 2, 2, 2, 2, 3, 2, 3, 2, 2, 1, 2, 2, 1, 2, 1, 1, 1, 2, 2, NULL, '2024-08-06 22:02:13'),
(45, 73, 9, 4, 4, 4, 4, 4, 4, 4, 4, 4, 3, 3, 2, 3, 4, 3, 4, 3, 3, 4, 4, NULL, '2024-08-06 22:16:24'),
(46, 79, 9, 3, 3, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 3, 2, 2, 4, 3, NULL, '2024-08-06 22:28:17'),
(47, 85, 9, 1, 1, 1, 1, 1, 2, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 3, 3, NULL, '2024-08-06 22:35:11'),
(48, 91, 9, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2, 2, 2, NULL, '2024-08-06 22:46:01'),
(49, 97, 9, 3, 3, 2, 2, 2, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 2, 2, 4, 4, NULL, '2024-08-06 22:55:18'),
(50, 98, 9, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 2, 1, 1, 1, 2, 2, NULL, '2024-08-06 23:08:01'),
(51, 104, 9, 2, 2, 1, 1, 1, 1, 1, 2, 1, 1, 1, 2, 2, 1, 2, 1, 1, 2, 2, 2, NULL, '2024-08-06 23:20:15'),
(52, 38, 5, 3, 3, 2, 2, 3, 3, 3, 4, 3, 4, 3, 4, 3, 3, 3, 3, 3, 2, 3, 3, NULL, '2024-08-07 05:40:44'),
(53, 50, 5, 1, 1, 1, 1, 1, 3, 2, 2, 1, 2, 2, 3, 3, 1, 3, 1, 1, 1, 1, 2, NULL, '2024-08-07 05:43:36'),
(54, 56, 5, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, NULL, '2024-08-07 05:54:42'),
(55, 62, 5, 2, 3, 2, 2, 2, 3, 3, 4, 3, 3, 3, 3, 4, 3, 3, 3, 3, 2, 4, 3, NULL, '2024-08-07 05:57:56'),
(56, 69, 5, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 4, 3, 2, 3, 2, 2, 2, 4, 2, NULL, '2024-08-07 06:01:31'),
(57, 75, 5, 2, 2, 2, 2, 1, 3, 3, 3, 2, 3, 2, 3, 2, 2, 2, 2, 2, 1, 4, 2, NULL, '2024-08-07 08:33:05'),
(58, 81, 5, 4, 3, 3, 4, 2, 4, 4, 3, 3, 3, 4, 4, 3, 3, 4, 4, 3, 5, 4, 3, NULL, '2024-08-07 08:36:15'),
(59, 87, 5, 4, 4, 4, 4, 2, 4, 3, 4, 4, 3, 3, 4, 4, 4, 3, 4, 4, 4, 3, 3, NULL, '2024-08-07 08:38:09'),
(60, 93, 5, 2, 2, 2, 2, 2, 2, 2, 2, 1, 2, 1, 3, 2, 1, 2, 2, 2, 3, 2, 2, NULL, '2024-08-07 08:47:54'),
(61, 100, 5, 3, 3, 2, 3, 3, 3, 2, 2, 3, 2, 1, 3, 2, 3, 2, 2, 2, 2, 3, 2, NULL, '2024-08-07 08:55:13'),
(62, 44, 5, 2, 2, 2, 2, 2, 3, 3, 2, 2, 3, 2, 3, 2, 2, 2, 2, 2, 2, 2, 2, NULL, '2024-08-07 09:06:25'),
(63, 7, 10, 2, 2, 1, 2, 2, 3, 2, 2, 2, 3, 2, 3, 3, 3, 4, 2, 2, 2, 2, 3, NULL, '2024-08-07 11:44:38'),
(64, 99, 10, 3, 3, 3, 2, 3, 3, 3, 3, 3, 3, 3, 4, 3, 3, 4, 4, 3, 2, 2, 3, NULL, '2024-08-07 11:48:29'),
(65, 92, 10, 4, 4, 4, 3, 4, 4, 4, 4, 3, 4, 5, 4, 4, 4, 4, 3, 4, 2, 4, 4, NULL, '2024-08-07 11:52:12'),
(66, 8, 10, 3, 3, 4, 3, 3, 3, 4, 3, 3, 3, 3, 2, 2, 3, 3, 3, 3, 2, 3, 4, NULL, '2024-08-07 11:55:51'),
(67, 20, 10, 3, 3, 2, 2, 3, 2, 3, 2, 3, 3, 3, 3, 3, 3, 2, 3, 3, 2, 2, 3, NULL, '2024-08-07 11:58:32'),
(68, 19, 10, 2, 2, 2, 2, 2, 3, 4, 3, 3, 3, 3, 4, 3, 3, 4, 3, 3, 2, 2, 3, NULL, '2024-08-07 12:00:49'),
(69, 31, 10, 4, 4, 4, 2, 3, 4, 3, 3, 3, 2, 3, 1, 3, 3, 1, 3, 3, 4, 4, 5, NULL, '2024-08-07 12:03:32'),
(70, 80, 10, 3, 3, 2, 2, 3, 3, 3, 3, 3, 3, 4, 3, 3, 3, 3, 3, 3, 2, 3, 4, NULL, '2024-08-07 12:09:11'),
(71, 86, 10, 4, 4, 4, 4, 5, 4, 4, 5, 4, 3, 4, 4, 4, 4, 3, 4, 3, 4, 4, 5, NULL, '2024-08-07 12:13:55'),
(72, 68, 10, 3, 3, 3, 2, 2, 2, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 2, 3, NULL, '2024-08-07 12:16:00'),
(73, 61, 10, 3, 3, 3, 3, 3, 3, 3, 4, 3, 3, 3, 3, 3, 3, 4, 2, 3, 2, 3, 3, NULL, '2024-08-07 12:19:24'),
(74, 43, 10, 3, 3, 4, 3, 3, 3, 3, 4, 3, 4, 4, 5, 4, 3, 5, 4, 3, 3, 5, 3, NULL, '2024-08-07 12:21:56'),
(75, 37, 10, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 2, 3, 2, 3, 3, NULL, '2024-08-07 12:23:24'),
(76, 49, 10, 3, 3, 3, 3, 3, 3, 3, 3, 3, 4, 3, 5, 4, 4, 4, 3, 3, 3, 3, 3, NULL, '2024-08-07 12:25:14'),
(77, 55, 10, 2, 1, 2, 2, 2, 2, 2, 2, 1, 1, 2, 2, 2, 3, 1, 2, 2, 1, 2, 4, NULL, '2024-08-07 12:26:44'),
(78, 4, 7, 1, 2, 1, 2, 1, 2, 3, 2, 2, 2, 2, 3, 2, 2, 2, 3, 2, 2, 2, 2, NULL, '2024-08-07 18:32:41'),
(79, 11, 7, 3, 3, 4, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 2, 3, 3, 3, 3, 3, NULL, '2024-08-08 08:17:17'),
(80, 16, 7, 3, 2, 3, 2, 3, 2, 3, 3, 3, 2, 3, 3, 2, 3, 2, 3, 2, 3, 3, 3, NULL, '2024-08-08 08:19:03'),
(81, 22, 7, 2, 3, 3, 2, 3, 3, 2, 3, 2, 3, 3, 3, 2, 3, 2, 3, 2, 2, 3, 2, NULL, '2024-08-08 08:20:34'),
(82, 28, 7, 3, 4, 3, 4, 4, 4, 3, 4, 3, 3, 4, 4, 3, 3, 4, 4, 3, 4, 3, 4, NULL, '2024-08-08 08:21:36'),
(83, 34, 7, 2, 3, 2, 3, 3, 3, 3, 3, 2, 3, 3, 3, 2, 3, 3, 3, 2, 3, 3, 3, NULL, '2024-08-08 08:22:41'),
(84, 40, 7, 2, 1, 1, 2, 2, 2, 3, 2, 2, 2, 2, 2, 3, 1, 2, 2, 2, 2, 2, 3, NULL, '2024-08-08 08:23:50'),
(85, 46, 7, 2, 2, 1, 2, 2, 2, 2, 2, 3, 2, 2, 2, 2, 2, 2, 2, 3, 2, 2, 2, NULL, '2024-08-08 08:24:41'),
(86, 52, 7, 3, 2, 3, 3, 2, 2, 3, 2, 3, 3, 2, 3, 3, 2, 3, 3, 3, 2, 2, 3, NULL, '2024-08-08 08:26:00'),
(87, 5, 8, 2, 2, 2, 2, 2, 2, 1, 1, 1, 1, 1, 3, 2, 1, 4, 1, 1, 1, 1, 4, NULL, '2024-08-08 08:26:19'),
(88, 58, 7, 3, 3, 4, 3, 3, 3, 3, 4, 4, 4, 3, 4, 3, 4, 3, 4, 4, 3, 4, 4, NULL, '2024-08-08 08:28:54'),
(89, 10, 8, 2, 2, 2, 3, 2, 1, 1, 2, 2, 2, 2, 4, 3, 3, 3, 3, 3, 3, 3, 2, NULL, '2024-08-08 08:29:53'),
(90, 64, 7, 3, 4, 3, 4, 4, 3, 3, 4, 4, 3, 4, 3, 4, 4, 4, 3, 3, 4, 4, 4, NULL, '2024-08-08 08:30:51'),
(91, 65, 7, 3, 3, 4, 4, 4, 4, 3, 4, 4, 3, 3, 3, 4, 4, 4, 3, 4, 4, 3, 3, NULL, '2024-08-08 08:32:07'),
(92, 17, 8, 2, 2, 2, 4, 3, 2, 2, 2, 2, 2, 2, 3, 3, 3, 4, 2, 2, 2, 3, 3, NULL, '2024-08-08 08:32:41'),
(93, 71, 7, 2, 3, 3, 3, 3, 3, 2, 3, 3, 2, 3, 3, 3, 2, 2, 3, 2, 3, 2, 3, NULL, '2024-08-08 08:33:48'),
(94, 23, 8, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NULL, '2024-08-08 08:33:54'),
(95, 29, 8, 2, 1, 1, 4, 1, 1, 1, 1, 1, 1, 1, 5, 3, 2, 2, 2, 3, 3, 2, 2, NULL, '2024-08-08 08:35:37'),
(96, 35, 8, 1, 1, 2, 2, 2, 3, 2, 3, 2, 2, 2, 3, 3, 1, 2, 3, 3, 3, 3, 5, NULL, '2024-08-08 08:37:13'),
(97, 41, 8, 2, 1, 2, 2, 2, 1, 1, 2, 2, 2, 2, 2, 2, 2, 2, 1, 1, 1, 2, 2, NULL, '2024-08-08 08:42:15'),
(98, 77, 7, 3, 2, 3, 3, 3, 3, 2, 3, 3, 2, 3, 3, 3, 2, 3, 3, 2, 3, 3, 3, NULL, '2024-08-08 08:43:58'),
(99, 47, 8, 1, 2, 2, 2, 2, 2, 1, 2, 2, 2, 2, 3, 2, 2, 3, 3, 3, 2, 1, 2, NULL, '2024-08-08 08:45:20'),
(100, 83, 7, 3, 3, 3, 2, 3, 3, 4, 2, 2, 3, 3, 3, 2, 3, 2, 3, 2, 4, 3, 2, NULL, '2024-08-08 08:45:44'),
(101, 89, 7, 2, 3, 2, 2, 3, 3, 2, 2, 2, 3, 3, 3, 2, 2, 2, 3, 3, 2, 2, 3, NULL, '2024-08-08 08:47:01'),
(102, 53, 8, 3, 3, 2, 3, 3, 2, 3, 4, 4, 4, 4, 1, 5, 5, 4, 4, 4, 4, 4, 4, NULL, '2024-08-08 08:48:31'),
(103, 95, 7, 4, 3, 4, 4, 3, 3, 4, 3, 3, 4, 3, 3, 4, 4, 3, 4, 4, 4, 3, 3, NULL, '2024-08-08 08:48:43'),
(104, 102, 7, 2, 3, 3, 2, 3, 3, 2, 2, 3, 2, 2, 3, 3, 2, 3, 2, 2, 3, 3, 3, NULL, '2024-08-08 08:49:43'),
(105, 59, 8, 3, 2, 3, 3, 2, 2, 2, 3, 2, 2, 3, 3, 3, 3, 2, 3, 3, 3, 3, 3, NULL, '2024-08-08 08:52:12'),
(106, 66, 8, 3, 2, 2, 2, 2, 5, 5, 4, 3, 3, 2, 5, 4, 4, 5, 5, 4, 3, 3, 4, NULL, '2024-08-08 09:00:41'),
(107, 72, 8, 1, 1, 2, 2, 2, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 2, 1, 2, 2, 3, NULL, '2024-08-08 09:03:01'),
(108, 78, 8, 2, 2, 2, 2, 2, 2, 2, 0, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1, 1, NULL, '2024-08-08 09:04:02'),
(109, 84, 8, 4, 5, 4, 5, 5, 3, 3, 3, 2, 2, 3, 3, 2, 3, 4, 4, 2, 5, 5, 4, NULL, '2024-08-08 09:07:44'),
(110, 90, 8, 2, 1, 1, 1, 1, 2, 2, 1, 1, 1, 2, 4, 4, 4, 3, 2, 3, 3, 3, 4, NULL, '2024-08-08 09:09:35'),
(111, 96, 8, 4, 4, 5, 0, 3, 3, 3, 4, 4, 4, 4, 2, 4, 4, 5, 5, 4, 4, 4, 2, NULL, '2024-08-08 09:17:09'),
(112, 103, 8, 1, 1, 2, 2, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 2, NULL, '2024-08-08 09:18:30');

-- --------------------------------------------------------

--
-- Table structure for table `assessors`
--

CREATE TABLE `assessors` (
  `id` int NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `area` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `contact` varchar(15) COLLATE utf8mb4_general_ci NOT NULL,
  `username` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `assessors`
--

INSERT INTO `assessors` (`id`, `title`, `name`, `area`, `contact`, `username`, `password`) VALUES
(5, 'Dr.', 'Jonathan Nii Barnor', 'Information Systems ', '0243658609', 'niibarnor', '$2y$10$lcOIYjtJdKHVIvZ0aRnry.LKETnkF02Xr0UJ2x9y1RpCQEjG71Yl6'),
(6, 'Dr.', 'Mawuko Dza', 'Procurement ', '0559615170', 'md', '$2y$10$4nn6Cem.m1uuz9yvodRLeedAXjKFfX0RfkZP09y75cVTBhOjfc36W'),
(7, 'Dr.', 'Richard Oduro', 'Finance', '0244073899', 'ro', '$2y$10$RS0CRlQtoabjgWyGy6raZesYA2ZAy3g4TCq0uAgAbiK4yzZcSD/Vi'),
(8, 'Dr.', 'Isaac Mensah ', 'Marketing and Entrepreneurship ', '0541054153', 'im', '$2y$10$7z/WHVQhMiZRSJXTelfe4.dLWT7ry6pfa6CEkoWZXWpgVkTJRlTQC'),
(9, 'Dr.', 'Yaw Brew', 'Marketing and Entrepreneurship ', '0262184795', 'yb', '$2y$10$FYpI0PKU1D8Cb6POFt67duSG./MDAEKHzOD7AIerIwVGHGxEWhCle'),
(10, 'Dr.', 'Emmanuel Yamoah', 'Human Resource Management ', '0246726459', 'ey', '$2y$10$e4rYTc6KB4Ch2pfmUWFtj.Sgiq4NPEeBMWV5bYKMB9SCdK896ctJO');

-- --------------------------------------------------------

--
-- Table structure for table `proposals`
--

CREATE TABLE `proposals` (
  `id` int NOT NULL,
  `full_name` varchar(255) NOT NULL,
  `programme_of_study` varchar(255) NOT NULL,
  `level` varchar(50) NOT NULL,
  `contact` varchar(15) NOT NULL,
  `email` varchar(255) NOT NULL,
  `business_idea_title` varchar(255) NOT NULL,
  `brief_description` text NOT NULL,
  `target_market` text NOT NULL,
  `competitors` text NOT NULL,
  `market_trends` text NOT NULL,
  `initial_capital` varchar(50) NOT NULL,
  `required_resources` text NOT NULL,
  `skills_needed` text,
  `potential_partnerships` text,
  `social_impact` text,
  `technological_elements` text,
  `member1_name` varchar(255) DEFAULT NULL,
  `member1_programme` varchar(255) DEFAULT NULL,
  `member1_level` varchar(50) DEFAULT NULL,
  `member1_email` varchar(255) DEFAULT NULL,
  `member2_name` varchar(255) DEFAULT NULL,
  `member2_programme` varchar(255) DEFAULT NULL,
  `member2_level` varchar(50) DEFAULT NULL,
  `member2_email` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `proposals`
--

INSERT INTO `proposals` (`id`, `full_name`, `programme_of_study`, `level`, `contact`, `email`, `business_idea_title`, `brief_description`, `target_market`, `competitors`, `market_trends`, `initial_capital`, `required_resources`, `skills_needed`, `potential_partnerships`, `social_impact`, `technological_elements`, `member1_name`, `member1_programme`, `member1_level`, `member1_email`, `member2_name`, `member2_programme`, `member2_level`, `member2_email`) VALUES
(2, 'Osei Kenneth Appiah ', 'Banking and Finance ', 'Level 300', '0599942041', 'Kenosei1656@gmail.com ', 'O\'KENNYS PUB AND GRILL', 'A PUB(Drinking Spot both alcoholic and non-alcoholic beverages) and a food joint ( fufu with Tilapia pepper soup, Fried Yam with pork or chicken, Banku with Tilapia and Fried rice. ', 'Students on various campuses, lectures and Administrators ', 'Biggers, Kings and Queens and Bra Joe\'s Eatry', 'Stable ', 'GHS 20000', 'Drinks, Food items, Kitchen Tools ', '', 'School Of Business ', 'Community Development ', 'Hardware and software ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3, 'Enoch Tei ', 'Marketing and Entrepreneurship ', 'Level 300', '0594045659', 'godsheart054@gmail.com', 'Snail mackerel ', 'I aim to to produce mackerel using snail for easy consumption.', 'Health conscious People anf international market ', 'Gino mackerel ', '', '50,000 cedis', 'Seed capital  , land, labour and  investors ', 'Expertises in food production', 'Anyone who shows interest ', ' jobs creation ', 'Canning machine ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4, 'Emmanuel Donkoh', 'Human Resource Management ', '2024 graduate', '0557570536', 'emmanuel.7donkoh@gmail.com', 'Expedient Manuel Services ( Money transactions, Mobile Phones and Accessories) 2. Manuel farms', '1. Expedient Manuel Services.\nProviding quality Mobile phones and accessories at affordable prices. Providing professional mobile money transaction services.\n\n1. Manuel farms.\nProviding healthy farm products ( healthy animals for meat and organic produce) to the people of Winneba and beyond.', '1. General public (students) 2. Restaurants and chop bars', '1.Mobile money vendors and mobile phones sellers. 2. Farmers in and outside Winneba', 'Adapting to the preferences of customers possibly ', '1. GH 2800.00 ( mobile money- GH 1000.00, farm - G', 'Land for pigsty and capital for mobile phones purchases ', 'Required farming skills of all kind. Coaching on sales', 'Samsung Ghana', 'Offering Employment', 'E - Commerce ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5, 'Collins Marfo ', 'BBA Human Resource Management ', 'Graduated ', '0248998359', 'collinsmarfo500@gmail.com', 'Car Aid ', 'Car Aid is an Auto Mechanic Repairs shop ', 'Corporate and Individual vehicle users ', 'CFO, Toyota Ghana, ', '', '100,000.00', 'Overhead Lift, spinners', 'Auto mechanics ', 'Totachi Ghana, ABRO Ghana, NGK Ghana, NVTI', 'Young graduates from our senior high schools will get opportunity ', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(6, 'Manasseh Amemasor', 'Bsc. Chemistry Education', 'Level 200', '0509577184', 'manassehmhingle@gmail.com', 'Super Food', 'Use of Coconut to produce cooking oil and animal feed. ', 'Ghanaian homes, students on tertiary campuses, food vendors, restaurants and poultry farms.', 'Wilmar Africa Limited, and Market vendors', 'People are not consuming coconut oil currently due to lack of knowledge about its health benefits and poor branding. ', 'Ghc 25,000.00', ' A warehouse to store dried coconut, place for producing the oil and items and equipments to be used. ', 'Cooking of coconut oil, marketing of cooking oil and animal feed, and content creation. ', 'UEW Innovation Hub', 'Training and Employment of Women, young mothers and the physically disabled. ', 'Processing and branding of products. No waste in production since coconut shells will be used as fuel. ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(7, 'Degraft Osei', 'Accounting Education ', 'Level 300', '0592793886', 'raymondosei1173@gmail.com', 'Leather bags making ', 'Am into making of school bags, side bags, traveling bags, mens purse etc', 'The General public ', 'Importers of bags', 'Traveling bags and others ', 'Gh6,000', 'Container ', 'Anyone can do', 'Yes ', 'I Allow the young once to have their own skills ', 'Laptop for research ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(8, 'Frederick Tawiah Donkoh ', 'Communication and Media ', 'Level 200', '0540377090', 'mrfredtadon@gmail.com', 'Online Is My Office', 'Because of convergence and New Media, almost every individual spends about 10 to 15 hours of his or her time on the mobile phone and computers. We live in a world where everything is becoming Technological and Digital. And Artificial Intelligence is now taking over the Internet. Aside the New Media or Social Media Platforms that helps us to earn a living, there are various AI tools that can also help us to earn money on the Internet. So with this, i will open an institution to train people to become Content Creators, with the Communication Skills and Media Skills that will be instill in them. Also, various marketing Strategies and Social Media strategies that are going to help them perform very well on the internet in other to achieve their success on the internet.\nI will also train educate them on how to use the various AI tools to help make a living on the internet. Google Adsense has a lot of ways to pay individuals. YouTube pays individuals, Facebook is now paying Ghanaians and very soon, Instagram will also pay Ghanaians. So this is going to help individuals to help earn a living on their own without depending solely on the government for jobs.', 'The Youth.', 'In this context, the competitors rate is very low since every individual has his or her own niche and audience.', 'The Diverse of monetizations, authenticity and interactivity of the contents.', '20,000 Ghana Cedis.', 'Well Equipped Studio', 'Ability to read, write and speak. Confidence, Creativity and innovation. Honesty.', 'Other Companies or brands for Advertisements, promotions, sponsorship and Ambassador contracts.', 'Will bring about Economic Growth, reduces the rate of unemployment, create job opportunities for people and foresters creativity and innovation.', 'Mobile phone, Laptops, Cameras, Microphones, internet data.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(9, 'ISAAC ANTWI', 'BBA MARKETING AND ENTREPRENEURSHIP ', 'Level 400', '0559300511/0201', 'antwiisyaw@gmail.com', 'ODO KOKONTEY ', 'ODO KOKONTEY is the cassava powder which looks like fufu. Many people especially the big men find it very difficult to buy from the market since it has little hype. Me packaging it well will help solve this problem since there is nothing like that on the market currently. ', 'STUDENTS AND WORKERS', 'NEAT FUFU POWDER', 'Many people especially students are now consuming Kokontey due to the economic hardship. ', 'GHC2,000.00', 'GRINDING MACHINE, CASSAVA, PACKAGES, MAIZE AND SAGS ', 'SKILLS IN FARMING (UNSKILLED)', 'STUDENTS (TWO STUDENTS FOR START)', 'It will help to solve the struggles people go through to prepare fufu since this one needs less effort to prepare. It also help people who truly like it to be confident in purchasing them.', 'SOCIAL MEDIA AND MACHINE FOR GRINDING ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(10, 'Ahaji Samuel', 'BSC Accounting ', 'Level 300', '0556055344', 'ahajisamuel73@gmail.com ', 'A&S farms(Poultry)', 'Serving customers with fresh eggs and meat with the needed materials.', 'Consumer demographics', 'Akate farms and Darko farms ', 'Global consumption trends, Market segmentation, Strategic partnerships and investments', 'GH35000', 'Poultry housing, Chicks, Feed, Heating equipment and Land ', 'Animal husbandry, Budgeting, Record keeping and Management.', 'Agribusiness Organizations and NGOs and Restaurants and Food Outlets.', 'In terms of social impact, Poultry farming provides employment opportunities for both skilled and unskilled workers.', 'Automatic Feeders and Waterers, Automated Nesting Boxes and Robotics and Artificial Intelligence (AI)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(11, 'Jakper Joana Yenuloem ', 'Marketing and Entrepreneurship ', 'Level 400', '0592060480', 'joanaamor1012@gmail.com', 'Sunrise Revive - Revitalizing Beverages', ' Sunrise Revive is a line of refreshing, healthy beverages designed to help people revitalize their minds and bodies. Our initial product is a unique blend of natural ingredients, including pineapple juice, tumeric, ginger, coconut water and cinnamon  to provide a mental and physical energy boost.', '- Health-conscious individuals - Fitness enthusiasts - Busy professionals - Students  - Active lifestyle seekers', '- Zenify -Mood33 -Rritual  -FRS Healthy Energy  -Runa Clean Energy  -EBOOST  -FOCUS AID -MIND FUEL', '-Growing demand for healthy energy drinks - Increasing popularity of plant-based ingredients - Rising interest in mental wellness and self-care', '2,500.00 Ghana cedis (for production, marketing, a', '-Manufacturing facility - Marketing team - Distribution network - Quality control measures - Research and development team', '-Marketing and branding expertise - Food science and formulation knowledge - Operations management - Sales and distribution experience', '-Collaboration with fitness studios and gyms - Partnerships with health and wellness influencers - Sponsorship of mental health and self-care events', '-Promoting healthy energy and mental well-being - Supporting sustainable and eco-friendly practices - Encouraging active lifestyles and self-care habits', '-Online ordering and delivery platform - Social media marketing and engagement tools - Data analytics for market research and customer insights - Automated manufacturing and quality control processes', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(12, 'Emmanuella Balogun ', 'Procurement and  Supply  chain management ', 'Level 100', '0534679959', 'Bellaaderotimi@gmail.com', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(13, 'Ankemah Boateng Samuel', 'Accounting', 'Level 300', '0592302283', 'Samboat628@gmail.com', 'ElectroCredit', 'ElectroCredit is a business idea that sells technological devices and accessories to individuals that can not buy the basic needed technological devices and accessories at the full price from the shops and online marketers. \nSo with ElectroCredit, these individuals have a place that can also give them the needed access to all their technological needs, to avoid being left behind in by their peers and the society at large.', 'Students, parents, Guardians and institutions', 'Technological shops and online market', 'Growth of online sales, Increase demand for smart technologies or Ai and low income of most individuals due to the current economy leading to credit increase.', '100,000', '1. Initial Inventory: A sufficient stock of electronic items, such as smartphones, laptops, TVs, and accessories.  2. Storefront or Online Platform: A physical store or e-commerce website to showcase and sell products.  3. Funding or Capital: Adequate funds to cover initial inventory, store setup, marketing, and operational costs.  4. Credit Facilities: Arrangements with suppliers or financial institutions to offer credit to customers.  5. Point of Sale (POS) System: A robust POS system to manage sales, inventory, and customer data.  6. Inventory Management Software: A system to track inventory levels, monitor sales trends, and optimize stock replenishment.  7. Marketing Strategy: A plan to attract customers, build brand awareness, and promote products.  8. Sales and Customer Support Team: Trained staff to assist customers, answer queries, and handle sales and after-sales support.  9. Security Measures: Implement measures to prevent fraud, secure customer data, and protect inventory.  10. Accounting and Financial Management Tools: Software or systems to manage finances, track credit sales, and monitor cash flow.  11. Legal and Regulatory Compliance: Obtaining necessary licenses, permits, and complying with consumer credit regulations.  12. Insurance Coverage: Consideration of insurance options to protect the business from potential risks and losses.', 'Sale and marketing skills, Product knowledge, Credit management skills,inventory management skills, financial management skills, customer service skills,leadership skills, technical skills, Analytical and problem solving skills  ', 'Major electronic and technological manufacturing industries in Ghana and beyond', 'This business idea will socially aid in the growth of individuals ability to keep up with the current trends and also aid invthe incorporation of basic needed skills like using the computer and also giving the less privilege in the society the chance to redeem themselves and not to be left behind by friends and colleagues that are well to do.', 'The technological elements in an electronics retail business that operates on credit sales include:  1. Point of Sale (POS) System  2. Inventory Management Software  3. Credit Management System  4. E-commerce Platform  5. Mobile Payment Solutions  7. Security and Surveillance Systems  8. Data Analytics Tools  9. Customer Relationship Management (CRM) System  10. Supply Chain Management Software', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(14, 'ARKO SETH ESSEL ', 'PROCUREMENT ', 'Level 400', '0242220351', 'arkosethessel@gmail.com ', 'THE FARMER\'S FRIEND', 'Is a digital platform where agricultural products such as fertilisers, weedicides, pesticides, etc with their respective prices will be uploaded. Example is Jumia App. Mine is the farmers Farm App. The vision is to provide convenient solution to the farmers and agro retailers so that we can can save their time.', 'FARMERS AND AGRO CHEMICALS SELLERS ', 'TONATOM, JUMIA GH, ALIBABA APP', 'DIGITAL TRANSFORMATION IN AGRIBUSINESS ', '40,000 GHANA CEDIS, BUT THE OWNER IS WILLING TO PR', 'CAPITAL OF GHC5,000 AND RENTED AGRO CHEMICAL SHOP', 'TECHNOLOGICAL SKILLS, MAKETING SKILLS, COMMUNICATION SKILLS', '1. Farm-to-Table: Collaborations between farmers, processors, and restaurants/retailers to promote locally sourced and sustainable produce.  2. Agri-Tech*: Partnerships between farmers, technology companies, and research institutions to develop and implement innovative farming solutions.', 'It can provide farmers with better access to markets, technology, and resources, improving their income and quality of life.', '1. Mobile App Development 2. Artificial Intelligence and ML 3. E- Commerce Platform ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(15, 'Emmanuel Sakyi ', 'BBA: Human Resource Management ', 'Level 400', '0247451739', 'sakyie1010@gmail.com ', 'Manuel Consultant Agency (MCA)', 'The agency will exist to render services in the area of recruitment and selection, training and development, remuneration, performance management, developing and maintaining computerised databases, administering special examination and end of term examinations, etc.', 'All private schools and small businesses like pure water businesses within the Lower Manya Krobo Municipality, Eastern Region-Ghana ', 'Best Brain Konsortioum ', 'More private schools and pure water businesses are been established in the locality. ', 'Ghc 15,000.00', 'Laptop, desktop, projector, printer, printing sheets, photocopier, etc', 'Good communication skills, facilitating skills, technical skills, conceptual skills and human skills ', 'Partnership with BRAMAX PIXELS ', 'The activities of the agency will relatively reduce unemployment rate in the locality, ensure compliance with Labour practices enshrined in the Labour Act 651', 'Augmented reality: use of both online platforms and resources as well as physical resources to undertake activities ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(16, 'Asamoah Gideon ', 'Human Resource Management ', 'Level 300', '0246063558', 'asamoahgideonjunior@gmail.com', 'Restaurant and Hostels.', '1.Operating and managing restaurants where we serve the people quality and affordable foods.\n2. Building of affordable hostels for students in schools where the halls on campuses can\'t contain the entire population of the students.', 'Tertiary Institutions.', 'Housing agencies and other food joints.', 'Students not having access to quality and affordable hostels to rent and to some extent not getting value for their money when they buy food on or around campuses.', '0', 'Capital.', 'Good cooks/chefs and credible building contractors.', 'Any Investor who finds the opportunities available interesting and wise to invest.', 'Create job opportunities for the people within that very vicinity and students who can take part time jobs whilst on campus.', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(17, 'EMMANUEL DONKOH ', 'BBA BANKING AND FINANCE ', 'Level 400', '0548398440', 'donkohemmanuel025@gmail.com', 'Oil palm production ', 'Oil palm production is a business that comes with its own raw materials, the one main raw material is palm fruit, besides the palm tree and materials from the palm fruit are used for product like soap , margarine and others.  ', 'Supply of palm oil , vegetable oil , soap and margarine across Africa .', 'Benson oil palm production ', 'Ghana currently has an unmet demand of 35,000 tonnes of palm oil. The broader ECOWAS sub-region has an unmet demand of 850,000 tonnes. This presents an opportunity for Ghana to scale-up production of the cash crop to satisfy local and regional demand for much-needed foreign exchange.', 'Ghc10,000 for the land ', 'Human Resources and nursery ', 'Vision, mission and passion ', 'Benson oil palm', 'Job creation ', 'Palm oil production machine ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(18, 'Nyamavor Salomey ', 'BBA Accounting ', 'Level 300', '0500204862', 'salomeyn185@gmail.com', 'Sally\'s enterprise ', 'Dealers in cosmetics and also sewing and sales of clothing.(Fashion design)', 'Students and people outside the school community ', 'Semtress and taylers , retailers  and wholesale ', 'Sustainability and natural ingredients ', '5000 cedis ', 'Funds, premises ', 'Marketing, accounting and fashion design( how to sewing experience)', 'Beauty influencer and bloggers, Natural cosmetics suppliers, Tech companies ', 'People will be giving the opportunity to enroll in apprenticeship to learn and develop their career as semtresses and taylers ', 'Modern sewing machine ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(19, 'Nyamavor Salomey ', 'BBA Accounting ', 'Level 300', '0500204862', 'salomeyn185@gmail.com', 'Sally\'s enterprise ', 'Dealers in cosmetics and sewing and sales of clothing (fashion design)', 'Students and people outside the school community ', 'Semtresses and taylers, retailers and wholesalers ', 'Sustainability and natural ingredients ', 'Gh5000 cedis ', 'Funds, premises ', 'Marketing, accounting and fashion design', 'Cosmetic suppliers, beauty influencer and bloggers, manufacture of natural ingredients ', 'People will be giving the opportunity to enroll in apprenticeship ', 'Modern sewing machine, computer ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(20, 'Danso-Botwe Jesse Guna ', 'Procurement and Supply Chain Management ', 'Level 400', 'Degree ', 'Lionnodeeelikeme@gmail.com', 'Kadi Shift Courier service and save travels ', 'By doing this, the company focuses on students who live in remote areas and require assistance getting there or delivering a product from home to school or even nearby schools.', 'Students ', 'J AND H courier and delivery service ', 'The company trend is more focused on the students rather than the individual ', 'Funds from family ', 'Trusted employees, vehicles, communication devices, Navigation tools and insurance ', 'Navigation skill, Safety awareness, technology skills, Leadership skills ,customer service and problem solving skills ', 'University of Education,Winneba ', 'Job creation, community Job creation, Community connection, Support for local businesses, Economic growth, Safety concerns and Environmental Impact ', 'GPS tracking,Mobile App, Barcode scanning and Cloud ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(21, 'Emmanuel Boakye ', 'Accounting ', 'Level 400', '0558757104', 'kobinayeboah85@gmail.com', 'Local soap and African black soap production ', 'Cr?ation of vertically integrated business model for producing and marketing African black soap targeted at everyone ', 'Local and international market ', 'Local producers of black soap,small businesses and international retailers', 'Growing demand for natural and organic products, personalized skin care and social media influential marketing', 'GH?10000', 'Raw materials, Equipment and tool and other resources.', 'Agricultural skills,soap making skills and business technical skills and marketing skills', 'Local farmers and cooperatives, NGO\'s online retailers, beauty and wellness influencers ', 'Job creation, sustainable agriculture and cultural preservation', 'Automated mixers and grinders, solar dryers, online sales platform', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(22, 'Sukandei Balluwie Abdul_Gafaru', 'Marketing and entrepreneurship', 'Level 200', '0506273619', '5231500015@st.uew.edu.gh', 'I want produce pure water ', 'I have a small existing business, but I don\'t have much fund run it well, but where I\'m I again realized that producing pure water thus the sechet and bottle all can help me fetch more money at my end. So with your support I\'m quite sure I can make a difference since I\'m going to be the first person start the pure water production thanks. ', 'My target is to the youth and kids . ', 'Only one competitor but not all that closed to my stor', 'To maintain current and my potential customers', 'GHC 30000.00', 'The pure water processing machinery and a mechanized bore hole. ', 'Train on how to process the water', 'If all things been equal, that\'s my target so that liabilities will be shared. ', 'Water is life and everyone needs water. Simply I want make sure my people drink healthy water', 'Crm apps can help boost my business. ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(23, 'Abdul Ghaffar Lateef ', 'Bachelor of Arts ', 'Level 100', '0244239350', 'ghaffar_ab@ymail.com', 'AMAG travel and tour.', 'To serve the busing needs of the people of Mfantseman and surrounding communities.', 'Corporate groups like banks staff, E.C.G. workers, G.W.C.L workers, Professional groups like teachers medical officers and social groups like churches, students and political parties members.', 'G.P.R.T.U', 'The aforementioned groups struggle to get a shuttle services to their workplaces in the morning and to their homes in the evening. Moreover when the have to travel to other destinations for funeral and other programs. The average income of these groups is Gh?2,000.00 therefore they can pay if the required service is rendered.', 'Gh?20,000.00', '1. Toyota Coaster (32 seater) and Hyundai bus (32 seater) or Nissan Civilian bus (32 seater)', 'Entrepreneural skills.', 'Not yet.', 'It will ease the commuting struggle amongst the target groups in times of need.', 'A website together with an app would be developed to render efficient and satisfactory services', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(24, 'JOSEPH KWESI MENSAH ', 'ACCOUNTING EDUCATION ', 'Level 200', '0248083082', 'josephkmensah01@gmail.com', 'Kwesi Mensah Electricity Distributor ', 'Now, electricity has become a necessary for everybody. And i find myself in a community where people have to travel before they get electricity in use. And I want to be a person who will be a provider to their nearest localities. ', 'Every electricity user ', 'Other distributors who are not close to my locality ', 'Everyday available to the user ', 'GHC3,000.00', 'Printer, Personal computer, wifi connection and electricity power supply ', 'How to operate the system of the transaction ', 'A pharmacy shop that will also help in providing for the health needs of these people ', 'Smooth provision of electricity without traveling for a long distance ', 'Very literate in the advanced ICT tools ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(25, 'Hayford Owusu ', 'Management Education ', 'Level 400', '0241741048', 'hayfordowusu40@gmail.com', 'Fashion Designing ', 'Into sowing of Suits( Political, Safari, etc). \n\nSowing of all kinds of uniforms(Military, school, Police, Nurses etc.)\n\nKaftan dresses.\n', 'Young fashion fashion-conscious professionals between the ages of 18-45 who made between middle-class income. Institutions like schools, corporations and others that have a prescribed uniform.', 'Fashion designing industry offering same product and service. Boutiques and secondhand clothes dealers.', 'Demand for sustainable fashion. Influence of social media. Personalized custom design services.', 'Ghs 20,000.00', 'Machines, Fabrics, Dommy Packaging materials.', 'Marketing skills and packaging skills ', 'With high class boutiques in Ghana and other foreign fashion companies ', 'Generate Employment. Supporting the local economy. Promoting diversity and inclusivity.', 'Mobile apps. Cutting machine. Laptop for designing.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(26, 'Blay, David ', 'Management Education ', 'Level 400', '0592226550', 'blaykakudavid@gmail.com', '2 in 1 Organic fertilizer and pesticide ', 'This a production of 2 in 1 fertilizer and pesticide which is purely organic and environmental friendly. ', 'Cash crop farmers, gardeners, permaculture practitioners and other Organic farmers. ', 'Companies and firms who are producing organic fertilizer and organic Pesticides. ', 'There is an increasing rate of concern for the use of organic fertilizer and pesticide lately. ', 'GH_ 10,000', 'Laptop, laboratory test technology, qualified technician and machine for grinding the raw materials. ', 'Laboratory technician ', 'Anyone with good money, links and the know how. ', 'It will serve as employment opportunity and also encourage healthy and organic crop production. ', 'Grinding machines and laboratory test equipments. ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(27, 'NYARKO MAWUTOR', 'HUMAN RESOURCE MANAGEMENT', 'Level 100', '0599854180', 'nyarkomawutor13@gmail.com', 'Selling of online electronic goods', 'I want to set up a business by selling electronic goods such as ear pods which will be shiped from outside Ghana by jumia company limited at a good discount. I will purchase those product from jumia company at a low cost for resale.', 'Due to improvement in technology, 90% of  people use these product in operation of daily activities. Setting up this business will help catch the attention of more than 50% of people. ', 'Low competitors because people don\'t value such as a business which will bring profit', '', '200', 'Fund', 'Skill of advertisement to create the awareness of people.', '5 partnerships', 'Due to the benefit we have derived from ict, such products will help people carry their activities at ease ', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(28, 'Blay, David ', 'Management Education ', 'Level 400', '0592226550', 'blaykakudavid@gmail.com', '2 in 1 Organic fertilizer and pesticide ', 'To produce in one pack organic pesticide and fertilizer which is environmental friendly and easy to use. ', 'Gardeners, permaculture practitioners and other Organic farmers ', 'Organic fertilizer and organic Pesticides producing firms and companies. ', 'There is an increasing rate of concern for the use of organic fertilizer and pesticide. ', 'GH_ 25,000', 'Grinding machins, laboratory equipments, technicians and computers. ', 'Laboratory technician and a business analyst. ', 'Anyone with good money, links and the know how. ', 'Employment and chemical free crop production. ', 'Laptop, laboratory test equipments and grinding machines. ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(29, 'Bassah Mbibah Philip ', 'BBA Human Resource Management ', 'Level 200', '0551199244', 'ministerphilip4@gmail.com', 'Production of packaging items ', 'Gift boxes and paper bags production.\nUsed for packaging items like shoes, shirts, jewelry among others for the following occasions:\nBirthday\nMother\'s Day\nFather\'s Day\nValentine\'s Day and more \n', 'Students and other eco-friendly individuals  ', 'Gift box producers', 'There has been a growing shift towards eco-friendly and sustainable packaging solutions in recent years. Many consumers are now more conscious about the environmental impact of packaging materials. As a result, there is a rising demand for recyclable, biodegradable, and reusable options in the gift box and paper bag industry. ', 'Ghc2,500.00', 'Strawboard, stickers, glue, laminator, heat gun, meter rule,  pair of scissors, ribbon ', 'Technical skills ', 'Event planners and organizers ', 'Create business opportunities for trainees', 'Gift Boxes and paper bags customization.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(30, 'Martin Gyabeng ', 'Bsc. Management Education ', 'Level 400', '0593273998', 'martingyabeng2020@gmail.com', 'Marquetry', 'Marquetry is a form of decorative art that involves creating intricate designs and pictures using pieces of veneer. These veneers are typically made from various types of wood, but other materials such as shell, bone, and metal can also be used. The pieces are carefully cut and fitted together to form patterns or images, which are then glued onto a surface, usually furniture or decorative objects.', 'Affluent individuals, interior designers, hotels and resorts, corporate offices, online marketplaces, tourists ', 'Textile arts, Metalwork and jewelry productions, Painting and sculpture, traditional wood carving.', 'Tourism growth, increasing online presence, cultural revival and preservation, art exhibitions and fairs ', 'no capital ', 'Materials, tools, educational resource, networking and community,', 'Knowledge and Theoretical Understanding, Technical Skills, Artistic Skills, Business and Marketing Skills', 'Interior Designers and Architects, Furniture Manufacturers, Art Galleries and Exhibitions, Tourism Industry, Educational Institutions, International Art Galleries, Cultural Exchange Programs, Museums and Cultural Institutions, Non-Governmental Organizations (NGOs)', 'Economic Empowerment, Cultural Preservation, Education and Skills Development, Promotion of Art and Culture', 'Tools and Equipment, Software and Digital Design, Digital Resources and Learning Platforms, Communication and Marketing', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(31, 'Aaron Haruna Siakah ', 'Bsc Accounting Education ', 'Level 400', '0553264115', 'aaronsiakah1@gmail.com', 'Cashew nuts oil processing ', 'Cashew is a cash crop planted for its fruit ands seeds. \nBoth fruit and seed provide numerous nutritional values. \nThe fruits and nuts are mainly consumed in Ghana but attention has not been drawn to the oil and its benefits. \nIt\'s best for cooking, nourishment of the skin and hair because of its nutritional values.\n', 'Ghanaian household kitchen and every restaurant ', 'Frytol, Unoli Soya Bean Oil, Borges Classic Olive Oil, Butter, Sunflower Oil, Coconut Oil ', '', 'GHc 5000000', 'Cashew nuts processing machine in a factory, warehouse, cashew nuts ', 'Operation of cashew nuts processing machine ', '', 'Employment for numerous Ghanaians ', 'Machine control, market development ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(32, 'Edwina Dede Tawiah-Baddoo ', 'BBA Marketing ', 'Level 200', '0241247687', 'edwinabaddoo0@gmail.com', 'Mobile Money and mobile transfer ', 'I want to be a mobile Money vendor my area here in winneba has only one vendor which makes the use of mobile Money in our area disturbing since there is difficulty in cashing out and transferring money ', 'Student, those at my area and I intend to be mobile thus go to the person\'s place if needed', 'There is only one vender at my area', '', '7000 Ghana cedis ', '1 keypad phone ', '', '', 'It will help with easy access to mobile Money for all users', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(33, 'Kwadwo Mensah Nyarko Gaisie', 'Marketing and entrepreneurship ', 'Level 400', '0249529405', 'gaisienkm@gmail.com', 'Beetroot Natural Juice', 'Our thorough research has shown that combining beetroot with ginger, honey, and plant-based milk produces a unique and nutritious natural fruit juice.\nCampus to Business (C2B) is a natural fruit juice business offering Vigor Juice to individuals, including women, men, children, weight-management customers, and those seeking to enhance their overall well-being.', 'Women,Men,Children,Weight-Management Customers ', 'Other Natural Juice Products.', 'By aligning C2B?s product offerings with these market trends, you can better meet consumer demands and positioning Vigour Juice for success in the competitive natural juice market. We set a competitive price to have a great market share and delivering the valuable product in the market.', '1000 Ghana cedis ', 'beetroot with ginger, honey, and plant-based milk(Coconut milk and Soybean milk)', 'Operations and Sales Management,Digital Management and Entrepreneur mindset .', 'Group members ', 'The health benefit of the product and it?s also environmentally friendly.', 'The use of digital platforms for Promoting and Advertising of our product.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(34, 'Soliu Ibrahim Folorunsho ', 'Marketing and Entrepreneurship ', 'Level 200', '0544246533', 'saliuibrahim1212@gmail.com', 'Graphic designer ', 'I always base on designing of flyer, business card, birthday designs and flex banner at well and also do typing, create PowerPoint slide.', 'In marketing I learned segmentation and I will be targeting on most businesses, student and community.', 'I will have to know to manage my business because we have a lot graphic designer out there and there will be a composition so I will have to understand my customer well and building strong relationships with them', 'The customer likes to see new things so as a designer person I will try to bring new design that will attract them.', 'I don\'t have any ideas on the capital that will be', 'I will be needed Human resources ( people with specific skills), Financial resources ( budget or money), Physical resources ( equipment and building), Technological resources ( software, hardware or digital tools), Information resources (data) and materials resources (raw materials, supplies or inventory).', 'I will need to learn IC skilled and also I will need to know how to use some of the graphics design softwares and machines to improved my workflow ', 'For the people I will like to be partner with I always heard their name and they\'re Kwesi Agyemang, Emmanuel Owusu and Franklin Agyeman.', 'I am going to make sure that the society knows about my business, people will talk good about it and I will also understand their needs and want.', 'For my business to operate well I will be needing printer, scanner, graphic tablet, monitor, service/storage, operating system (windows), connectivity ( Wi-Fi or Ethernet) and plotter/cutter etc.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(35, 'NANKENMIE SEIDU SULEMAN ', 'Bachelor of science management education ', 'Level 100', '0241562200', 'sulemannankenmie272@gmail.com', 'Crop production ', 'I am in to cultivating of maize, soyabeans, beans, groundnut,\"Nyansan\" .', 'Maize Ghc450, soyabeans GHC700, Nyansan GHC15000 groundnut GHC 350,beansGHc600 ', 'Co-farmers', 'Downward ', 'GHC 9,100', 'Treated seeds,napsack sprayer, fertilizer, insecticides market-linkage or financial aid.', 'How do treat local seeds for good yields', 'Animal rearing ', 'Eradicate poverty level and improve standard of living ', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(36, 'Asare Collins Osafo-Ayeh ', 'BSc. Management Education ', 'Level 400', '0557047797', 'collinsosafoayeh@gmail.com', 'Jewelry ', 'I use beads to make necklace, earrings and decorations ', 'International ', 'Local beads and jewelry makers', 'It\'s on WhatsApp and Facebook and Instagram ', '500 to 1000 cedis', 'Beads, jewelry tools, Jewelry findings nylon cord', 'To be able to add more and classic styles ', 'Cartier ', 'Jewelry beautifys people and environment ', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(37, 'NANKENMIE SEIDU SULEMAN ', 'Bachelor of science management education ', 'Level 100', '0241562200', 'sulemannankenmie272@gmail.com', 'Crops production ', 'I am in to cultivating of maize, soyabeans , beans , groundnut and Nyansan.', 'Maize Ghc450, soyabeans GHC700, Nyansan GHC15000 groundnut GHC 350,beansGHc600 ', 'Co-farmers ', 'Downward ', 'GHC 9,100', 'Treated seeds, napsack sprayer, fertilizer, insecticides market-linkage or financial aid ', 'How to treat local seeds for good yields ', 'Rearing of animals ', 'Eradicate poverty and improve the standard of living of people ', 'Machine plantor ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(38, 'INUSA ISAKA', 'BUSINESS MANAGEMENT IN EDUCATION ', 'Level 400', '0547416407', 'Isakainusa8@gmail.com', 'African?s slippers production.', 'Producing high-quality, comfortable and stylish slippers, shoes for both men and women. Our vision is to become the leading eco-friendly leather slippers and shoes producers nation wide not only in Ghana.', 'Men and women aged 15-65 seeking comfortable and fashionable footwear for relaxation and casual wear.', 'Other slippers and shoes manufacturers and brands such as Acorn, Vionic and UGG', 'Growing demand for comfortable and athleisure footwear, increasing interest in self-care and relaxation and rising popularity of online shopping of our products.', '$10,000(estimated) for equipments, materials, mark', 'Materials( leather, insole, outsole, foam, etc),equipments(cutting machine, pressing machine, sewing machines, hammers, manual heater, tape measure or rule etc), labor( skilled workers for production), marketing materials( website, social media, advertising), distribution channels( online, stores, wholesale, retails and exportation to different countries)', 'Design and product development, Production management, marketing and sales management, quality control, supply chain management.', 'Suppliers of raw materials, distribution and wholesalers, online marketplace(Amazon, Ali baba).', 'Supporting local community through sourcing and production, providing employment opportunities, promoting comfort and well being through quality footwear.', 'Computer-aided design software for designs and prototyping, E-commerce platforms for online sales, inventory management software for tracking and optimization, social media and online marketing tools for promotions.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(39, 'Richmond Obeng', 'Sports Coaching', 'Level 300', '0555623818/0502', 'hudsonobengrichmond@gmail.com', 'Golden Gate Management ', 'Golden Gate Management is a proposed sports event management company dedicated to organizing and managing a wide range of sports events, tournaments, and leagues across Ghana. Our mission is to enhance the sports culture, provide entertainment, and generate revenue through sponsorships, ticket sales, and partnerships. With a professional team and strategic planning, Sport Event Ghana aims to become the leading sports event management company in the region, contributing to the growth and development of sports in Ghana.', 'Sports organizations, schools, universities, corporate entities, and local communities.', 'Local Sports Clubs and Associations', 'Growing Popularity of Football, Emerging Interest in Other Sports, Corporate Sponsorships', 'GH50,000 ', 'Office Space, Office Furniture and Equipment, Event Management Software, Marketing Materials, Inventory, Human Resources', 'Event Planning and Management, Marketing and Promotion, Financial Management, Operations and Logistics, Legal and Compliance', 'Educational Institutions, Sports Organizations and Associations, Corporate Sponsors, Media Outlets', 'Community Engagement, Employment Opportunities, Youth Development, Promoting Sports Participation.', 'Event Management Software, Customer Relationship Management , Online Marketing Tools, E-commerce Platform, Mobile Applications', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(40, 'Imoro Bukari Saniid ', 'Business information system ', 'Level 100', '0241557478', 'saniidambitious1@gmail.com', 'Mobile money merchant ', 'The area I live is a title bite far from town and there is no mobile money merchant around, unless town.', 'Mobile money merchant, at the same time selling of chargers, phone protectors, ear Port ect', 'No one around my area ', 'They are a lot of galamsay boys and girls around who normally fines it difficult to deposed they money.', '3500gh', 'The mobile money sim card and a store.', 'Already having the skills on how to transact', 'My sister and I ', 'It going to help the around the area to be able to transact their money and save their TNT', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(41, 'Sedem Innocent Gadasu', 'BBA Accounting ', 'Level 200', '0548532049', 'sedeminnocent@gmail.com', 'Dry Eats', 'We intend to produce Tapioco using cassava, and by products such as Kaklo and animal feed. ', 'Students on tertiary campuses and Ghanaian households. ', 'Gari sellers ', 'Most students and households use and buy gari as a dry food that has relatively longer shelf life. We want to offer them an alternative thar they can use for their soakings and porridges or patronise in addition to gari. ', 'Ghc 15000', 'A business premise where cassava can be peeled and processed, bowls and pans to use, and two or three people to be trained in producing Tapioca.', 'Selling, branding, and processing cassava. ', 'UEW Innovation Hub', 'Increased income for smaller farmers and employment for women', 'Branding, marketing and sale of product online. ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(42, 'Kingsley Toku Agyin', 'BBA Accounting ', 'Level 300', '0554922921', 'kingsleytoku9k@gmail.com', 'Fish Farming ', 'Catfish and tilapia farming ', 'Local market women and restaurants ', 'Just one competitor ', 'Long term ', '4000', 'Fingerlings, feed for them, tanks for storage ', 'Education on fish farming ', 'People who can supply me with fingerlings and feed for the fish.', 'There will be the need to employ as the business expanda', 'Advanced equipment for fish farming ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(43, 'George Hooper', 'Bachelor of Science (Management Education)', 'Level 400', '0591755135', 'georgehooper175@gmail.com ', 'Craft', 'Using Bamboo to make Standing Hanger', 'the receptions of any organization at all, the homes and offices and chops and many other', 'Wall hangers', 'consumers easily switch but I have innovative skills to maintain their interest which is a drive to a growing market.', '5,000.00 Ghana cedis', 'Hammar, chisels, sandpaper, and varnish paint', 'Ability to use machineries to produce in a large scale', 'Any deco company in the Ghana or Africa as a whole', 'the product is environmentally friendly', 'the use of E-commerce', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(44, 'Mawutordzor Agada ', 'Procurement and supply chain management ', 'Level 300', '0248946872', 'mawutordzoragada@gmail.com ', 'Hydrahub.', 'This business idea title ,HYDRAHUB illustrates the liquid nature of the products such as natural beverages and liquid detergents which is manufactured by myself. ', 'Households, students and the aged.', 'My competitors include major fruit juice extraction and detergent companies', 'Eco-friendly products, digital marketing and demand for healthy products. ', '50,000.00', 'Freezer, juice extractor, blender, customised  bottles and logo design, raw materials and other equipments. ', 'Communication, problem solving and management skills.  ', 'Agricultural  Development Bank and Suppliers of raw materials. ', 'Supports the overall health and wellbeing of individuals and the society at large.', 'Mixer, blender, freezer, and other major equipments. ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(45, 'FRANCIS DJATO', 'HUMAN RESOURCE MANAGEMENT', 'Level 300', '0208558832/0242', 'francisdjato4@gmail.com', 'EcoEats', 'EcoEats is a meal delivery service that focuses on providing sustainable, ecofriendly and healthy meal options to customers. The meals will be made using locally sourced organic ingredients and delivered in environmentally friendly packaging. ', 'Health-concious individuals, environmental activists, busy professional who care about sustatainability, and individuals looking for convenient and nutritious meal options.', 'Other meal delivery services with a focus on sustainability and healthy eating like SunBasket, Blue Apron, and Green Chef', 'increasing customers awareness and demand for sustainable and eco-friendly products, rise in populatity of meal delivery services, growing interest in plant-Base diets and emphasis on reducing food waste.', 'Initial capital will depend on the scale of the op', 'Kitchen space, cooking equipment, delivery vehicles, packaging materials, organic ingredients, website/app for ordering and marketing services.', 'Culinary skills or access to chef talent knowledge of sustainble food sourcing, understanding of food safety regulations, business management, marketing and customer service skills ', 'Local farmers for sourcing organic ingredients, eco-friendly packaging suppliers, fitness centers for meal plan partnerships, and environmental organisations for co-promotion.', 'By promoting sustainable eating habits and suporting local farmers, EcoEats can contributes to reducing the carbon footprint of food delivery service and raising awareness about eco-friendly food choices.', 'Implementing a user-friendly website or mobie app for ordering optimizing delivery routes for efficiency, integrating customers feedback systems and leveraging data analystices ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(46, 'Enoch Oduro', 'Bsc. Accounting Education', 'Level 400', '0204172089/0554', 'odurokwasienoch@gmail.com', 'Poultry Farming', 'I will operate  egg-laying hens farm using  cage-free method of farming which will produce eggs and chicken for sale.. ', 'Retailers (Grocery stores, farmers\' markets, and specialty food stores), Restaurants and Food Service especially those focusing on fresh and local ingredients, Direct-to-consumer: Selling eggs through farm stands, subscription boxes, or online platforms.', 'Other poultry farmers and producers or sellers of other sources of protein like beef, pork, fish, and plant-based alternatives', '? Population Increase: Ghana\'s population is increasing, driving demand for protein sources, including poultry. ? Urbanization: Growing urban centers contribute to rising demand for convenient and affordable poultry products. ? Changing Dietary Habits: Increased awareness of the nutritional benefits of poultry and shifting consumer preferences towards healthier options boost demand', 'GHS 7,000', 'Land and Housing:  Poultry Stock Feed and Water: Equipment and Supplies such as lighting, cleaning and disinfecting Supplies, water systems, egg Collection and Storage facility', ' Animal Husbandry Skills  Business and Management Skills such financial planning budgeting Technical Skills such as construction and maintenance ', 'Input suppliers, restaurants and food services, direct consumers, poultry farmers groups', 'By producing fresh, locally sourced poultry, I contribute to food security my community. This is especially important in regions with limited access to nutritious food. Poultry provides essential protein, vitamins, and minerals, contributing to healthier diets and improved nutrition, especially for vulnerable populations. Job Creation: Poultry farming generates employment opportunities, both directly on my farm and indirectly through related businesses like feed mills, processing plants, and transportation.', 'Precision Farming and Data Management, Disease Prevention and Control, Genetic Improvement and Breeding, Feed Management and Nutrition, Processing and Packaging.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(47, 'NANKENMIE SEIDU SULEMAN ', 'Bachelor of science management education ', 'Level 100', '0241562200', 'sulemannankenmie272@gmail.com', 'Crops production ', 'I\'m in to cultivating of maize, soyabeans, beans, groundnut and Nyansan ', 'GHC 91000', 'Co-farmers ', 'Slow ', 'GHC9500000', 'Treated seeds, napsack sprayer, fertilizer, insecticides, market-linkage, transportation machine or financial aid ', 'How to treat local seeds for good yields ', 'Animal rearing ', 'Improve standard of living of citizens and eradicate poverty level of the farmers ', 'Spraying machine ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `proposals` (`id`, `full_name`, `programme_of_study`, `level`, `contact`, `email`, `business_idea_title`, `brief_description`, `target_market`, `competitors`, `market_trends`, `initial_capital`, `required_resources`, `skills_needed`, `potential_partnerships`, `social_impact`, `technological_elements`, `member1_name`, `member1_programme`, `member1_level`, `member1_email`, `member2_name`, `member2_programme`, `member2_level`, `member2_email`) VALUES
(48, 'Aaron Haruna Siakah ', 'Bsc Accounting Education ', 'Level 400', '0553264115', 'aaronsiakah1@gmail.com', 'Cashew nuts oil processing ', 'Cashew is a cash crop planted for its fruit and seed. \nBoth fruit and seed provide numerous nutritional value making the body healthy. \nThe oil is good for cooking for its anti-aging properties. It\'s also used for nourishment of the skin and hair. \nThe shell of the nut contain a liquid called cashew nut shell liquid(CNSL) used in industries for production of paint. \nThe fruit is delicious serving nutrition for the body. \nProduction of cooking oil from the nut, making drink from the fruit and extraction of CNSL are the businesses I will like to establish; beginning with cashew nuts oil production. ', 'Every Ghanaian household kitchen and restaurant.  ', 'Frytol, Unoli Soya Bean Oil, Borges Classic Olive Oil, Butter, Sunflower Oil, Coconut Oil ', '', 'GHc 1000000', 'Cashew nuts processing machine, warehouse, cashew nuts ', 'Operation of cashew nuts processing machine, marketing of products', 'Every business minded individuals and groups ', 'Employment, access to quality and nutritious cooking oil', 'Machine control, market development ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(49, 'Mensah Bright Diankom ', 'Human Resource Management ', 'Level 100', '0593447964', 'mensahbrightd@gmail.com', 'Barbering ', 'Barbering is a profession that involves cutting, trimming, styling, and grooming hair for others. Barbering is a very good job that generates income everyday and every month. Therefore, the work of barbering is regular base activity that can enhance human skills in future. ', 'Men of all ages and other ', 'One person ', 'Revival of Local Traditional Barbering and Focus on Male Grooming ', 'One thousand five hundred Ghana cedis (GHC 1500.00', 'Financial resource, Tools and Equipment etc. ', 'Technical skills, Creativity, Customer skills, Business skills and Continuous learning etc. ', 'Local Business or Any other Technical company. ', 'Community engagement, Economic contribution and Social equity etc. ', 'Electrical clippers and Trimming, Sterilization Technology and Portable Chargers etc. ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(50, 'Mensah Bright Diankom ', 'Human Resource Management ', 'Level 100', '0593447964', 'mensahbrightd@gmail.com', 'Barbering ', 'Barbering is a profession that involves cutting, trimming, styling, and grooming hair for others. Barbering is a very good job that generates income everyday and every month. Therefore, the work of barbering is regular base activity that can enhance human skills in future. ', 'Men of all ages and other ', 'One person ', 'Revival of Local Traditional Barbering and Focus on Male Grooming ', 'One thousand five hundred Ghana cedis (GHC 1500.00', 'Financial resources, Tools and Equipment ', 'Technical skills, Creativity, Customer skills, Business skills and Continuous learning etc. ', 'Local Business and any other Technical company. ', 'Community engagement, Economic Contribution and Social Equity etc. ', 'Electrical clippers and Trimming, Sterilization Technology and Portable Chargers etc. ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(51, 'Azieve Joshua Atsu ', 'BBA HUMAN RESOURCE MANAGEMENT ', 'Level 300', '0243626790', '220009526@st.uew.edu.gh', 'Kugbeadzor Farms: Cultivating Quality, Sustainable Practices ', 'Kugbeadzor Farms is an Agribusiness that grows fresh, healthy food using sustainable practices that benefit our community and the environment.', 'Our communities and beyond. ', 'Peasant farmers', 'Higher demand but insufficient in the market.', 'GHC 12000.00 ', 'Farm machinery, water source for dry season and storage facility.', 'Sustainable Practices: and the marketing strategies ', 'Private sector companies and restaurants ', 'Create job opportunities for the youth, food security and sustainable agriculture ', 'E-commerce and advanced genetics ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(52, 'Manfred Atubra', 'BSc. Management Education', 'Level 400', '0559839864', 'atubramanfred1234@gmail.com', 'Furniture', 'The use of bamboo, sawdust and other materials to make quality and nice designed furniture like tables, chairs, wardrobe among others. Furniture design can be at the description of the customer.', 'Homes and offices in Winneba and the neighboring communities. Delivery outside Winneba also to be done based on location of the individual requesting.', 'Existing furniture businesses', 'Increasing demand for luxury and quality goods and also beautify homes which is good for the furniture business ', '7,000', 'Bamboo, drill, grinder, screws, saw, and other carpentry tools', 'Carpentry skills and creativeness', 'Suppliers, online marketplace, local businesses and organizations and logistics and delivery companies', 'Creation of jobs and employment, consumer satisfaction and  economic friendly', 'Hardware (machines) and digital technologies (website and social media)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(53, 'Kporxah George ', 'Bsc Accounting Education ', 'Level 200', '0542200615', 'kporxahgeorge@gmail.com', 'God and Glory Tomatoes Factory ', 'I want to establish a small size tomatoes paste processing factory. The name of the factory will be called God and Glory Tomatoes Factory, and the name of the tomatoes paste will be G&G tomatoes paste.we have a lot of  tomatoes planted from June to October every year in Keta, Anloga and it\'s environs in the volta Region of Ghana.This small size tomatoes factory will absorb the quantity of tomatoes that rot every year as a result of lack of ready for the tomatoes.', 'Local people, hotels and restaurants in Volta Region and beyond.', 'Gino tomatoes,Tasty Tom etc', 'There\'s high demand for locally made tomatoes paste as it\'s price is less moderate as compared to imported ones.', 'Ghc1,632,500', 'Automatic tomatoes paste production line, land,Van for Transportation, permit and license, electricity,water etc', 'Accounting and Audit skills,IT and Human Resource Skills ', 'Government, indigenous investors and multinational organizations ', 'Provide employment for about 150 to 200 people,help and motivation farmers by purchasing their tomatoes.', 'Automatic tomatoes paste production line,use of computers for record keeping etc ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(54, 'Samuel Quartey', 'Procurement and Supply Chain Management ', 'MPHIL', '0247449630', 'samuelquartey38@gmail.com ', 'Pickme Gas Cylinder Refill', '?PickMe? Gas Cylinder Refill is an on-demand cooking gas delivery service that makes ordering a gas refill easy. Our aim is to increase access to clean and affordable cooking fuel in every kitchen. Our first step is to enhance the refill experience with or without an LPG cylinder. Ultimately, our goal is to lease with NPA to improve access and help transition more people away from charcoal and other harmful energy sources that negatively impact their health. ', 'Middle-income individuals in urban communities. These individuals are more likely to already use cooking gas and experience the pain points we aim to solve.  Low-income individuals in the rural communities, helping them transition from charcoal to a cleaner energy source. Students in the tertiary institutions  Restaurants  Institutions like Schools (Both SHS and Tertiary), Hospitals etc. ', 'No major competition in the market especially within Winneba ', 'Individuals and institutions have to move in person to gas filling station to refill ', 'GHC 65,000.00', 'Branded Gas cylinders and Tricycles', 'Driving and communication skills ', 'National Petroleum Authority ', 'Ultimately, our goal is to improve access and help transition more people away from charcoal and other harmful energy sources that negatively impact their health. ', 'Mopeka Tankcheck Bluetooth sensor ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(55, 'FELIX BRYAN AFEKE ', 'BBA ACCOUNTING ', 'Level 300', '0243683253', 'felixbryanafeke@gmail.com', 'LIKEM?S CONSTRUCTION LTD', 'Likem?s construction Ltd is a construction firm that is into building of residential buildings,offices and company buildings and other kinds of constructional works.', 'National ', 'Nation wide ', 'Long term investment ', 'Ghc10,000', 'Shovels,wheel barrow and head pans ', 'The use of modern equipments in construction ', 'Real estate agents and construction companies ', 'Employment and Train Training services ', 'Machines that can be used to make the working very fast ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(56, 'AKURUGU JOSEPH', 'BBA ACCOUNTING', 'Level 200', '0241260645', 'AKURUGUJOSEPH99@GMAIL.COM', 'SPECULATOR OF CEREALS', 'I am based in the Sefwi-Juaboso district in the Western North Region of Ghana, where farming activities such as cocoa, rice, and maize cultivation dominate. During the harvest periods, the prices for produce like maize and rice are significantly low. As a speculator, I plan to purchase these commodities in large quantities when prices are at their lowest during the harvest. My strategy is to sell them later at higher prices when the harvest season ends, and demand increases. For instance, during the last harvest season, the price of a bag of maize (Size 5) was GHS 500, which later increased to GHS 800 within a few months. Similarly, the price of a bag of rice initially at GHS 300 rose to GHS 500 during the off-season.', 'GENERAL PUBLIC', 'FEW SPECULATORS IN THE BUSINESS ', 'THE PRICE OF SUCH PRODUCT IN THE MARKET CONSTANTLY MOVE HIGHER OVER TIME', 'APPROXIMATELY FIFTY THOUSAND GHANA CEDIS (GHS50,00', 'STORAGE FACILITY AND A TRANSPORT VEHICLE', 'SKILLS NEEDED IN SPECULATIVE BUSINESS INCLUDE RISK MANAGEMENT, MARKET ANALYSIS, NEGOTIATION SKILL, FINANCIAL ACUMEN, AND EFFECTIVE NETWORKING.', 'CAN PARTNER WITH ANY BUSINESS INVESTOR', 'REDUCED HUNGER AND STARVATION DURING CERTAIN PERIODS ', 'E-commerce platforms online marketplaces and websites where rice and maize can be sold directly to consumers or businesses. And inventory management systems like technology that tracks stock levels, orders, Sales, and deliveries to optimize inventory Control.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(57, 'Felix Bryan Afeke ', 'BBA Accounting ', 'Level 300', '0243683253', 'felixbryanafeke@gmail.com', 'Likem?s construction Ltd', 'Building affordable houses,offices companies and factory buildings ', 'Youths from 25-60yrs', 'National ', 'Long term investment ', 'Ghc10,000', 'Shovels,head pans and wheel barrow ', 'Architectural design ', 'Real estate agents and constructional engineers ', 'Social media helps in showcasing some projects that has been worked on ', 'Modern equipment to help ease the Manual works', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(58, 'Solomon Bonney', 'BBA Accounting ', 'Level 100', '0244091707', 'solomonbonney20@gmail.com ', 'BREADYSHOP LTD(fish and food processing)', 'BreadyShop processes and packages quality and wholesome fish and food products leveraging sustainable technology to enrich lives and communities.\nOur  fish products are sold under the brand name BetaFish.They are processed through smoking,frying,salting or grilling to suit the needs of various customers.', 'Busy household, supermarket,corporate bodies,occasions and institutions', 'Fish vendors', 'There greater increase in demand for fish as fpeople are moving toward healthier protien consumption', 'GHC47,000', 'Ahoto fish smoking oven,storage facility  and a delivery tricycle', 'marketing,business management,digital and technical skill ', 'Mary King Supermarket,', 'We are working to ensure we produce wholesome fish and food leveraging environmentally friendly and sustainable technologies while creating employment and enriching communitieyment', 'Our business leverage ecomerce technologies through the breadyshopgh.com plat to market our products and other food product.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(59, 'Nasiba Adam', 'Social Studies ', 'Level 200', '0547606355', 'nasibaadam48@gmail.com ', 'Hair Growth oil and hair growth butter ', 'The hair growth oil and butter will help Ghanaian hair to grow long and thick.it prevents dandruff and also gives a shiny hair ', '500', 'Mariam Hair care', 'For women and if possible beard growth ', 'Through savings ', 'Coconut oil, Essential oils , Ayurvedic herbs. ', 'Planing and organising, self management ', '', 'To help people with hair loss  and grow long and thicker hair', 'House hold mixer', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(60, 'Nancy Aba Sackey ', 'Bsc. Management Education ', 'Level 400', '0538078546', 'sackeynancy785@gmail.com ', 'Production of castor oil and hair growth oil and cream ( operation of Beauty Parlor)', 'Castor oil is a vegetable oil derived from castor seeds which has several medicinal, industrial and pharmaceutical uses. Making of hair growth oil and cream with natural ingredients especially castor oil to help boost healthy hair growth and also aspire to set standard for excellence in beauty services. ', 'Women, Men and Children ', 'Beauticians, oil companies like Borges ', 'The global castor oil market size is projected to reach US$ 1,315.00 million by 2024. The hybridity in hair care for 2024 is the fusion of different products  benefit into one innovative solution, customers are calling for products that cater to a diverse range of hair type and textures', 'GHC 500', 'Castor seeds, cloves, Rosemary,  dry coconut, moringa powder, fenugreek seeds and Olive oil ', 'Cold pressing of castor seed to get the oil, beauty skills', 'Cosmetic company, beauty parlors , pharmacy ', 'Creation of jobs and employment opportunities, social responsibilities', 'Machines to produce castor oil and equipment for beauty services. ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(61, 'GILBERT ESEGBE YAW BRIBINTI', 'BACHELOR OF SCIENCE ACCOUNTING EDUCATION', 'Level 400', '0541829299', 'esegbey2001@gmail.com', 'Poultry Farm', 'Poultry farming is the process of raising domesticated birds especially chickens for various purposes, for meat and eggs. The practice involves breeding, housing, feeding, and managing the health of the bird to optimize production. The vital aspects include selecting appropriate breeds, providing proper nutrition and care, measures to prevent diseases and ways of managing waste effectively.', 'Industrial buyers for example schools, restaurants, households, and more', 'Poultry farming faces a number of competitors which includes local and industrial domestic poultry producers, and poultry products importers.', 'Poultry market is influenced by a number of factors which mainly includes increased demand for the product, technological advancement, plant-based alternatives, and health and wellness focus', 'Twenty Thousand Ghana Cedis ', 'The resources required for this project includes land and infrastructure, equipment, livestock, feed and nutrition, health management, labor, financial resources, technology and information.', 'Health management, feed formulation (balance diet), farm management, equipment operation and maintenance, record keeping, critical thinking and problem solving, marketing and communication.', 'I will partnership with research and veterinary institutions, feed manufactures, financial and Non-Governmental Organizations and export companies.', 'I been given this opportunity, I will impact socially through employment, nutritional improvement, women empowerment, Corporate Social Responsibility, and others.', 'Technological elements needed includes breeding technologies, climate control systems, waste management systems, data management software, monitoring technologies.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(62, 'David Kobina Taylor', 'Graphic Design', 'Level 200', '0204172813', 'daviddisc79@yahoo.com', 'Taylor Farms', 'Taylor Farms focuses on breeding, raising, and selling pigs and pork products, utilizing sustainable farming practices to ensure high-quality meat and positive environmental impact.', 'Taylor Farms targets a wide range of markets, including speciality markets, individual consumers, and neighbourhood butchers. Taylor Farms may customise its marketing strategy to effectively reach and engage each group by knowing the unique needs and preferences of each one. This will help the company develop its customer base and foster customer loyalty.', 'Adjei Farms, Asase Pa Farms', 'Growing Demand for Pork Products, Health and Quality Consciousness, Sustainable and Organic Farming, Value-Added Products', '2,000.00 Ghanian cedis', '1. Land and Infrastructure ?	Land: Suitable for farming, with adequate space for barns, feed storage, and waste management systems. ?	Pig Barns: Well-ventilated and secure structures to house the pigs. ?	Fencing: To secure the farm perimeter and prevent animals from escaping. ?	Water Supply System: Reliable water source for drinking, cleaning, and irrigation. ?	Waste Management System: Proper disposal and recycling of animal waste to maintain hygiene. ?	Feed Storage: Dry and secure storage for feed and supplements. ?	Power Supply: Stable electricity supply for running equipment and lighting. 2. Equipment and Tools ?	Feeding Systems: Automatic or manual feeders and waterers. ?	Health Monitoring Tools: Thermometers, weighing scales, and other veterinary tools. ?	Cleaning Equipment: Pressure washers, brooms, and disinfectants for maintaining cleanliness. ?	Transportation: Vehicles for transporting feed, pigs, and other supplies. 3. Breeding Stock and Genetics ?	Breeding Stock: High-quality sows and boars for starting the herd. ?	Genetic Material: Access to good breeding lines for genetic improvement. 4. Feed and Nutrition ?	Feed: High-quality commercial pig feed or ingredients for formulating feed. ?	Supplements: Vitamins, minerals, and other nutritional supplements. 5. Human Resources ?	Farm Manager: Experienced individual to oversee farm operations. ?	Farm Workers: Skilled labor for feeding, cleaning, and general maintenance. ?	Veterinarian: Part-time or full-time vet for health management and emergencies. ?	Marketing and Sales Staff: Personnel to handle sales, customer relations, and marketing. 6. Financial Resources ?	Capital: Initial investment for land, infrastructure, breeding stock, feed, and operating costs. ?	Operating Expenses: Ongoing costs for feed, labor, utilities, veterinary care, and marketing. 7. Technology and Management Systems ?	Farm Management Software: For tracking inventory, health records, and financials. ?	Breeding Management Tools: To monitor and manage breeding cycles and productivity. ?	Biosecurity Measures: Systems and protocols to prevent disease outbreaks. 8. Regulatory and Compliance ?	Permits and Licenses: Necessary legal documentation to operate the farm. ?	Environmental Regulations: Compliance with local environmental and waste management regulations. ?	Health and Safety Standards: Adherence to health and safety guidelines for workers and animals. 9. Market and Distribution ?	Market Research: Understanding the demand, pricing, and competition in the local market. ?	Distribution Channels: Establishing connections with butchers, supermarkets, restaurants, and direct consumers. ?	Branding and Marketing: Creating a brand identity and marketing materials to attract customers. 10. Miscellaneous ?	Contingency Fund: Reserve funds for unforeseen expenses and emergencies. ?	Insurance: Coverage for livestock, property, and liability', 'Animal Husbandry skills, Business Managment Skills, Technical Skills, Leadership and Communication Skills, Problem solving skills, Requlatory and Compliance Knowledge, Customer Service Skills, Operation skills, Innovation and Continuous Learning, Technical knowledge ', '1. Feed Suppliers ?	Agricare Limited: A leading manufacturer of animal feed in Ghana. Partnership for consistent, high-quality feed supply. ?	Raanan Fish Feed West Africa: Known for quality feed production, they can provide specialized feed solutions. 2. Veterinary Services ?	Veterinary Services Directorate (VSD): A government body providing veterinary services, health programs, and disease control. ?	KNUST Veterinary Teaching Hospital: Offers veterinary services and could be a partner for health management and emergency services. 3. Marketing and Distribution ?	Shoprite Ghana: Establishing supply agreements for pork products in their stores. ?	MaxMart Family Shopping Center: Partnering with local supermarkets to supply fresh pork products. ?	Local Butchers and Meat Markets: Collaborating with butcher shops in major cities like Accra, Kumasi, and Takoradi. 4. Processing and Packaging Companies ?	Sibton Food Company: Known for meat processing and packaging; can help in creating value-added pork products. ?	Multivet Processing and Packaging Limited: Provides services for processing and packaging meat products. 5. Financial Institutions ?	Agricultural Development Bank (ADB): Known for supporting agribusinesses with loans and financial products. ?	Ghana Exim Bank: Provides financial assistance to businesses involved in export-oriented agriculture. 6. Logistics and Transportation ?	McDan Shipping Company: Partnership for efficient transportation of products and supplies. ?	DHL Ghana: For reliable logistics and cold chain solutions. 7. Technology and Farm Management Systems ?	Esoko: Provides digital solutions for agriculture, including market information and farm management tools. ?	Farmerline: Offers technology solutions for farm management, including data collection and analysis tools. 8. Environmental and Sustainability Organizations ?	Environmental Protection Agency (EPA): Partnering for sustainable farming practices and environmental compliance. ?	Ghana Green Building Council: Collaboration for eco-friendly initiatives and sustainable farm infrastructure.', 'Employment Opportunitie, Econimic Growth, Community Development, food Security, Sustainable Practices, Health and Well-beign, Local Supply chains', '1. Farm Management Software Farm Management Systems: Software solutions for tracking livestock, feed, health records, and financials. Examples include AgriWebb or Trimble Ag. Data Analytics: Tools for analyzing data to make informed decisions regarding herd management, feed optimization, and financial planning. 2. Automated Feeding Systems Feed Dispensers: Automated systems that ensure precise feed delivery to pigs, reducing waste and optimizing feed efficiency. Watering Systems: Automated waterers that provide consistent and clean water, essential for pig health and growth. 3. Health Monitoring and Management Wearable Sensors: Sensors that monitor the health and activity of pigs, tracking metrics such as temperature, movement, and behavior. Health Management Systems: Software that helps track vaccinations, treatments, and overall herd health. 4. Breeding Technology Artificial Insemination (AI): Advanced breeding techniques to improve genetic quality and productivity of the herd. Genetic Management Tools: Software and tools for managing breeding programs and genetic data. 5. Biosecurity Technology Monitoring Systems: Surveillance cameras and sensors for monitoring the farm?s biosecurity and preventing disease outbreaks. Disinfection Systems: Automated systems for cleaning and disinfecting barns, equipment, and facilities. 6. Waste Management Manure Management Systems: Technologies for efficient handling and processing of manure, such as composting systems or biogas production. Waste Recycling: Systems for converting waste into useful products like fertilizer or energy. 7. Climate Control Ventilation Systems: Automated ventilation and climate control systems to maintain optimal environmental conditions for pig growth. Temperature Monitoring: Sensors and control systems for maintaining appropriate temperature and humidity levels in pig housing. 8. Supply Chain and Logistics Inventory Management Systems: Software for managing feed, supplies, and equipment inventory efficiently. Logistics Tracking: GPS and tracking systems for monitoring transportation of pigs, feed, and other supplies. 9. Processing and Packaging Processing Equipment: Modern machinery for processing pork into value-added products like sausages, bacon, and ham. Packaging Technology: Advanced packaging systems that ensure product freshness, safety, and quality. 10. Precision Farming Drones: Drones for aerial monitoring of farm conditions, crop health (if applicable), and infrastructure. GIS (Geographic Information Systems): Tools for mapping and analyzing farm data to optimize farm management practices. 11. Communication and Connectivity Mobile Applications: Apps for farm management, communication with staff, and real-time updates on farm operations. Internet of Things (IoT): IoT devices for real-time monitoring and data collection from various farm elements. 12. Consumer Engagement E-commerce Platforms: Online platforms for selling pork products directly to consumers. Social Media and Digital Marketing: Tools for marketing, brand building, and customer engagement.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(63, 'Dabuu Daniel Mckeown', 'Mphil Entrepreneurship and innovation', 'MPHIL', '0541446681', 'ddmckeown1@gmail.com', 'Mckeown Global Company Limited', 'We produce the following items: Ointment that cure wounds and all forms of skin diseases, we installed permanent Biodigester toilet, carrot shower gel, mollasses for brown sugar, organic fish farming, snail rearing, and fresh youghurt ', 'The youth, Adults, farmers, and all segments of Ghanaians', 'Supper A1 company', 'Ghanaians and the world at large are shifting from chemical products to organic products ', 'MGC. LTD', 'Start up capitals, shower gel production machines, laptop, projector and projector screen, plastic pound', 'IT personnels, procurement and operation officer, innovation and entrepreneurial skills', 'The church pf pentecost, solidaridad international, Compassion Ghana, UEW', 'Source of income, creation of employment, solving health issues', 'Shower gel production machine, laptops, projector and printing machine for stickers', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(64, 'Daniel Appianing ', 'Bachelor of Science (Accounting Education)', 'Level 400', '0544904311/0540', 'danielappianing43@gmail.com', 'KAD Fish Farms: Sustainable Fish Farming for the Future ', 'KAD Fish Farms is dedicated to revolutionizing the aquaculture industry through sustainable and eco-friendly practices. Our mission is to provide high-quality, fresh fish while minimizing environmental impact and promoting the well-being of aquatic ecosystems. By leveraging innovative farming techniques and renewable resources, KAD Fish Farms aims to meet the growing demand for seafood in a responsible and sustainable manner.\n\nAt KAD Fish Farms, we utilize advanced aquaculture technology to ensure optimal fish health and growth, while also implementing water recycling systems and natural feed alternatives to reduce waste and enhance sustainability. Our commitment to sustainability extends to every aspect of our operations, from hatchery management to harvesting and distribution.\n\nWith a focus on community engagement and education, KAD Fish Farms strives to raise awareness about sustainable aquaculture and its benefits. By partnering with local communities and stakeholders, we aim to support economic development and create a positive impact on the environment.\n\nKAD Fish Farms is not just a business; it\'s a movement towards a sustainable future in fish farming, ensuring that future generations can enjoy the bounty of the oceans without compromising their health and integrity.', '1.Local consumers 2. Restaurants and Food Services 3. Retail Outlets   4. Wholesale Distributors', '1. Local fish farms  2. Regional fish farms  3. International fish farms  4. Wild-caught fisheries  5.Alternative protein producers 6.Local fish markets and retailers 7. Direct-to-consumer brands.  ', 'KAD Fish Farms operates within a market increasingly focused on sustainable and traceable seafood, driven by health and wellness trends. Technological advancements and the rise of aquaponics enhance efficiency and sustainability. There is growing interest in alternative seafood products, both plant-based and lab-grown. Global export opportunities and regulatory compliance are crucial, alongside consumer education and engagement. Economic factors necessitate balancing sustainable practices with competitive pricing.', 'GH?91,700 - GH?100,000', '1. Land and infrastructure  2.Equipment and technology  3.Stock and feed  4.Operational costs  5.Licensing and permit   6.Financial and administrative resources  7.Health and safety measures  and  8.Marketing and distribution', '1. Aquaculture knowledge  2.Water management  3.Technical skills  4.Business management  5.Marketing and sales  6.Health and safety  7.Problem-solving and  8.Regulatory compliance', '1. Local Farmers and cooperatives 2. Government agencies  3.Academic and research institutions  4.Supply chain partners  5.Retailers and distributors  6.Environmental organizations  7.Community organizations and  8.Investors and financial institutions', '1. Job creation 2. Economic development  3.Food security  4.Skill development  5.Community engagement  6.Sustainable practices  and 7.Health benefits  8.Support for local businesses', '1. Water Filtration Systems  2.Aeration Equipment  3.Monitoring and Control Systems  4.Feeding Systems  5.Recirculating Aquaculture Systems (RAS)   6.Automated Harvesting Tools  7.Data Analytics and Management Software  and 8.Water Quality Testing Instruments', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(65, 'Isaac Arthur', 'B.Sc. ICT Education', 'Level 300', '0540796861', 'isaacart18@gmail.com', 'PLASTIGEM', 'PLASTIGEM aims to tackle the pressing issue of plastic waste by establishing a comprehensive recycling system that collects, processes, and repurposes plastic materials. Our mission is to reduce environmental pollution and promote sustainability through innovative recycling solutions and community engagement. By transforming plastic waste into valuable resources,  PLASTIGEM will contribute to a cleaner, healthier environment while creating economic opportunities.', 'PLASTIGEM will primarily serve: Households Hospitality and tourism establishments. Businesses Educational Institutions Ministries Government departments and agencies, Metropolitan, Municipal, and District Assemblies (MMDAs) or local authorities, as well as the communities within our reach.', 'Zoomlion Ghana Limited Coliba Ghana MiniPlast Limited Jekora Ventures NelPlast Ghana Limited  Municipal Waste Services  Non Profit Organizations', ' 1. Growing Environmental Awareness. 2. Government Policies and Regulation. 3. Rise of Eco-Friendly Products. 4. Investment in Recycling Infrastructure. 5. Technological Advancements leading to Innovative Recycling Technologies. 6. Increased Corporate Social Responsibility (CSR). 7. Youth Involvement and Activism. 8. Circular Economy Models.', 'To launch  PLASTIGEM, an estimated initial capital', 'Collection Vehicles: Trucks and tricycles for collecting plastic waste from various sources. Containers: for collecting plastic waste at various collection spots.     Recycling Machinery: Machines for sorting, cleaning, and processing plastic waste.     Technology Systems: Software for tracking and managing recycling operations.     Human Resources: Skilled staff for operational, administrative, and outreach roles. Recycling Facility', 'Waste Management Expert. Mechanical Engineer. Project Manager. Community Engagement Specialist. Business Development Manager. Environmental Scientist. Marketing and Communications Specialist. Software Developer. Logistics Coordinator.', 'Zoomlion Ghana Limited Coliba Ghana MiniPlast Limited Jekora Ventures NelPlast Ghana Limited  Municipal Waste Services  Non Profit Organizations', 'PLASTIGEM aims to create a significant positive social impact by:      Reducing Environmental Pollution: Decreasing plastic waste in landfills, water bodies and natural environments.     Promoting Sustainability: Encouraging sustainable consumption and production patterns.     Creating Jobs: Providing employment opportunities in the recycling sector.     Raising Awareness: Educating communities about the importance of recycling and environmental stewardship.', 'Recycling Technology. Data Management Systems.     Innovative Solutions.     Mobile Applications.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(66, 'Dankwah Godfred ', 'Geography ', 'Level 400', '0550430920', 'Dankwahgodfred47@gmail.com', 'Freeman Palm Tree Planting and Palm Oil Production', 'Free man aims to establish a sustainable palm tree plantation focused on producing high-quality palm oil while promoting environmentally friendly practices. The business will utilize innovative agricultural techniques to ensure that the palm oil production is sustainable and socially responsible, addressing both market demand and environmental concerns.\n', '1. Food Industry: Manufacturers of cooking oils, margarine, and processed foods. 2. Cosmetics and Personal Care: Companies producing beauty products that require palm oil as an ingredient.  3. Biofuel Industry: Firms looking for sustainable sources of biodiesel.  4. Retail Consumers: Eco-conscious consumers seeking sustainably sourced products.', '1. Established palm oil producers with large plantations.  2.  Local farmers producing palm oil on a smaller scale.  3. Alternatives to palm oil producers (e.g., canola, sunflower, and soy oil producers).  4.  Companies focusing on organic and fair-trade certifications.', '1.Demand for sustainably sourced palm oil rises due to consumer awareness and environmental regulations. Biofuel sector growth increases demand for palm oil as a renewable energy source.', 'Gh 20,000', '1. Land:for palm tree cultivation. 2.  Seeds: High-yield, disease-resistant palm tree seedlings. 3.  Equipment:tools, and oil extraction machinery. 4.  Labor: Skilled for planting, maintenance, and processing. Water Supply: 5. Access to irrigation or natural sources.', '1. Expertise in palm cultivation and management. 2. Knowledge of sustainable farming practices. 3. Experience in oil extraction and processing. 4. Business management skills for operations and marketing.', 'Demand for sustainably sourced palm oil rises due to consumer awareness and environmental regulations. Biofuel sector growth increases demand for palm oil as a renewable energy source.', '1.Job creation in local communities via plantation management and processing facilities. 2. Sustainable agriculture practices promoted to reduce deforestation and environmental degradation. 3. Support for local economies through sourcing labor and materials locally. Education and training programs for local farmers on sustainable practices.', 'Demand for sustainably sourced palm oil rises due to consumer awareness and environmental regulations. Biofuel sector growth increases demand for palm oil as a renewable energy source.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(67, 'Dagour Abdul Waris ', 'Bs A social studies ', 'Level 300', '0505261226/0551', 'dagourabdulwaris1@iclous.con', '1. Punches and juice 2. Dagsons motor parts ', '1. Punches and juice: organic juice from variety of fruits \n\n\n2. Motors parts: repairs and sale of spare parts ', 'I should be one of the most patronage juices and  punches in Accra in the next five years ', 'Mag Davis juice and bakery Spintex, ', '', 'Ghc5000.00', 'Skilled personalities, funds and a permanent location ', 'Yes, ', 'With the motors spares parts, I have partnered with apsonic motors Klagon and Tema royal motors ', 'Employment and and training ', 'Refrigerator, blenders and many more.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(68, 'Emmanuel Dadzie', 'B.Sc Accounting Education ', 'Level 400', '0543821009', 'dadzieemmanuel084@gmail.com', 'Woodwork ', 'Construction and installation of wardrobes and let hen cabinets, beds etc', 'Those with middle level of socioeconomic status', 'Local carpenters', '', 'Ghc 10000', 'Electric saw, planer, drill, chisel etc', 'Training ', 'Local carpenters', 'Training and mentoring the upcoming youth ', 'Electric equipment', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(69, 'Kweku Annan ', 'Accounting ', 'Level 300', '0555078079', '220000033@st.uew.edu.gh', 'Poultry farm ', 'Rearing poultry chicks into poultry birds either for their meat or for laying of eggs ', 'Restaurant and any other place that would be needed ', 'Existing poultry farmers ', 'High demand ', 'Gh? 25,000', 'Land, wood and any other materials that would be needed in building a pen ', 'Animal husbandry skills and farm management skills ', 'Other farmers ', 'Source of employment ', 'Egg collection ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(70, 'Dagour Abdul Waris ', 'Bachelor of Arts (social studies education)', 'Level 300', '0505261226/0551', 'dagourabdulwaris1@icloud.com', 'DAGSONS MOTORCYCLE SHOP ', 'Dagsons motorcycle shop will offer quality services such as repairs maintenance and modifications. Quality motor parts will be made available to its valued customers ', 'The primary target consists of young people of the Tema municipality and nearby areas. This segment is made of 15-28 years that are active and participate regularly in outdoor activities.', 'Increasing manufacturing and sales of motorcycle across the globe is projected to augment the demand for motorcycle accessories over the forecast. The increasing popularity of motorcycle among the youth is one of the major factor expected to drive growth of the market demand for motorcycle accessories ', 'Motorcycle market is always evolving. The latest trend is the growing demand for transportation which can avoid heavy traffics in the urban areas and more convenient to travel in remote areas. Another latest trend is the dependency on bikers for delivery services ', 'Ghc5000.00', 'Human capital and funds ', 'People with fair knowledge about accessories, electricians etc', 'Dagsons motorcycle shop has partnered with apsonic Ghana, Somocco Ghana and  royals motors ', 'Sources of employment to the youth to learn skills ', 'Machines and tools for motorcycle operations , trackers installations etc', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(71, 'Bismark Okine ', 'Accounting ', 'Level 300', '0592688976', 'bismarkokine00@gmail.com', 'Agriculture and industries ', 'Encouraging farming and industrialization ', 'Youth and the market at large ', 'Others already producing ', 'Sustainable agriculture ', '20,000 cedis', 'Working tools and inputs ', 'Farm management, livestock management and factory operating skills ', 'Suppliers of inputs,buyers and service providers ', 'Employment opportunities and food security ', 'Irrigation system ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(72, 'Elizabeth Kwaaley Otoo', 'Linguistics and Ga Education ', 'Level 200', '0573911490', 'scrupulousnanaadjoa@gmail.com', 'Local drinks ', 'I want to produce local drinks and sell them and also help people to learn it which will also create some revenue for them too ', 'Campus and beyond ', 'The Nation as a whole ', 'I want to do delivery and give discount to people who will order in large quantity and also create an app that will make people get in touch with me easily ', 'Ghc 500', 'Table top deep freezer ', 'Not much skills needed ', 'My friends', 'I want to train people so that they will also get something to depend on', 'Deep freezer', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(73, 'WISDOM AWUMEY', 'BA BRAPHIC DESIGN', 'MPHIL', '0546687530', 'wisdomawumey@gmail.com', 'Happily', 'Happily is an App that will help save lots of lives and provide for those in need. The app is designed to allow anyone upload pictures of items they no longer need or have in excess.\n\nOnce you upload an item for example cloths, food stuff or any other item you no longer need, orphanages and charity organizations can log onto the App and request to have those items for free.\n\nIndividuals can also log into the app and donate any amount that will be used to support orphanages. ', 'Orphanages and Non Governmental Organizations ', 'No competitors', 'Growth of Social Media and Crowdfunding Sites: The exposure of philanthropic causes has been greatly enhanced by the widespread usage of social media and crowdfunding sites. The app will benefit from the rise of social media to attract and involve new contributors and increase awareness. Also there will be Real-Time Tracking Donor Dashboard which will provide donors with a dashboard where they can see real-time updates on how their contributions are being used. ', 'None', 'Software Development (App development team, Server hosting and Database Management), Financial Resource (Development, marketing and Promotion cost), Infrastructure for Orphanages (Build relationships with orphanages and ensure they are onboard with the app\'s processes. Also providing systems for collecting and verifying information from orphanages to ensure transparency and proper fund allocation.', 'Software and Web Development Skills, Graphic and User Interface Designing Skills, Project Management and Marketing Skills.', 'Organizations focused on child welfare and education in Ghana, such as The Ghanaian Children?s Fund or Help Ghana Foundation. Financial Institutions like Ecobank Ghana or Standard Chartered Bank.', 'Improved Welfare for Orphans, Empowerment and Personal Growth, Local Employment (Building and maintaining the app can create jobs in tech, marketing, and support sectors)', 'App Development, Security, User Interface and User Experience (UI/UX), Backend Infrastructure.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(74, 'Evelyn Baffoe Otoo ', 'Political science ', 'Level 300', '0542724754', 'Efuayeboah1999@gmail.com', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(75, 'Emmanuel Pedu Acquah ', 'BBA ACCOUNTING ', 'Level 300', '0556369038', 'emmanuelacquah9038@gmail.com', 'Fish ponding or farming ', 'I would like to start fish farming business . Fish farming is the process of raising or cultivating fish for food or income generation in controlled environment such as ponds and tanks. ', 'The local market and whole sale markets mostly in the various regions', 'Those who are already into fish farming and importers of frozen foods ', 'Increasing interest in fish farming and  growing demand for protein rich foods. ', 'Ghc 10,000- 50,000', 'Land and water, fish feed and seeds, machinery and equipment to filter water', 'Fish farming management, quality water management and marketing and sales ', 'Government and other investors , private sector companies and others. ', 'To create jobs,  food security and nutrition improvement ', 'Fish feeding and health management, systems, pond design and construction ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(76, 'Augustina Agama ', 'Human Resources management ', 'Level 300', '0247500115', 'augustinaamaagama44@gmail.com', 'Farm fusion ', 'Augustina Agama, a level 300 university student, shares her dream of becoming a successful entrepreneur in agriculture. Inspired by Nelson Mandela\'s quote, I aim to start a small-scale farm after completing my national service. I have highlighted key factors to consider when setting up a farm, including capital, demand, location, land, labor, and competition. I express excitement about the opportunity to turn my dream into reality and am eager to start my business venture. With a passion for farming and a clear vision, I am determined to make my dream a success.', 'Local consumer, restaurants, school and institutions and many more.', 'Other local farmers and  agriculture producers etc ', 'Consumer behavior,direct market etc ', '5000 -8000', 'Land, funds ,water equipment and many more ', 'Agriculture knowledge, physical labor, Business management and many more ', 'Farmer\'s cooperative, Government, Agriculture suppliers and many more.', 'To provide food security: Ensures access to fresh, healthy produce for local populations.', 'Drones, livestock, cutlasses, weed killer etc', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(77, 'Adjei partison', 'BBA Human Resources management ', 'Level 300', '0596340060', 'partisonadjei485@gmail.com', 'Electrical appliances ', 'Adjei Partison, a level 300 university student in Business Administration, was involved in the electrical appliances business before university and has continued to finance my education through it since 2021. I started with a $2,000 liability but was able to clear it and generate a $2,655 profit within six months. I have strategies to enhance sales, making customers proud to buy from me. I am so passionate about the business, believing every household needs electrical appliances. My aim is to expand and grow the business, driven by a sense of responsibility to my brother who supported me.', 'Hotels, bars, school institution, financial institution and household ', 'Local electrical shops', 'Increased in demand of energy saving light', 'Ghc7,000 - 10,000', 'Testing equipment, skilled labor and initial store room rent', 'Electrical engineer interns of installation of electrical appliances ', 'Customers and manufacturing companies ', 'Provide high quality of electrical appliances to household and business focusing on energy efficiency and durability ', 'Smart homes and home automation ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(78, 'AMPONSAH GODFRED', 'BACHELOR OF BUSINESS ADMINISTRATION ( BUSINESS INFORMATION SYSTEM ', 'Level 100', '0546687271', '5241510035@st.uew.edu.gh', 'Premium Poultry and Processing solutions ', 'Premium Poultry and Processing Solutions is to establish an integrated poultry processing business that will collaborate with the local poultry farmers to provide high-quality poultry product to our country to enhance economic growth and sustainability.', 'The local and international market', 'No well know competitors  ', 'The local cold stores import from outside the country ', 'Ghs 30,000.00', 'Capital, Land, Machines and Workers', 'Business Management, Food Safety, Poultry Science, etc.', 'Any legal organisation or individual ', 'To provide employment to the youth ', 'Feeding trough, Water trough, Data entry system ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(79, 'Emmanuel Gottfried Dartey ', 'Bsc. Accounting Education ', 'Level 300', '0595208773', 'okoffodartey19@gmail.com', 'NexGen Technology Services ', 'Its a Tech solution business which design databases and systems for organisations, schools and businesses with information technology deficiency. ', 'Organizations, schools, churches and private businesses', 'Nil', 'It is a fast growing demand since everything is becoming digital in the global community ', 'Gh 3000', 'Human resources, financial resources, technology infrastructure, intellectual property,remote work tools, data protection tools.', 'Software developer and engineers, data scientist, system architects, cloud services, IT support, project manager, sales representative,marketing specialists,legal advisors ', 'Yes. I currently have 2 other people I work with ', 'Save the quantity of trees being sawed down to make papers for printing reports and information. ', 'Development tools, program language and framework,security information and event management, analytics and monitoring tools,databases,APIs, ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `proposals` (`id`, `full_name`, `programme_of_study`, `level`, `contact`, `email`, `business_idea_title`, `brief_description`, `target_market`, `competitors`, `market_trends`, `initial_capital`, `required_resources`, `skills_needed`, `potential_partnerships`, `social_impact`, `technological_elements`, `member1_name`, `member1_programme`, `member1_level`, `member1_email`, `member2_name`, `member2_programme`, `member2_level`, `member2_email`) VALUES
(80, 'Antwi Emmanuel', 'Geography', 'Level 400', '0248469351', 'emmanuelantwi3693@gmail.com', 'Cassava processing', 'With a brief description of my business proposal , which is cassava processing business that I believe has the potential to be both profitable and beneficial to the community. \nExecutive summary\n\nUnlocking the Potential of Cassava: Christ co will be  one of  pioneering local cassava processing business transforming Asankrangwa  abundant cassava resources into high-quality gari and value-added products. Such as starch, cassava flour, cassava dough and animals feed Our mission is to empower local farmers, drive economic growth, and satisfy the increasing demand for cassava products.\n\n\nMission\n\nMy mission is to become a leading supplier of cassava products in Asankrangwa and also promoting sustainable agriculture and contributing to the local economy.and also\nearn a position in consumers? minds as a manufacturer of high-quality cassava flour, starch gari. The business will do this by producing products that have an authentic quality. \n\nHow to achieve this mission\n\nTo achieve this mission, I have position my self to take full responsibility to make this business grow.\n\n\nProblem statement\n\ncassava is a staple crop with great economic potential, yet its processing and value addition remain.  Embryonic.   Local farmers face significant challenges in accessing efficient processing facilities, as a result of this they face post harvest loses lead to cassava waste and economic loses\nunready market of cassava also constraint farmers money and livelihood which push them to give their farming lands to small scale mining.\nFinally must of the local cassava process business cause environmental pollution with the cassava peels .\n\nHow to solve the problem\n\nOur local cassava processing business aims to address these challenges, providing a sustainable solution that benefits farmers, consumers, and the environment as a whole. We will process the peels. Into animals feel so nothing will let to cause environmental pollution. We will also buy the cassavas from the farmers so that it help them to raise their standard of living.\n\nFinancial statements\n\nWith your financial support, I am confident that I can bring this vision to life and create a venture that will not only generate returns for investors but also provide economic opportunities for the surrounding area. \n But I have been able to get the land for the for the production and also two thousand Ghana cedis out of the ten ten thousand that am looking for  to make this business come to life.\n\nMarketing Strategies\n\n- Develop a strong online presence through social media and e-commerce platforms\n   Which will help us to over take the market.\n- Implement a loyalty program and referral scheme to retain customers\n- Offer competitive pricing, discounts, and promotions to drive sales\n\nDistribution Channels\n\n- Direct sales to consumers through our social media platform and physical outlets\n- Partnerships with local retailers, wholesalers, and distributors\n- Supply agreements with hotels, restaurants, and institutions\n\nMarketing Objectives\n\n- Increase brand awareness by 20% within six months\n- Develop strategic partnerships with key stakeholders (farmers, and distributors or the trades).\n\n\n', 'markets in Asankrangwa a focus on it sub township and it surrounding village?s.', 'Base on the information that we have as small business , we will create competitive advantage in a sense that we will create room to learn from big company who are into production and also develop a hybrid service for our customers.which will help us to overtake some of the local cassava processing business.', 'our maket trend Will be on how we will parkage our product , will help us to dominate in the local market.', 'Ten thousand Ghana cedis', 'Machine for processing of the cassava , labor and money.', 'How to operate the cassava processing machine', 'With the local farmers and trader', 'This business will create job for some of the local people and also bring togetherness among the local farmers . ', 'We put system in place to best practices in the market.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(81, 'Valentine Adjei ', 'Banking and finance ', 'Level 100', '0552477870', 'valentine.adjei.11@gmail.com', 'Easy access to hostel accommodations.', 'An online platform that will make access to hostel facilities easy. This platform will give students the opportunity to preview and book hostel accommodation. ', 'Students ', 'Other hostel booking websites focusing on Ghana.', 'There is a growing trend of online booking platforms for hostels in Ghana, making it easier for students to find and book accommodations. Also, there is a high demand accommodations in Ghana, especially in Winneba. ', 'GHS 50,000 - GHS 150,000', 'Web developer, web designer, web hosting service,  domain registration, payment hostage integration,  online booking integration,  database management system, reliable Internet connection,  communication tools, computer hardware and software. ', 'Web development, web design, project management, search engine optimisation and marketing skill', 'Hostels and guesthouses, tourism boards, travel agencies, payment gateways,  local businesses, educational institutions, government institutions, technology companies. ', 'Job creation, empowerment of local communities, increased accessibility, support for local entrepreneurs, economic growth. ', 'Website platform, database management system, payment gateway integration, online booking system, search engine optimisation tools, email marketing software, mobile friendly and responsive design,  secure sockets layer certification for secure transactions, cloud hosting,  API integrations, website security measures. ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(82, 'PRINCE AINOOSON', 'PROCUREMENT AND SCM', 'Level 100', '0541793307', 'Prince_jnr@icloud.com', 'Campus TRIMZ', 'Our business aims to establish a small barbering shop on campus to provide students with convenient, affordable, and high-quality haircuts without having to leave campus. This service addresses a common need among students for accessible grooming options and capitalizes on the flexibility of my class schedule to provide consistent availability.', 'Student (primary,tertiary) and lecturers', 'Off campus barber', '1.Demand for barbering service. 2. Social media and online booking. 3. Affordability and value. 4. Partnership with student organizations. 5. Loyalty', '1900', '1. Barbering equipment. 2. Products and supplies. 3. Technology. 4. Facility and space.', '1. Technical barbering skills. 2.Communication skills. 3.customer service skill. 4. Time management. 5.Sanitation and Safety skills', 'Student organizations ', '1.Community building. 2. Stress relief. 3.skill development. 4. Economic empowerment.', '1. Online booking. 2.Digital payment. 3. Social media tools.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(83, 'Adutwumwaa Morosa jessica and justicia senyo ', 'Human resource management ', 'Level 300', '0553182010', 'jessicaadutwumwaa700@gmail.com', 'Beauty goals hub ', 'Beauty goals hub focuses on body and skin enhancement products and beauty therapeutic treatment precisely to boost the self confidence of both genders. Not only enhance beauty but educate and offer employment opportunities and training and retraining programs to help curb unemployment in the country , with the aim of helping students have a side hustle outside their field of study . ', 'Students both genders and we?ve been able to establish 3 branches in some of the most prestigious universities in Ghana and were looking forward to have a branch across the country ', 'We?re looking forward to have a monopolistic company through the sales of beauty vouchers and discount treatment to clients but some of our competitors can be Online beauty platforms , individual beauty professionals such as students ', 'Social media advertisement and sales of beauty vouchers purposely to increase sales ', '1000', 'Facial steamers, skincare products , makeup and makeup removals , hair stations , software and technology, staff and training ', 'Communication skills , product knowledge , client consultation ', 'With highly esteemed firms who are into the production and training of beauty therapeutic products and services ', 'Improves mental health, support self care , enhance social connections ', 'Beauty therapy technological elements such as ultrasound to clean pores, led lights therapy and micro current to improve skin tone ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(84, 'Sika Kove And Ezekiel Kwandoh', 'BBA marketing&entrepreneurship', 'Level 300', '0549501995', 'koveblaise222@gmail,com', 'BotaniCalm ,A natural soother for burns, scars and acnes', ' Harnessing the power of plantain leaf extract, BotaniCalm heals acne, soothes burns, and fades scars. Plantain leaf promotes skin health by soothing and alleviating conditions like insect bites, rashes, burns and scars with its natural anti-inflammatory and antimicrobial properties aiding in healing.', '1.Individuals who are actively looking for natural, effective skincare solutions.2. Those who value plant-based products and holistic wellness.3.Teenagers and adults dealing with acne breakouts.4. people with sensitive skin looking for gentle nonirritant skincare 5.Individuals recovering from burns, cuts, or surgical procedures.6.Environmentally aware customers who prefer sustainable, cruelty-free products.', 'Lanbena, A Chinese skincare brand,Palmers ,and Bio- Oil ', 'Consumers increasingly seek sustainable, eco-friendly skincare options. Brands emphasizing clean ingredients and ethical practices gain traction in the market.', 'range of 1500Ghc - 3000Ghc', 'supply of plaintain leaves, an extracter,scale for measuring , cylinder and measuring cups for mixing,preservatives,bottles for storage and sealing', 'cosmetic chemistry and formulation techniques. Knowledge on how other botanical ingredients that complement plantain.industry standards for skincare safety. Business and Marketing Skills', 'cosmetic chemist, dermatologist, local farmers etc', 'Certainly! Here\'s a concise paragraph combining those two points:  \"*BotaniCalm, with its locally sourced plantain leaf extract, not only benefits the skin but also uplifts our community. By supporting local farmers and creating employment opportunities, we contribute to the local economy. Moreover, tying our product to botanical knowledge fosters civic pride,a shared sense of connection to our natural resources. As community members rally around BotaniCalm, it becomes more than skincare; it\'s a symbol of our region\'s resilience and well-being.', ' formulating ingredients to create safe and effective products considering factors like other ingredients that could compliment the plaintain extract,, and product quality', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(85, 'Ubaiya Ibrahim Dimmie', 'Procurement and supply chain management ', 'Level 100', '0593436430', 'ubaiya@yahoo.com', 'Agricultural inputs supply and profit sharing margin for northern Ghana women farmers ', 'My proposal aims to empower women in Ghana by providing comprehensive agriculture support, enhancing their productivity and improving their livelihoods. Our mission is to bridge the gender gap in agriculture, increase food security and foster sustainable development in the Region. ', 'Small scale farmers and women farms association ', 'Woman right organization and microfinance institutions', 'Precision agriculture and sustainability and organic farming ', '15000', 'NPK fertilizers, weedicides and pesticides. ', 'Manual labor and pest control ', 'Agric companies ', 'Reduce unemployment among women. ', 'Robotics and automation ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(86, 'NAPOLEON KWEKU ESHUN', 'BBA MARKETING AND ENTREPRENEURSHIP', 'Level 400', '0555377817', 'REVERENDNAPO22@GMAIL.COM', 'NGO D_W', 'We aim to produce and distribute sustainably sourced palm oil infused with cloves, ginger, cinnamon, and onion, ensuring good health, environmental conservation and supporting local farmers. The initiative focuses on reducing deforestation, promoting fair trade practices, encouraging oil palm farming and providing high-quality, naturally flavoured palm oil to consumers.', 'All palm oil consumers, including households, restaurants, food processing companies, and cosmetic manufacturers, particularly those seeking enhanced flavours in their cooking oils and good health.', 'Wilmar International, Benso Oil Palm Plantation, Ghana Oil Palm Development Corporation (GOPDC), and other local and international palm oil producers, especially those offering specialty or infused oils.', 'Increasing demand for sustainable and ethically sourced products, Growing interest in flavoured and specialty cooking oils, Preference for high-quality, organic, and non-GMO products among consumers, Expansion of the palm oil market in food and non-food industries.', 'GHS 100,000', 'Land for palm cultivation, Palm oil processing and infusion equipment, Storage and distribution facilities, Transportation vehicles, Seedlings, fertilizers, and infusion ingredients (cloves, ginger, cinnamon, onion), Skilled labour and training programs', 'Agricultural expertise in palm cultivation, Knowledge of sustainable farming practices, Technical skills in palm oil processing, infusion, and quality control, Marketing and sales skills, Financial management and accounting, Supply chain management', 'Local farmers and farming cooperatives, Environmental NGOs, Fair trade organizations, Government agricultural departments, Sustainable agriculture research institutes, Financial institutions and investors', 'Promotes sustainable agricultural practices, reducing environmental degradation, supports local farmers with fair trade practices and better income opportunities, contributes to community development through job creation and training programs, raises awareness about the benefits of sustainably sourced, flavoured palm oil among consumers, Enhances the economic development of rural areas by boosting the agricultural sector.', 'E - commerce platform, renewable energy solution (solar panel), data analytics', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(87, 'Dzata Shannen Seyram Kojo', 'Human Resource Management ', 'Level 200', '0551226923', 'dzatashannen@gmail.com', 'KanTeen', 'KanTeen is a snacking initiative that would use Vending Machines to serve Drinks and Food. KanTeen would offer 24/7 services to Universities and Corporate institutions, at convenient locations within their Buildings. The vending machines would be filled with either drinks, biscuits or chocolate bars, depending on the demand of the surveyed geographic locality. KanTeen would have a medium storage location for housing it\'s products to be retailed. KanTeen would employ a worker to restock and one to Cleanup after consumers at minimum wage. KanTeen would have an estimate of 1000 Ghana Cedis profit a month, per machine.', 'KanTeen is designed to meet the needs of Academic Staff, Corporate Institutions and most especially University Students. We would like to begin operations in the major Universities across Ghana.', '1. Provision Stores and Snack Joints about the location of the consumers.', 'The Vending Machine franchise has been estimated to be over 20 billion dollars, since 2018 and steadily gaining till 2024 currently. Recently, there have been the employment of Cashless Payments that is Credit Cards and new innovations having Mobile Money access. This makes the Vending Machine Franchise an outstanding industry to enter into. The Cash option, that is physical money is also being used. There is the added advantage of being able to diversify the products; from fizzy drinks, to biscuits, energy bars to hot drinks. Unfortunately there appears to be Ecological harm from the industry since the wrappers and containers might be disposed off inappropriately. KanTeen would take full advantage of these problems and takeover the otherwise non-existent Vending Machine industry in Ghana. Sources : expertmarketresearch.com, grandviewresearch.com, frontu.com', 'KanTeen would require an initial capital of 40000 ', 'Wholesale Drinks and Biscuits', '1. Basic Accounting 2. Vending Machine Operation Skills', 'We are determined to rebrand the access ories to Ghanaian products, therefore we wish to  Partner with companies like Twellium Industrial Company, Bellaqua Ghana, Universities like University of Education Winneba, University of Ghana,  University of Cape Coast and Kwame Nkrumah University of Science and Technology. Finally, as we expand to the Cashless Payments method for our Machines, we could Partner with Telecommunications companies like MTN, Telecel and Airtel Tigo, to provide a mobile money option ', 'We wish that our display and selling of Made in Ghana Beverages and Snacks would boost the Ghanaian image and Patronage. We also wish that as KanTeen continues to provide services to it\'s consumers, we\'d add a recycling initiatives by providing trash segregation either in our machines or at appropriate places around the organization.', 'The Vending Machine would have various functions and processes. A place to insert cash  or  a scannable code for Mobile Money. It would be coupled with insulation and cooling  features and we may switch it to just storage, depending on the product. As KanTeen becomes the name associated with quick snacks  in the Ghanaian Market, we would consult Technological Professionals like Kantaka and certain Innovative Students in various Universities in Ghana, to help us Fashion our own Vending Machine, Customized to fit the Ghanaian taste. ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(88, 'Blibo Vincent ', 'Bsc. Mathematics Education ', 'Level 100', '0543488654', 'blibovincent47@gmail.com', 'Sales of phone accessories and momo business ', 'Buy and sell', 'University of Education, Winneba campuses ', 'External and internal competitors ', 'Doorstep delivery at affordable prices', '2600', '30000', 'Communication Skills ', 'Mr Jude Thaddeus ( My boss at United States)', 'Assisting students in Uploading their assignments ', 'Laptop and Phone', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(89, 'DAPAAH EMMANUEL NARTEH', 'BBA ACCOUNTING ', 'Level 400', '0543315130', 'edapaah901@gmail.com ', 'BRANDING LOCAL GIN(AKPETESHIE)', 'Our business mission is to employ creative branding to elevate the traditional local gin, akpeteshie. We want to elevate this beloved local spirit into a high-end widely appealing product by including distinctive packaging, a captivating brand story and a strong visual identity. Positioning it as a unique option in the market that celebrates both quality and tradition.', 'Our target market for branding of local gin consists of travelers, high-earners, the hospitality sector and lovers of handmade spirits. These groups place a premium on distinctive, locally sourced and high-quality gins that provide genuine and long-lasting experience.', 'Global brands and producers of local vodka, whiskey and other spirits appealing to a similar market.', 'Emphasis on eye-catching, sustainable and unique packaging designs to attract consumers ', '20,000', 'Resources for creating a brand identity and advertising campaign ', 'Distillation expertise, marketing skills, sales and distribution, design and packaging and customer service ', 'Design agencies, distributors and hospitality venues', 'Community engagement, economic growth and educational opportunities ', 'Packaging technology, inventory management, e-commerce platforms, marketing technology and customer relationship management ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(90, 'MARTEY GIDEON KOFI', 'ACCOUNTING EDUCATION', 'Level 300', '0242856471', 'marteygideon836@gmail.com', 'MIXED FARMING (POULTRY, CROPS)', 'Mixed farming containing poultry (fowls) and crops (cassava)', 'Restaurant, Food joint (poultry), Cassava drink industry and gari processors(cassava)', 'LINNOVAC Poultry Farm, Kwadwo Adamu Unity Farms Limited, and Ansu Pramag Farm', 'About seventy-five percent annual demand for poultry in the market and approximately eighty-percent demand for cassava by both cassava processing industries and gari processors.', 'One thousand eight hundred Ghana cedis', 'Three Hen and one cock, poultry feed, pen (structure for housing the poultry), trough, nesting boxes,, lighting, and cassava stick', 'Animal husbandry, health management, nutrition and feeding, farm management.', 'Current and potential restaurantowners, cassava drink processing industries. ', 'Generate Employment, reduce protein deficiency among children, produce manure from fowls remains', 'Sensor\'s devices, CCTV Cameras, automated egg collectors.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(91, 'Beauty Amevor ', 'Integrated Home Economics ', 'Level 300', '0247064860', 'beautyseyram10@gmail.com', 'Food products from velvet tamarind ( locally called Yoryi) chocolate and Milo products and egg powder ', 'Velvet Tamarind (Yoryi) is produced mostly in Ghana but its uses are limited so if given the opportunity with your help I will produce something else out of it.\nEggs are household first class protein food items. Which should be very affordable even to the poor who cannot afford other first class protein foods but it\'s now impossible to afford again it\'s lifespan when produce is so short so when given the opportunity the idea of making eggs a household food products and affordable and also be kept as long as you wish will materialized .', 'For the velvet tamarind products my target is the youths and every household.Egg products every household but most especially the tertiary students ', 'Producers of breakfast products and producers of meat and meat products and fish ', 'Milo and normal or fresh eggs ', 'From my savings ', 'Drying equipment, start up capital and packaging materials and machines ', 'Knowing the nutritional values of the food items how to maintain them and how to preserve them to last long', 'Unilever Brothers,GB foods, Procus Ghana Limited and any other companies into food products ', 'It will reduce cost on cocoa products and even the poor can also afford a balanced meal and more people will go into production of velvet tamarind and eggs will last long when stored most especially for tertiary students to make good use of it anytime at very affordable price.', 'Technological equipment will be used to produce the products and also for marketing ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(92, 'Eunice Acquaye', 'BBA Marketing and Entreprenuership', 'Level 100', '0245212456', 'acquayeeunice77@gmail.com', 'EcoPlast Recycle Solutions', 'Facilitating the collection and sale of plastic water sachets and bottles to companies for upcycling into plastic products.\n', 'Tertiary students in Africa looking for a sustainable way to earn income while contributing to environmental conservation efforts, Waste management companies, recycling facilities, and manufacturers in need of raw materials for producing plastic goods.', 'Coliba Ghana Ltd', 'Rising Environmental Awareness, Demand for Recycled Materials, Government Regulations, Youth-Led Sustainability Initiatives, Corporate Sustainability Goals', 'Ten Thousand Ghana Cedis ', 'Collection bins and gloves for waste collection, student volunteers for organizing and promoting the initiative, partnerships with local recycling facilities, access to campus resources such as event spaces and communication channels.', 'Networking Skills, Organizational Skills, Leadership Skills, Communication Skills, Problem-Solving Skills, Sustainability Knowledge.', 'Student Representative Council , University Management, local manufacturers for material sales, student organizations for collaboration, environmental NGOs for guidance and expertise.', 'Environmental Awareness, Waste Reduction, Community Engagement, Skill Development, Economic Empowerment, Sustainable Practices', 'Mobile App, Data Analytics, Social Media Integration, QR Code System, Online Education', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(93, 'Francis Afeku ', 'Procurement and Supply Chain Management ', 'Level 200', '0256447315', 'reynoldsuccess@gmail.com', 'Manufacturing of Local Soap ', 'MaryGrace?s enterprise is a registered business that deals in the manufacturing of local Soaps for it locality and beyond ', 'Our main target is focused on Retail shops, individual buyers and chop bars ', 'MaryGrace?s Soap comes with a very unique fragrance that?s give a very nice smell when being used. It?s been made with natural ingredients that makes it easier to lather with all kinds of water.', 'The use of natural resources to help reduce irritation on the hand when used ', '5,400gh', 'Soda, Palm oil, powder, water, fragrance, essential oil,', 'Knowledge in Soap making ', 'It?s a two siblings business ', 'The manufacturing process does not leave any waste or pollutant to pollute the environment ', 'Planning on getting new technological tools to fasten its production ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(94, 'Joel Nana Kwamina Otuu ', 'BSc Environmental Health and Sanitation Education ', 'Level 200', '0501849333', 'quashiejoel80@gmail.com', 'Waste Wealth Composting ', ' Sustainable composting practices to transform biodegradable organic materials into nutrient-rich soil. Our approach offers environmentally friendly solution for waste management and soil enrichment transforming waste into valuable resources.', 'Farmers, NGO?s, Municipalities and Local Government, Educational and Professional Institutions ', 'Inorganic and Organic Fertilizers Companies ', 'Increasing environmental awareness in recent times has been observed. More individuals and businesses are seeking sustainable solutions to reduce waste and minimize their carbon footprint. Composting is increasingly recognized as an effective way to manage organic waste and enrich soil, leading to higher adoption rates.', 'Zero funds but there is the availability of waste ', 'Composting bin, watering can, shovel, hand-fork, organic waste materials and water ', 'Theoretical knowledge about composting, Business skills (Marketing, Branding, Promotion, Client relations and engagement) and Passion for Environmental Conservation ', 'Farmers, NGO?s, Municipalities and Local Government, Educational and Professional Institutions, Hospitalities and Waste Management Companies ', 'Mitigating the impacts of inorganic fertilizers on the environment; Promoting food security; Job creation; Waste reduction and Environmental conservation ', 'An upscale of the project is envisioned to incorporate the use of monitoring systems to monitor temperature, moisture levels and oxygen content, as well as the utilization of mechanized compost turners and irrigation systems', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(95, 'Bismark Dwamena Augustine ', 'Human Resources Management ', 'Level 300', '0553030454', 'bismarkdwamena8080@gmail.com', 'Mini importation Pre-Order', 'Mini importation Pre-Order is a shipping form of business which deals with importation of quantities in small scale. I personally deal with this Mini importation mostly China goods to Ghana. I sometimes deals with turkey goods too. I currently hold about 400 to 450 members in my group page. I put items on on the page then wait for orders at a very low price then awaits to charge shipping fees after 5 to 8 weeks after items has been bought. ', 'Okay, so when it comes to my target of market. I always aim on hitting to a very broad capital then switch from this mini importation to a large scale order instead. Like I said earlier on I currently hold 450 members on my page, of which I?m still targeting a very large number then plan on making the switch. But the need to improve on my capital of money will come in. Which means a perfect income to work along. ', 'With mini importation, I have a lot of competitors. I have about two people as course mate who are also into mini importation. At home in my community I know about three people who are also into this business.', 'With Pre-order mini importation business some market trends will include, building demand for active online shopping. Increasing popularity of many social media sites. Utilize social media platforms to reach the targeted number of customers also to focus on specific niches with high demand and limited competition.', 'I started the business with some small purchases o', 'Initial required resources to me as a preorder CEO I really sees the side of building Trustworthiness from both customers and suppliers. With trust issues that?s when it comes to making payment and getting their time and patience also I can talk on customer service support through multiple channels. Insurance coverage to protect losses due to shipping issues. ', 'My skills needed most as a Preoder business person are My time management skills, negotiation with customers and suppliers, Prober look of products in the markets or online site, building on my communications and best to try my best making it active online. ', 'Potential partnerships will include, suppliers, customers, logistics and shipping companies, competitors, insurance providers, accounting and proper bookkeeping services and a lot. ', 'Supporting small business, global connections, training others and sharing knowledge, supporting social causes, offering unique products, sponsoring charities, building relationships with suppliers.', 'Technological elements includes communication tools, emailing, payment process and softwares for bookkeeping. Also product research tools will be considered. Order management systems like streamlining orders.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(96, 'Farouk Nuhhu Billa', 'EXECUTIVE MASTERS DEGREE IN HUMAN RIGHT, PEACE & CONFLICT STUDIES', 'MBA', '0244579151', 'virginvestment@gmail.com', 'The entrepreneur using modern day innovation ideas, technology to discount Pension?s Retirement benefits for the Ghanaian worker through PENSION SOLUTION SERVICES.', 'A strategic innovative idea proposed by the student specifically to discount the retirement   benefits of the Pensioner in the Republic of Ghana with Pension Solution Service Limited. This financial product is specifically to discount the pensions of the Pensioner within 5 limited days very fast. ', 'Retired Pensioners ', 'No competitor this product does not exist in the Republic of Ghana ', 'Pensioners retirement benefits ', 'One million dollars ', 'Financial resources, human capital, clients, the core mission value of the company, logistics  ', 'Financial experts, legal experts, business development advisers, treasurer, IT experts, Accountants, Security, Customer  service representatives    ', 'Retired  pensioners ', 'Building bridges between the delay of paying retired pensioners benefits by the government with Pension Solution Service is rather faster  ', 'Innovative products, strategic unique faster element to reduce stress for the pensioner, digital application ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(97, 'GODWIN KORSI FIANU ', 'BBA ACCOUNTING ', 'Level 300', '0595508961', 'gekelelyon1@gmail.com', 'HOME GARDEN SERVICE ', 'THIS IS A BACK YARD GARDEN THAT DEALS WITH GROWING OF VEGGIES OR VEGETABLES IN SACKS, PLASTICS AND WOODEN STRUCTURES.', 'WORKERS LIKE LECTURERS, DOCTORS, BUSINESS MEN. ', 'INDUSTRIAL AGRICULTURE, LOCAL NURSERIES AND GARDEN CENTERS, AND URBAN AGRICULTURE.', 'INCREASE DEMAND FOR ORGANIC PRODUCE, DIVERSIFICATION OF INCOME ', 'GHS 6,500.00', 'LAND, SEED, SOIL, WATER,TOOLS, FERTILIZER AND PESTS CONTROL, TIME AND LABOUR, KNOWLEDGE AND SKILLS, AND STORAGE AMONG OTHERS.', 'PLANT CARE, SOIL MANAGEMENT, GARDEN KNOWLEDGE, STORAGE MANAGEMENT, CROP PLANNING ', 'LOCAL NURSERIES, SEED SUPPLIERS, GARDEN TOOLS SUPPLIERS, AND ONLINE PLATFORMS .', 'FOOD SECURITY, YOUTH ENGAGEMENT, CULTURAL PRESERVATION AND FOOD SOVEREIGNTY ', 'GREEN HOUSE MANAGEMENT SOFTWARE, GARDENING APPS AND ONLINE PLATFORMS ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(98, 'ALI KUPAH RAHAMAN ', 'Marketing and Entrepreneurship ', 'Level 400', '0240915405', 'alikupahrahaman@gmail.com', 'K&T AGRO-INNOVATORS ', 'We propose large-scale farming of sesame seeds and soybeans, focusing on modern, cost-effective practices. Originating from Africa, sesame seeds are underutilized in Ghana outside the north. We aim to establish a farming hub to teach best practices, including crop preservation. Additionally, we will create warehousing and storage facilities, allowing farmers to sell crops at optimal prices. Soybeans, also healthy and versatile, will be sold to local industries and export firms. Our sustainable approach includes tree planting every five years. This initiative ensures high yields, economic benefits, and environmental stewardship, driving agricultural innovation in Ghana.', 'Small Holder farmers in Ghana, local industries, and export firms.', 'Existing farmers, agricultural companies (Olam, COFCO, Wilmar), local seed production companies (SeedCo, Agriseed), export companies (Ghana Export Promotion Authority), and NGOs/development projects focused on agricultural development.', '*Growing demand for certified seeds *Government initiatives & subsidies *Market growth: $16.61m (2024) to $22m (2029).', '10,000 Ghana cedis ', 'Human, capital, agriculture tools and mentorship ', 'Modern based entrepreneurial and agriculture skills, innovative and critical thinking skills and problem solving skills.', 'Government agencies,NGOs, entrepreneurs into large scale farming and industries into processing of seeds as well as export and import ', 'The growing demand for certified seeds, driven by government support, will boost farmers\' yields and income, strengthen the agricultural sector, and drive economic growth in Ghana.', 'The seed industry in Ghana can leverage technologies like digital agriculture, seed technology (high-yielding and disease-resistant varieties), e-commerce, data analytics, agricultural drones, AI, and blockchain to enhance efficiency and productivity. These technologies can improve seed production, demand forecasting, supply chain management, and crop yields, ultimately benefiting farmers, producers, and consumers.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(99, 'Josephine  Mensah', 'Banking  and  Finance', 'Level 200', '0540708480', 'mensahjosephine477@gmail.com', '  Coconut  Juice', 'Coconut  Juice  is made of  coconut ,Milk, Sugar , Vanilla and Non  Dairy.', 'All  Manner of people', 'Beverage  Companies', 'Short term  investment .', 'Ghc 2000', 'Deep freezer, plastic bottle ,sugar , milk, Non  Dairy and coconut, squeezer.', 'Train on how to use the squeezer.', 'Companies  who are into beverages .', 'Social  media  is  a great  way  to advertise and sell the products .', 'Modern  technology and equipment .', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(100, 'Philomina Adu Boahen', 'Accounting Education', 'Level 300', '0551835148', 'aduphilomina87@gmail.com', 'Minah Shay Shito and onion paste', 'It has come to my attention that the most of shito that is done get spoil easily because of how it\'s treated. A nice, packaged one will help curb the rate at which it spoils. And on the other hand, the onion paste is going to help making food easier and faster', 'The students at large and domestic households', 'Vendors in the same business', 'Advertisement and packaging', '', 'A good amount of money and kitchen tools', 'good cooking skills', 'None for now', 'Health and wellness', 'Online platforms', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(101, 'Francis Baah Ofosuhene', 'Master of Philosophy (Human Resource Management)', 'MPHIL', '0555690392', 'fb.ofosuhene@gmail.com', 'E-Learning Platform for Parents with Children from Early Childhood to High School', 'The need for quality education resources has never been more crucial. Parents seek ways to support their children\'s learning at home, especially in early childhood and high school. We propose developing an e-learning platform tailored for parents with children from early childhood to high school. This platform will offer various educational resources, activities, and support to help parents actively engage in their children\'s education.', '?	Parents of children in early childhood (ages 3-5) ?	Parents of children in elementary school (ages 6-11) ?	Parents of children in middle school (ages 12-14) ?	Parents of children in high school (ages 15-18)', 'WOLO E-LEARNING PLATFORM GHANA', 'There is growing internet and smartphone penetration on the technological market. Also, there are blended learning models', 'GHS20,000.00', 'Web Development Tools, Learning Management System (LMS), Hosting and Cloud Services, Technical Team, UI/UX Designers, Initial Investment, Hardware, Office Space', 'Programming skills, Teaching skills, videography,  marketing skills', 'University of Education, Winneba ', 'There would be cost-effectiveness on education so far as parents feel empowered about the e-learning platform', 'User Experience and Interface Design, Cloud Services and Hosting, Database Management,  Learning Management System (LMS), Web and Mobile Development', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(102, 'Ocran Nyameyie Gloria', 'Procurement and Supply Chain Management ', 'Level 300', '0553399483', 'gloriaocran16@gmail.com', 'N&N CLOTHING ', 'Designing and sewing of male and female clothing ', 'Students and workers, parents, organizations, institutions,schools', 'Fashion designers and other clothing production lines and local seamstress and tailors ', 'Changing fashion trends, Rising population ', 'Gh15000', 'Sewing machine, fabrics, human resource,(man power) space to do the sewing, steam iron, Manikin, sewing kids(thread, Needle, French rules)', 'Creative designs, ability to take appropriate measurements. Ability to draft and cut fabrics. Sewing skills ', 'SMULLY Wear,Derry On Point, UEW fashion department, Gracelove creation', 'Economic empowerment, Education and skill building, community building and social bond, cultural exchange and representation ', 'Automated cutting machines, sewing machine with advance features,3D printing and embroidery ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(103, 'AZOBO DENNIS AYEBASE', 'Bachelor of Business Administration (Business Information Systems)', 'Level 100', '0591936906/ 053', 'azobodennis1@mail.com', 'Expanding my business', 'I am into African wear (Smocks/Fugu) trading. I am a master in showing the dresses and I sell my product to the open market. I have workers/ apprentice that I train them how to sew the dresses. I am hoping to help a lot of people to get their jobs out of my training and trading. Firstly, i hope to provide jobs for the female weavers that i buy my materials from and also to provide jobs for workers who are into sewing of the smocks/fugu.', 'The local and international market', 'My colleagues who are into trading of smocks/fugu', 'I intend to produce high quality smocks with nice designs and very affordable to my customers', 'Twenty-Five Thousand Ghana cedies (GHC25,000)', ' Sewing machine, Smocks materials, Thread, Constant electricity.', 'Good marketer, Ability to learn and knowledge of how the market moves.', 'Fashion companies in Ghana and internationally.', 'I aim at providing jobs for  the youth (male and female)', 'We sew the dresses with both hands and machines which make it have higher quality than people who uses only a single method for sewing.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(104, 'Abraham Lincoln Konja', 'Business Administration Banking and Finance ', 'Level 400', '0554710066', 'thepeopleslincoln@gmail.com', 'NutriYam Enterprise.', 'NutriYam Enterprise aims to become a leading supplier of high quality tiger nut and yams, capitalizing on the growing demand for nutritious and natural food products. ', 'Local and Industrial markets.', 'Any other businesses that are into tiger nut and yam business such as, Tiger nuts Ghana Limited and Yam masters Ghana Limited.', ' Here are some market trends in the tiger nut and yam business in Ghana :Growing Demand: Ghana has a growing demand for tiger nuts and yams, both locally and internationally. Government Support: The Ghanaian government has established the Ghana National Agricultural Export to promote the export of agricultural products, including tiger nuts and yams. Informal Markets: Despite government efforts, informal markets still dominate the trade of tiger nuts and yams in Ghana. Food Safety: There is a growing concern about food safety in the tiger nut and yam business in Ghana, with studies showing contamination of tiger nuts with parasites and bacteria. ', 'GHC 30,000', 'Financial Resources, Land and equipment, Human Resources, Technology, market access, raw materials, Transportation, Storage facilities and Research and Development.', 'Farming skills, Business management skills, processing skills, marketing skills, Financial management skills, communication skills, Logistics and supply chain management skills and Leadership skills.', 'Community engagement: collaborating with local communities, farmers and organizations can Forster partnership and promote social responsibility.', 'Job creation, income generation,safety food, Rural Development, Women employment, community engagement, cultural preservation, nutrition and health and Education and skills development.', 'Precision agriculture, mechandised farming, irrigation system, post-harvest handling, supply chain management software, E-commerce platforms and digital market places.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(105, 'full_name', 'programme_of_study', 'level', 'contact', 'email', 'business_idea_title', 'brief_description', 'target_market', 'competitors', 'market_trends', 'initial_capital', 'required_resources', 'skills_needed', 'potential_partnerships', 'social_impact', 'technological_elements', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `proposals` (`id`, `full_name`, `programme_of_study`, `level`, `contact`, `email`, `business_idea_title`, `brief_description`, `target_market`, `competitors`, `market_trends`, `initial_capital`, `required_resources`, `skills_needed`, `potential_partnerships`, `social_impact`, `technological_elements`, `member1_name`, `member1_programme`, `member1_level`, `member1_email`, `member2_name`, `member2_programme`, `member2_level`, `member2_email`) VALUES
(106, 'Ebenezer Ayirebi-Acquah', 'BIS', '400', '0507192896', 'ebenezerayirebiacquah28@gmail.com', 'Sobolo Drinks and Pie', 'Mission, Vision and Values\r\nUniversity Anthem\r\nUniversity Logo\r\nUniversity Council\r\nChancellor\r\nVice-Chancellor\'s Office\r\nRegistrar\'s Office\r\nFinance Officer\'s Office\r\nLibrarian\'s Office\r\nInternal Auditor\'s Office\r\nHall of Fame\r\nOur Campuses\r\nUniversity Contacts\r\nEstablished in September 1992 under PNDC Law 322, the University of Education, Winneba (UEW), embarked on a transformative journey dedicated to advancing education. In May 2004, it achieved a significant milestone with the enactment of the University of Education Act, (2004) Act 672, elevating it to full university status.\r\n\r\nUEW\'s history is marked by the merger of seven diploma-awarding colleges, including the Advanced Teacher Training College, Specialist Training College, and National Academy of Music all in Winneba; the School of Ghana Languages in Ajumako; the College of Special Education in Akwapim-Mampong; the Advanced Technical Training College in Kumasi; and the St. Andrews Agricultural Training College in Asante-Mampong. This consolidation created a diverse and dynamic educational institution.', 'Mission, Vision and Values\r\nUniversity Anthem\r\nUniversity Logo\r\nUniversity Council\r\nChancellor\r\nVice-Chancellor\'s Office\r\nRegistrar\'s Office\r\nFinance Officer\'s Office\r\nLibrarian\'s Office\r\nInternal Auditor\'s Office\r\nHall of Fame\r\nOur Campuses\r\nUniversity Contacts\r\nEstablished in September 1992 under PNDC Law 322, the University of Education, Winneba (UEW), embarked on a transformative journey dedicated to advancing education. In May 2004, it achieved a significant milestone with the enactment of the University of Education Act, (2004) Act 672, elevating it to full university status.\r\n\r\nUEW\'s history is marked by the merger of seven diploma-awarding colleges, including the Advanced Teacher Training College, Specialist Training College, and National Academy of Music all in Winneba; the School of Ghana Languages in Ajumako; the College of Special Education in Akwapim-Mampong; the Advanced Technical Training College in Kumasi; and the St. Andrews Agricultural Training College in Asante-Mampong. This consolidation created a diverse and dynamic educational institution.', 'Mission, Vision and Values\r\nUniversity Anthem\r\nUniversity Logo\r\nUniversity Council\r\nChancellor\r\nVice-Chancellor\'s Office\r\nRegistrar\'s Office\r\nFinance Officer\'s Office\r\nLibrarian\'s Office\r\nInternal Auditor\'s Office\r\nHall of Fame\r\nOur Campuses\r\nUniversity Contacts\r\nEstablished in September 1992 under PNDC Law 322, the University of Education, Winneba (UEW), embarked on a transformative journey dedicated to advancing education. In May 2004, it achieved a significant milestone with the enactment of the University of Education Act, (2004) Act 672, elevating it to full university status.\r\n\r\nUEW\'s history is marked by the merger of seven diploma-awarding colleges, including the Advanced Teacher Training College, Specialist Training College, and National Academy of Music all in Winneba; the School of Ghana Languages in Ajumako; the College of Special Education in Akwapim-Mampong; the Advanced Technical Training College in Kumasi; and the St. Andrews Agricultural Training College in Asante-Mampong. This consolidation created a diverse and dynamic educational institution.', 'Mission, Vision and Values\r\nUniversity Anthem\r\nUniversity Logo\r\nUniversity Council\r\nChancellor\r\nVice-Chancellor\'s Office\r\nRegistrar\'s Office\r\nFinance Officer\'s Office\r\nLibrarian\'s Office\r\nInternal Auditor\'s Office\r\nHall of Fame\r\nOur Campuses\r\nUniversity Contacts\r\nEstablished in September 1992 under PNDC Law 322, the University of Education, Winneba (UEW), embarked on a transformative journey dedicated to advancing education. In May 2004, it achieved a significant milestone with the enactment of the University of Education Act, (2004) Act 672, elevating it to full university status.\r\n\r\nUEW\'s history is marked by the merger of seven diploma-awarding colleges, including the Advanced Teacher Training College, Specialist Training College, and National Academy of Music all in Winneba; the School of Ghana Languages in Ajumako; the College of Special Education in Akwapim-Mampong; the Advanced Technical Training College in Kumasi; and the St. Andrews Agricultural Training College in Asante-Mampong. This consolidation created a diverse and dynamic educational institution.', '$5000', 'Mission, Vision and Values\r\nUniversity Anthem\r\nUniversity Logo\r\nUniversity Council\r\nChancellor\r\nVice-Chancellor\'s Office\r\nRegistrar\'s Office\r\nFinance Officer\'s Office\r\nLibrarian\'s Office\r\nInternal Auditor\'s Office\r\nHall of Fame\r\nOur Campuses\r\nUniversity Contacts\r\nEstablished in September 1992 under PNDC Law 322, the University of Education, Winneba (UEW), embarked on a transformative journey dedicated to advancing education. In May 2004, it achieved a significant milestone with the enactment of the University of Education Act, (2004) Act 672, elevating it to full university status.\r\n\r\nUEW\'s history is marked by the merger of seven diploma-awarding colleges, including the Advanced Teacher Training College, Specialist Training College, and National Academy of Music all in Winneba; the School of Ghana Languages in Ajumako; the College of Special Education in Akwapim-Mampong; the Advanced Technical Training College in Kumasi; and the St. Andrews Agricultural Training College in Asante-Mampong. This consolidation created a diverse and dynamic educational institution.', 'Mission, Vision and Values\r\nUniversity Anthem\r\nUniversity Logo\r\nUniversity Council\r\nChancellor\r\nVice-Chancellor\'s Office\r\nRegistrar\'s Office\r\nFinance Officer\'s Office\r\nLibrarian\'s Office\r\nInternal Auditor\'s Office\r\nHall of Fame\r\nOur Campuses\r\nUniversity Contacts\r\nEstablished in September 1992 under PNDC Law 322, the University of Education, Winneba (UEW), embarked on a transformative journey dedicated to advancing education. In May 2004, it achieved a significant milestone with the enactment of the University of Education Act, (2004) Act 672, elevating it to full university status.\r\n\r\nUEW\'s history is marked by the merger of seven diploma-awarding colleges, including the Advanced Teacher Training College, Specialist Training College, and National Academy of Music all in Winneba; the School of Ghana Languages in Ajumako; the College of Special Education in Akwapim-Mampong; the Advanced Technical Training College in Kumasi; and the St. Andrews Agricultural Training College in Asante-Mampong. This consolidation created a diverse and dynamic educational institution.', 'Mission, Vision and Values\r\nUniversity Anthem\r\nUniversity Logo\r\nUniversity Council\r\nChancellor\r\nVice-Chancellor\'s Office\r\nRegistrar\'s Office\r\nFinance Officer\'s Office\r\nLibrarian\'s Office\r\nInternal Auditor\'s Office\r\nHall of Fame\r\nOur Campuses\r\nUniversity Contacts\r\nEstablished in September 1992 under PNDC Law 322, the University of Education, Winneba (UEW), embarked on a transformative journey dedicated to advancing education. In May 2004, it achieved a significant milestone with the enactment of the University of Education Act, (2004) Act 672, elevating it to full university status.\r\n\r\nUEW\'s history is marked by the merger of seven diploma-awarding colleges, including the Advanced Teacher Training College, Specialist Training College, and National Academy of Music all in Winneba; the School of Ghana Languages in Ajumako; the College of Special Education in Akwapim-Mampong; the Advanced Technical Training College in Kumasi; and the St. Andrews Agricultural Training College in Asante-Mampong. This consolidation created a diverse and dynamic educational institution.', 'Mission, Vision and Values\r\nUniversity Anthem\r\nUniversity Logo\r\nUniversity Council\r\nChancellor\r\nVice-Chancellor\'s Office\r\nRegistrar\'s Office\r\nFinance Officer\'s Office\r\nLibrarian\'s Office\r\nInternal Auditor\'s Office\r\nHall of Fame\r\nOur Campuses\r\nUniversity Contacts\r\nEstablished in September 1992 under PNDC Law 322, the University of Education, Winneba (UEW), embarked on a transformative journey dedicated to advancing education. In May 2004, it achieved a significant milestone with the enactment of the University of Education Act, (2004) Act 672, elevating it to full university status.\r\n\r\nUEW\'s history is marked by the merger of seven diploma-awarding colleges, including the Advanced Teacher Training College, Specialist Training College, and National Academy of Music all in Winneba; the School of Ghana Languages in Ajumako; the College of Special Education in Akwapim-Mampong; the Advanced Technical Training College in Kumasi; and the St. Andrews Agricultural Training College in Asante-Mampong. This consolidation created a diverse and dynamic educational institution.', 'Mission, Vision and Values\r\nUniversity Anthem\r\nUniversity Logo\r\nUniversity Council\r\nChancellor\r\nVice-Chancellor\'s Office\r\nRegistrar\'s Office\r\nFinance Officer\'s Office\r\nLibrarian\'s Office\r\nInternal Auditor\'s Office\r\nHall of Fame\r\nOur Campuses\r\nUniversity Contacts\r\nEstablished in September 1992 under PNDC Law 322, the University of Education, Winneba (UEW), embarked on a transformative journey dedicated to advancing education. In May 2004, it achieved a significant milestone with the enactment of the University of Education Act, (2004) Act 672, elevating it to full university status.\r\n\r\nUEW\'s history is marked by the merger of seven diploma-awarding colleges, including the Advanced Teacher Training College, Specialist Training College, and National Academy of Music all in Winneba; the School of Ghana Languages in Ajumako; the College of Special Education in Akwapim-Mampong; the Advanced Technical Training College in Kumasi; and the St. Andrews Agricultural Training College in Asante-Mampong. This consolidation created a diverse and dynamic educational institution.', 'POP', 'BBA', '200', 'admin@gmail.com', 'corn', 'BBA', '300', 'admin1@gmail.com');

-- --------------------------------------------------------

--
-- Table structure for table `proposal_assignments`
--

CREATE TABLE `proposal_assignments` (
  `id` int NOT NULL,
  `proposal_id` int NOT NULL,
  `assessor_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `proposal_assignments`
--

INSERT INTO `proposal_assignments` (`id`, `proposal_id`, `assessor_id`) VALUES
(9, 2, 5),
(10, 3, 6),
(11, 4, 7),
(12, 5, 8),
(13, 6, 9),
(14, 7, 10),
(15, 8, 10),
(16, 9, 9),
(17, 10, 8),
(18, 11, 7),
(19, 12, 6),
(20, 13, 5),
(21, 14, 5),
(22, 15, 6),
(23, 16, 7),
(24, 17, 8),
(25, 18, 9),
(26, 19, 10),
(27, 20, 10),
(28, 21, 9),
(29, 22, 7),
(30, 23, 8),
(31, 24, 9),
(32, 25, 5),
(33, 26, 5),
(34, 27, 6),
(35, 28, 7),
(36, 29, 8),
(37, 30, 9),
(38, 31, 10),
(39, 32, 5),
(40, 33, 6),
(41, 34, 7),
(42, 35, 8),
(43, 36, 9),
(44, 37, 10),
(45, 38, 5),
(46, 39, 6),
(47, 40, 7),
(48, 41, 8),
(49, 42, 9),
(50, 43, 10),
(51, 44, 5),
(52, 45, 6),
(53, 46, 7),
(54, 47, 8),
(55, 48, 9),
(56, 49, 10),
(57, 50, 5),
(58, 51, 6),
(59, 52, 7),
(60, 53, 8),
(61, 54, 9),
(62, 55, 10),
(63, 56, 5),
(64, 57, 6),
(65, 58, 7),
(66, 59, 8),
(67, 60, 9),
(68, 61, 10),
(69, 62, 5),
(70, 63, 6),
(71, 64, 7),
(72, 65, 7),
(73, 66, 8),
(74, 67, 9),
(75, 68, 10),
(76, 69, 5),
(77, 70, 6),
(78, 71, 7),
(79, 72, 8),
(80, 73, 9),
(81, 74, 10),
(82, 75, 5),
(83, 76, 6),
(84, 77, 7),
(85, 78, 8),
(86, 79, 9),
(87, 80, 10),
(88, 81, 5),
(89, 82, 6),
(90, 83, 7),
(91, 84, 8),
(92, 85, 9),
(93, 86, 10),
(94, 87, 5),
(95, 88, 6),
(96, 89, 7),
(97, 90, 8),
(98, 91, 9),
(99, 92, 10),
(100, 93, 5),
(101, 94, 6),
(102, 95, 7),
(103, 96, 8),
(104, 97, 9),
(105, 98, 9),
(106, 99, 10),
(107, 100, 5),
(108, 101, 6),
(109, 102, 7),
(110, 103, 8),
(111, 104, 9),
(112, 105, 10);

-- --------------------------------------------------------

--
-- Table structure for table `rejected_proposals`
--

CREATE TABLE `rejected_proposals` (
  `id` int NOT NULL,
  `full_name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `business_idea_title` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `phone` varchar(15) COLLATE utf8mb4_general_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `rejected_proposals`
--

INSERT INTO `rejected_proposals` (`id`, `full_name`, `business_idea_title`, `phone`, `email`) VALUES
(13, 'Osei Kenneth Appiah ', 'O\'KENNYS PUB AND GRILL', '0599942041', 'Kenosei1656@gmail.com '),
(14, 'Ankemah Boateng Samuel', 'ElectroCredit', '0592302283', 'Samboat628@gmail.com'),
(15, 'Manasseh Amemasor', 'Super Food', '0509577184', 'manassehmhingle@gmail.com'),
(16, 'Hayford Owusu ', 'Fashion Designing ', '0241741048', 'hayfordowusu40@gmail.com'),
(17, 'ISAAC ANTWI', 'ODO KOKONTEY ', '0559300511/0201', 'antwiisyaw@gmail.com'),
(18, 'Edwina Dede Tawiah-Baddoo ', 'Mobile Money and mobile transfer ', '0241247687', 'edwinabaddoo0@gmail.com'),
(19, 'Enoch Tei ', 'Snail mackerel ', '0594045659', 'godsheart054@gmail.com'),
(20, 'Emmanuella Balogun ', '', '0534679959', 'Bellaaderotimi@gmail.com'),
(21, 'Emmanuel Sakyi ', 'Manuel Consultant Agency (MCA)', '0247451739', 'sakyie1010@gmail.com '),
(22, 'NYARKO MAWUTOR', 'Selling of online electronic goods', '0599854180', 'nyarkomawutor13@gmail.com'),
(23, 'Kwadwo Mensah Nyarko Gaisie', 'Beetroot Natural Juice', '0249529405', 'gaisienkm@gmail.com'),
(24, 'Richmond Obeng', 'Golden Gate Management ', '0555623818/0502', 'hudsonobengrichmond@gmail.com'),
(25, 'FRANCIS DJATO', 'EcoEats', '0208558832/0242', 'francisdjato4@gmail.com'),
(26, 'Azieve Joshua Atsu ', 'Kugbeadzor Farms: Cultivating Quality, Sustainable Practices ', '0243626790', '220009526@st.uew.edu.gh'),
(27, 'Felix Bryan Afeke ', 'Likem?s construction Ltd', '0243683253', 'felixbryanafeke@gmail.com'),
(28, 'Dagour Abdul Waris ', 'DAGSONS MOTORCYCLE SHOP ', '0505261226/0551', 'dagourabdulwaris1@icloud.com'),
(29, 'Augustina Agama ', 'Farm fusion ', '0247500115', 'augustinaamaagama44@gmail.com'),
(30, 'PRINCE AINOOSON', 'Campus TRIMZ', '0541793307', 'Prince_jnr@icloud.com'),
(31, 'Blibo Vincent ', 'Sales of phone accessories and momo business ', '0543488654', 'blibovincent47@gmail.com'),
(32, 'Nyamavor Salomey ', 'Sally\'s enterprise ', '0500204862', 'salomeyn185@gmail.com'),
(33, 'Emmanuel Boakye ', 'Local soap and African black soap production ', '0558757104', 'kobinayeboah85@gmail.com'),
(34, 'JOSEPH KWESI MENSAH ', 'Kwesi Mensah Electricity Distributor ', '0248083082', 'josephkmensah01@gmail.com'),
(35, 'Martin Gyabeng ', 'Marquetry', '0593273998', 'martingyabeng2020@gmail.com'),
(36, 'Asare Collins Osafo-Ayeh ', 'Jewelry ', '0557047797', 'collinsosafoayeh@gmail.com'),
(37, 'Kingsley Toku Agyin', 'Fish Farming ', '0554922921', 'kingsleytoku9k@gmail.com'),
(38, 'Aaron Haruna Siakah ', 'Cashew nuts oil processing ', '0553264115', 'aaronsiakah1@gmail.com'),
(39, 'Samuel Quartey', 'Pickme Gas Cylinder Refill', '0247449630', 'samuelquartey38@gmail.com '),
(40, 'Nancy Aba Sackey ', 'Production of castor oil and hair growth oil and cream ( operation of Beauty Parlor)', '0538078546', 'sackeynancy785@gmail.com '),
(41, 'Dagour Abdul Waris ', '1. Punches and juice 2. Dagsons motor parts ', '0505261226/0551', 'dagourabdulwaris1@iclous.con'),
(42, 'Emmanuel Gottfried Dartey ', 'NexGen Technology Services ', '0595208773', 'okoffodartey19@gmail.com'),
(43, 'Ubaiya Ibrahim Dimmie', 'Agricultural inputs supply and profit sharing margin for northern Ghana women farmers ', '0593436430', 'ubaiya@yahoo.com'),
(44, 'Beauty Amevor ', 'Food products from velvet tamarind ( locally called Yoryi) chocolate and Milo products and egg powder ', '0247064860', 'beautyseyram10@gmail.com'),
(45, 'GODWIN KORSI FIANU ', 'HOME GARDEN SERVICE ', '0595508961', 'gekelelyon1@gmail.com'),
(46, 'ALI KUPAH RAHAMAN ', 'K&T AGRO-INNOVATORS ', '0240915405', 'alikupahrahaman@gmail.com'),
(47, 'Abraham Lincoln Konja', 'NutriYam Enterprise.', '0554710066', 'thepeopleslincoln@gmail.com'),
(48, 'INUSA ISAKA', 'African?s slippers production.', '0547416407', 'Isakainusa8@gmail.com'),
(49, 'Mensah Bright Diankom ', 'Barbering ', '0593447964', 'mensahbrightd@gmail.com'),
(50, 'AKURUGU JOSEPH', 'SPECULATOR OF CEREALS', '0241260645', 'AKURUGUJOSEPH99@GMAIL.COM'),
(51, 'David Kobina Taylor', 'Taylor Farms', '0204172813', 'daviddisc79@yahoo.com'),
(52, 'Kweku Annan ', 'Poultry farm ', '0555078079', '220000033@st.uew.edu.gh'),
(53, 'Emmanuel Pedu Acquah ', 'Fish ponding or farming ', '0556369038', 'emmanuelacquah9038@gmail.com'),
(54, 'Francis Afeku ', 'Manufacturing of Local Soap ', '0256447315', 'reynoldsuccess@gmail.com'),
(55, 'Philomina Adu Boahen', 'Minah Shay Shito and onion paste', '0551835148', 'aduphilomina87@gmail.com'),
(56, 'Mawutordzor Agada ', 'Hydrahub.', '0248946872', 'mawutordzoragada@gmail.com '),
(57, 'Degraft Osei', 'Leather bags making ', '0592793886', 'raymondosei1173@gmail.com'),
(58, 'Josephine  Mensah', '  Coconut  Juice', '0540708480', 'mensahjosephine477@gmail.com'),
(59, 'Frederick Tawiah Donkoh ', 'Online Is My Office', '0540377090', 'mrfredtadon@gmail.com'),
(60, 'Danso-Botwe Jesse Guna ', 'Kadi Shift Courier service and save travels ', 'Degree ', 'Lionnodeeelikeme@gmail.com'),
(61, 'Nyamavor Salomey ', 'Sally\'s enterprise ', '0500204862', 'salomeyn185@gmail.com'),
(62, 'Aaron Haruna Siakah ', 'Cashew nuts oil processing ', '0553264115', 'aaronsiakah1@gmail.com'),
(63, 'Antwi Emmanuel', 'Cassava processing', '0248469351', 'emmanuelantwi3693@gmail.com'),
(64, 'Emmanuel Dadzie', 'Woodwork ', '0543821009', 'dadzieemmanuel084@gmail.com'),
(65, 'GILBERT ESEGBE YAW BRIBINTI', 'Poultry Farm', '0541829299', 'esegbey2001@gmail.com'),
(66, 'NANKENMIE SEIDU SULEMAN ', 'Crops production ', '0241562200', 'sulemannankenmie272@gmail.com'),
(67, 'Mensah Bright Diankom ', 'Barbering ', '0593447964', 'mensahbrightd@gmail.com'),
(68, 'FELIX BRYAN AFEKE ', 'LIKEM?S CONSTRUCTION LTD', '0243683253', 'felixbryanafeke@gmail.com'),
(69, 'Emmanuel Donkoh', 'Expedient Manuel Services ( Money transactions, Mobile Phones and Accessories) 2. Manuel farms', '0557570536', 'emmanuel.7donkoh@gmail.com'),
(70, 'Jakper Joana Yenuloem ', 'Sunrise Revive - Revitalizing Beverages', '0592060480', 'joanaamor1012@gmail.com'),
(71, 'Asamoah Gideon ', 'Restaurant and Hostels.', '0246063558', 'asamoahgideonjunior@gmail.com'),
(72, 'Sukandei Balluwie Abdul_Gafaru', 'I want produce pure water ', '0506273619', '5231500015@st.uew.edu.gh'),
(73, 'Soliu Ibrahim Folorunsho ', 'Graphic designer ', '0544246533', 'saliuibrahim1212@gmail.com'),
(74, 'Imoro Bukari Saniid ', 'Mobile money merchant ', '0241557478', 'saniidambitious1@gmail.com'),
(75, 'Enoch Oduro', 'Poultry Farming', '0204172089/0554', 'odurokwasienoch@gmail.com'),
(76, 'Manfred Atubra', 'Furniture', '0559839864', 'atubramanfred1234@gmail.com'),
(77, 'Collins Marfo ', 'Car Aid ', '0248998359', 'collinsmarfo500@gmail.com'),
(78, 'Ahaji Samuel', 'A&S farms(Poultry)', '0556055344', 'ahajisamuel73@gmail.com '),
(79, 'EMMANUEL DONKOH ', 'Oil palm production ', '0548398440', 'donkohemmanuel025@gmail.com'),
(80, 'Bismark Okine ', 'Agriculture and industries ', '0592688976', 'bismarkokine00@gmail.com'),
(81, 'Abdul Ghaffar Lateef ', 'AMAG travel and tour.', '0244239350', 'ghaffar_ab@ymail.com'),
(82, 'Bassah Mbibah Philip ', 'Production of packaging items ', '0551199244', 'ministerphilip4@gmail.com'),
(83, 'NANKENMIE SEIDU SULEMAN ', 'Crop production ', '0241562200', 'sulemannankenmie272@gmail.com'),
(84, 'Sedem Innocent Gadasu', 'Dry Eats', '0548532049', 'sedeminnocent@gmail.com'),
(85, 'Adjei partison', 'Electrical appliances ', '0596340060', 'partisonadjei485@gmail.com'),
(86, 'NANKENMIE SEIDU SULEMAN ', 'Crops production ', '0241562200', 'sulemannankenmie272@gmail.com'),
(87, 'Adutwumwaa Morosa jessica and justicia senyo ', 'Beauty goals hub ', '0553182010', 'jessicaadutwumwaa700@gmail.com'),
(88, 'DAPAAH EMMANUEL NARTEH', 'BRANDING LOCAL GIN(AKPETESHIE)', '0543315130', 'edapaah901@gmail.com '),
(89, 'Ocran Nyameyie Gloria', 'N&N CLOTHING ', '0553399483', 'gloriaocran16@gmail.com'),
(90, 'Nasiba Adam', 'Hair Growth oil and hair growth butter ', '0547606355', 'nasibaadam48@gmail.com '),
(91, 'Elizabeth Kwaaley Otoo', 'Local drinks ', '0573911490', 'scrupulousnanaadjoa@gmail.com'),
(92, 'AMPONSAH GODFRED', 'Premium Poultry and Processing solutions ', '0546687271', '5241510035@st.uew.edu.gh'),
(93, 'MARTEY GIDEON KOFI', 'MIXED FARMING (POULTRY, CROPS)', '0242856471', 'marteygideon836@gmail.com'),
(94, 'AZOBO DENNIS AYEBASE', 'Expanding my business', '0591936906/ 053', 'azobodennis1@mail.com');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `accepted_proposals`
--
ALTER TABLE `accepted_proposals`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `admin`
--
ALTER TABLE `admin`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `assessments`
--
ALTER TABLE `assessments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `proposal_id` (`proposal_id`),
  ADD KEY `assessor_id` (`assessor_id`);

--
-- Indexes for table `assessors`
--
ALTER TABLE `assessors`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`);

--
-- Indexes for table `proposals`
--
ALTER TABLE `proposals`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `proposal_assignments`
--
ALTER TABLE `proposal_assignments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `proposal_id` (`proposal_id`),
  ADD KEY `assessor_id` (`assessor_id`);

--
-- Indexes for table `rejected_proposals`
--
ALTER TABLE `rejected_proposals`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `accepted_proposals`
--
ALTER TABLE `accepted_proposals`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;

--
-- AUTO_INCREMENT for table `admin`
--
ALTER TABLE `admin`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `assessments`
--
ALTER TABLE `assessments`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=113;

--
-- AUTO_INCREMENT for table `assessors`
--
ALTER TABLE `assessors`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `proposals`
--
ALTER TABLE `proposals`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=107;

--
-- AUTO_INCREMENT for table `proposal_assignments`
--
ALTER TABLE `proposal_assignments`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=113;

--
-- AUTO_INCREMENT for table `rejected_proposals`
--
ALTER TABLE `rejected_proposals`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=95;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `assessments`
--
ALTER TABLE `assessments`
  ADD CONSTRAINT `assessments_ibfk_1` FOREIGN KEY (`proposal_id`) REFERENCES `proposals` (`id`),
  ADD CONSTRAINT `assessments_ibfk_2` FOREIGN KEY (`assessor_id`) REFERENCES `assessors` (`id`);

--
-- Constraints for table `proposal_assignments`
--
ALTER TABLE `proposal_assignments`
  ADD CONSTRAINT `proposal_assignments_ibfk_1` FOREIGN KEY (`proposal_id`) REFERENCES `proposals` (`id`),
  ADD CONSTRAINT `proposal_assignments_ibfk_2` FOREIGN KEY (`assessor_id`) REFERENCES `assessors` (`id`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
