Alrite cheers for that mate, my assignment I have to do is:
The Faculty of Advanced Technology has a Centre for Electronic Product
Engineering (CEPE). This centre develops prototypes for industrial customers. Within the centre there is a need for a web-based tool
that tracks initially the components used within CEPE and each project. On a longer view this tool could be linked to a time management
and project management tool and integrated under the umbrella of Twiki pages. However, the initial spec is for a database and reporting
tool for components. The main features shall include,
- previously used components
- in stock components
- component details (manufacturer description, supplier [multiple], order number, cost, etc). It would be nice to be able to read
some the information from the supplier database (CD/webpage). Main suppliers are RS and Farnell, but there are many others that are used.
- Stock level
- Level warnings (user setable)
- Component check out feature against a project
- Bill of materials used for a project and/or a period
- Order email creation, I.e components are selectable fom the database (new components maybe via the supplier webpage) and then an
email is created with the order details
- Suplier information (name, address, account details)
- Add new components via supplier cd and/or webpage
- Add/remove/edit facility
- Maybe datasheet storage for each component (if applicable)
- Maybe storage of additional information (attachments), e.g. sample circuits, footprints, etc
So im gonna have to start looking into this