A manageable online member profile and job posting database

Using SQL 2000 and ASP the client requires a database and management interface constructed for member profiles and member job postings to be added, edited and deleted as well as displayed to the public via their website. There are two types of members ??" firm members and individual members. Each member group will have similar data fields with the firm member group having a few additional fields to be captured and displayed. There will need to be two types of access to the management of the member database ??" each member will have access via their member id and password to edit their personal profile and job postings. The client will have an overall Administrative username and password that allows for editing of all members and job postings. The client has provided an outline of the data fields that need to be captured and stored in the database for each member and their job postings (see [login to view URL] in attached [login to view URL]). The client will provide template HTML pages ??" with the interface layout. The contracted programmer will need to convert those pages to working ASP interface that interacts with the database. These template screens will be provided prior to work commencing. Public display of member job postings will be general chronological data display sorted by most recent post to oldest post ??" 10 postings to a page. These template HTML screens for job posting display will be provided prior to work commencing. Public display of member profiles will have four options for sorting. Public users can select to see All Member profiles, Firm Member profiles only, Individual Member profiles only, or All Member profiles with a specific specialty (specific specialties will be a data option when members profiles are constructed ??" see [login to view URL]) These template HTML screens for member profile display will be provided prior to work commencing. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) ASP scripts must be installed by the Seller in ready-to-run condition on [login to view URL] servers in the clients account. b) SQL Server 2000 database tables must be constructed by the Seller on [login to view URL] servers in the clients account. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. 4) The deliverables include the following (all referenced documents can be found in the attached file [login to view URL]): a) Creation of SQL tables per specs in [login to view URL] b) Functionality of Administrative management interface per specs in [login to view URL] c) Functionality of Member management interface per specs in [login to view URL] d) Functionality of Public interface per specs in [login to view URL] ## Platform Windows Web server with ASP and ASP.NET enabled. SQL Server 2000 database. Hosting company is discountasp.net.