Under the direction of Stewart, Stewart and I reworked the Bailey project database to reflect a 1-N relationship with the recorder_report and the trial tables, instead of a N-N relationship. Therefore, in the case where 2 recorder reports exist for one trial the database will use one record to record both.

Within the database, report_start_date, from the recorder_report table, will contain the publishing date for that recorder report. If there happens to be a second recorder's report the report_end_date field will be used to recorder the second recorder report publication date. If the report_start_date and the report_end_date are the same then there is only one recorder report.

I attempted to create a php file that would read either a tab delimited text file or the .xml file produced by Stewart regarding the Bailey records to create sql statements but it proved to be way too difficult.

I worked with Martin earlier this week to develop a .xsl file that would interpret Stewart's .xml file and produce an .sql file. After cross checking the results with the original .xml I found that we were successful.

In order to further this project I will be creating a web application that will allow users to search through this data.