(a) We have a large number recipes in tsv (tab separated values) files, here is a sample of the tsv (http://queenofsheebasf.com/r/samples3.zip) (please use enclosed php to view tsv file format) (b) Design a compact but fast and responsive relational mysql database, with indexes and other things so that queries on the db are fast (c) Write a php script to upload the contents of these tsv files into the db (d) While uploading the php script should accurately detect the "food" name in each ingredients line from a list of unique food names (dictionary we have, this list can also be uploaded to the db) and save the unique food name id along with the ingredient line (e) Write php script to list recipes filtered and sorted on categories, main ingredient, cuisine, tags, glossary, total yield, servings, preparation time, cooking time, course, occasion, dietary (f) Write php script to list recipes by search on title / ingredient / ingredient and ingredient quantity (any measure) / directions / tags / glossary / description / notes / categories / etc (searches may be entire phrase or any word)