We are looking for a database design for a kids casting agency. The database will be online and will hold details of each child in the agency, such as height, weight, skills, CV etc. The photo of each child will be able to be uploaded easily by the administrators. More than one photo should be able to be uploaded and one of those specified as the main photo by the administrator. Every parent of each child will have a unique login username and password (which we will be able to disable at any time and which will automatically be assigned to new kids once we have put them on the database) which will enable them to update their child's details (but not be able to change the photo). Before the updated details go live the administrators will receive an email stating that an update has been made meaning the updated details can be checked before they go live.
Prospective casting directors should be able to list the children on the database by different search criteria, such as age, height, gender, skills (keywords) or a mixture of a few search criteria to narrow down the search. The relevant criteria should be displayed as photos with names, age and location (city). There should be a 'more details' under each child search result which enables other information such as height, waist, hair colour, eye colour etc etc to be displayed (in a lightbox/overlay on the page).
In addition, casting directors should be able to add children to a lightbox to review, with an option for them to be able to email the administrators the names of the selected children to enquire about availability aswell as enclosing the enquirers contact details. The photos in the lightbox should also be able to be downloaded as a PDF with company logo at the top.
Also a 'New Faces' page which would duplicate all the children added in the last 3 months. Automatically adding new kids submitted to the database and removing ones that have been there for more than 3 months.
Finally, a feature for the administrators to be able to (via the back office) select multiple children and email their photo, name and age to prospective clients (as a PDF)
*IMPORTANT - The design of the database needs be 'Apple'-esque, clean, modern, minimal. A template for the pages has already been designed as a PSD this will need converting to html/php etc and the coding will need to be integrated into this.
The coding needs to be done in PHP/Mysql ideally and integrated easily with Godaddy hosting.
Dear Hiring Manager,
Professional and quality work is my prime commitment. Please review PMB for details and allow me to do the job for you.
Thanks
Eemon
My dear director of this pos project, we are a group of experienced developer having strong knowledge over the web technology, we have made some dynamic project that are fully commercial, we provide 99% quality guarantee