•Project:

• Construct a database that supports scientific research, that uses multiple-probe-per-gene microarrays (such as Affymetrix and NimbleGen), and demonstrate its utility for answering 5 interesting scientific questions that require at least 2-table joins.

• You will need to develop the use cases of interest, then model the data and then construct a relational schema that supports the queries you have formulated.

• You are to instantiate your database, populate it with real data, at least some of which is from a public data repository, and then formulate and process the queries in the database and retrieve the results. You must indicate how you have validated the data input and the retrieval results.

•  Produce a Final Report that includes :

• Work flow, Process flow and Data Models, represented as diagrams
• Data Source(s) and files
• Schema Instantiation scripts and table population scripts Queries
• Any interface you develop for handling them (SQL, not a Web interface unless you want to do this)

• The write up should be structured as a research article, document the stages and discuss the problems you ran into with your approach, compare it to others you found in researching the topic