Database design

Hi, need a software totally based on JAVA...So i need a java expert requirements of the project will be as following: STOCK MANAGER DESKTOP APPLICATION FOR TAKING RECORDS OF CEMENT DETAILS, IRON & STEEL,MULTI-MEDIA, ELECTRONICS AND PROVISIONS OF DISTRIBUTION INDUSTRY. 1. Taking stock i.e Recording of day to day transactions. 2. Create different account list for each products example: Cement, Iron & Steels, Multi-Media, Electronics,Provisions of distribution and sales industry. 3. Taking inventory/Services adjustment. 4. Ascertain the real and accurate balance after each sales. 5. Taking of records of payment channel or mode. 6. Taking records of income and expenditure of all the transactions made. 7. Automatic updates after recording any transaction made either addition, subtraction and multiplication. 8. Weekly or monthly Time sheet and account reconciliation and Report taken 9. Employees details, payroll, Sales Representatives details. 10. Creating users account for different users or administrators/Manager and Log in details and [login to view URL], assigning privileges to different users in-terms of update,creating,deleting etc. 11. Printing of invoices after each transaction. 12. Send PDF, excel format and Email 13. Import and Export files and pictures 14. Backup data and restoration point. 15. Caculator and Time and Date in the application. [login to view URL] creditors and Debitors transaction [login to view URL] the employee and customer that made the transaction. [login to view URL] sms to customers or clients on any transaction made either credit or debit [login to view URL] records of customer that are owing or Debitors. [login to view URL] to add comments and office reports and letters. CUSTOMER RECORD 1. Customer code auto increment 2. first_name 3. last_name 4. mobile Number 5. email_address 6. gender 7. contact_address 8. date_created automatic 9. website_address 10.Customer_Description PRODUCT CATEGORY 1.product_category_id 2.product_category 3.product_description. VENDOR CATEGORY 1.vendor_category_id 2.vendor_category 3.vendor_description [login to view URL] RECORD 2.product_code 3.product_category 4.product_name [login to view URL] desc [login to view URL] at hand 7.re-order 8.unit_price [login to view URL] price [login to view URL] supplied 11.vendor_code 12.date_created automatic SALES/TRANSACTION 1.transaction_id automatic 2.product_id [login to view URL] of Item(s) [login to view URL] title [login to view URL] desc [login to view URL] amount [login to view URL] amount [login to view URL] channel [login to view URL] name [login to view URL] name VENDOR RECORD 1.vendor_code 2.vendor_category_id [login to view URL] name [login to view URL] title [login to view URL] description [login to view URL] number [login to view URL] address [login to view URL] address [login to view URL] address [login to view URL] website PRODUCT SUPPLY product code product No of item(s) No of supplied EMPLOYEES RECORDS [login to view URL] code [login to view URL] name [login to view URL] name [login to view URL] no [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] status [login to view URL] description [login to view URL] manager [login to view URL] address [login to view URL] employeed [login to view URL] title [login to view URL] jobs [login to view URL] or referees [login to view URL] address Please this is just the sample and don't depend on this only because there are many attributes that i didn't add or include. i expect you to modify and add more functionality and new updates that will enhance better application