I want a social network app created for Android users and I need advice on the design plan that I have attached. I want to pay $70 for revisions to my plan. In the end, I want a revised database design and course of action to provide to a developer. I will provide extensive details to help you formulate ideas and understand what I am looking for.
I want users to be able to take pictures of items and send that picture to his/her subscribers. I want the subscribers to have the ability to select those who send out pictures (content generators) be seeing the most recent submissions by the content generators in his/her local area.
I expect 5 to 7 pages to be created. I would like the have all users host their registration, login, password and items of interest preference data on their device by way of SQLite. (If this is not necessary then let me know.) The pages that I believe are necessary are as follows:
Splash Page – Will have links to registration/registration update page, content generator subscription page, and the take a photo page. It will have a link to an outside webpage for more information regarding the app. This page will also show, in rotating succession, show the most recent submissions. The most recent submissions should be called to this page from the items db.
Registration/Update Page – This page will allow users to register and to update their registration information. Registration would require an email address but the email address would always be hidden from other users.
Take a Photo Page – This is the page that content generators would use to take a picture of the items. The cursor would default the description box and a dropdown list of approximately 300 potential locations in the United States will be offered. If the location is not listed then users will have the option to type in the location name. The location will be indicated to subscribers by the state and zip code of the content generator who took the picture.
Subscribe Page – This page will be partially dynamically generated from the db. This page will list all content generators by zip code, state, and interest area. Subscribers will have to ability to locate people in their local area by typing in their zip code or selecting their state from a dropdown list. Subscribers will also have the ability to read the motto/slogan of the people in this database. Subscribers will also have the ability unsubscribe to content generators using this page.
Other Pages – If you can think of another page to enhance functionality then please offer your suggestion.
I expect there to be a database containing the most recent photo submissions from content generators. Each user would have a basic profile consisting of: profile name, state, zip code, motto/slogan and interest areas. I don’t believe that location services would be needed because subscribers would have the ability to search for local content generators (the people who take pictures of items) by state, zip code and interest area.
Archived submissions of merchandise should not be saved on the user’s device. If possible, older submissions should be archived in the user’s personal email.
I have provided additional details in Micorsoft Excel format. The pages consist of my view of the local db, the subscriber/content generator db, the submission db and the pages needed in the app. Please let me know if you have questions and if you have ideas on how to improve this vision (or even make it simpler) then send me your solutions/suggestions.
Please address the flaws in my db designs; is there any thing that needs to be added (or removed from) to the app or databases; How much would you estimate this entire project: app creation, database creation and hosting to cost; what am I missing?