Need a database driven iPhone application.
Two database tables, one listing categories with a parent category field to allow for recursion (sub categories). Final category will list links to videos (second database table). Videos are in AVI format lasting between 5 and 7 minutes in length (High Def with audio).
example:
Parent Category 1
* Child Category1
> Video link1
> Video link2
> Video link3
* Child Category2
> Video link1
> Video link2
> Parent Category 2
* etc...
There will be other simple static textual pages within the application. I'd like the ability to have the data stored in a file format (possibly html) so that I can modify/tweak them if a need arises (such as contact information changes).
## Deliverables
I've never developed an iPhone application before, so my assumptions in the description are based upon what I would do if it were a desktop application or web application. If my description doesn't accurately reflect what is possible within the iPhone application, then feel free to educate me.