database and intranet

(university final year project for a small business) require an intranet for staff and management. business is local designer shoe store with 4 branches, need a database and intranet made so staff and management can perform searches on product and insert and update things such as customer details, product details etc. further information on business will be given when bidder has been chosen. ## Deliverables database i would require the tables to be done in notepad and i will create and insert the data myself as there is a lot. once this has been done i will send you the information so you can get on with the rest of the project. the database in intranet will be all connected to the university system. for the database i will give you the connection that has to be scripted. for the actual intranet i would like it if u sent me the pages on notepad an i will connect them the system. intranet. this needs to be a secure site, i would like a login page for staff and management to log in before they can enter the site (include delete, register and edit). would like a page for staff to insert customer details so promotions and news about the shop can be sent to them either via their email or by post (inc new customer, delete, edit, etc). main functionality with staff is for them to check each store individually via the intranet and to do a search of the shoe they want with the right colour, size and material. once found and available i would like them to be able to click an on something so an automated email is sent to that particular branch requesting that product be sent to the current branch. would need the staff to manually update the products when goods have been sold or returned. therefore an update functionality would need to be considered so they can enter a sold or available next to that product. for the manager i would like him to be able to conduct some searches showing which brand is most popular, which size is most popular, etc inorder to help him forecast future orders. ## Platform windows, html, php, mysql