Android App and db Design Refinement Consulting


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?

Thank you!

Skills: Android, Mobile App Development, Graphic Design, User Interface / IA, PHP

See more: visual android app design, android app store contact phone book db, simple android app design, android app using camera, using gps android app development, android app layout design, android app icon design, android app interface design, android app graphic design, android app java design, android app banner design, android app game design, android app home design, android app navigation design, android app ui design, android app freelance design, Music Android App Logo Design

About the Employer:
( 0 reviews ) Alexandria, United States

Project ID: #20852159

4 freelancers are bidding on average $194 for this job


Hello!!! How are you today? I am very interested in your project. I have read your project description correctly. I have developed many mobile android and ios apps for 6 years by now.. I would like to work with you for More

$140 USD in 7 days
(230 Reviews)

From the description , I understand that you want to develop an enhanced version of instagram where logged in users can subscribe to content generators based on zip code , Basic FLAW : We cannot use sqlite as that is a More

$145 USD in 1 day
(8 Reviews)

Dear client. I am a senior mobile app developer and a serious bidder. I have rich experiences in mobile app development with Java and backend development with PHP. I have read your requirement and I am confident tha More

$350 USD in 10 days
(21 Reviews)

I've 7+ years of experience in Web Development/Web design, Mobile App Development(IOS/Android), Graphic design, Logo Design Business Cards & Stationery, Flyers & Brochures, Packaging Design, Web & Mobile Design, Social More

$140 USD in 7 days
(2 Reviews)