I need a database that will handle about 9 data fields and associate them with an image file. I will provide sample image files, data filed definitions and sample data. I will provide the HTML page for entering, viewing and searching the data, and will require assistance in connecting the HTML with the database.
## Deliverables
The database needs to correctly associate the image file with one or more rows of data in the database.
The website will have a page to enter information into the database. Entry will require an image file and the first and last name fields.
The first and last names can be ?? or any alpha characters and - and ' characters.
Date fields must be entered in a specific format of DDMMYYY and display in the format MMM DD YYYY.
All other fields will be defined with max lengths and accept any typed characters.
The website will have a page to display all entered data showing a thumbnail of the image and the associated row data.
The website will allow a search function to search last names with a minimum of 2 characters, and display the rows of matching data.
A user can select on a row to get a single image display with all associated data fields displaying. This might be tricky in that a single image file can have several rows of associated data.
I will accept suggestions from the coder on how best to display the information, and will need some assistance on how to set up the connections to the webpages.
Please send your best estimate for this project to completion.