IPhone App to coincide with online quiz using MS SQL db

I have an established online web quiz which contains a flash frontend quiz and MS SQL database. I now would like a developer to be able to put the quiz onto the IPhone.

The basic idea will be that the IPhone will communicate with the MS SQL database to (i) check if the user’s details are correct and (ii) load the questions every time a subject is selected. This is very important as I have over 3000 question in the database and it is increasing every month.

Unfortunately the chosen developer will not have any access to the database or file system due to security and personal copyrights, but I have constructed a demo quiz for the developer to use both on his local PC/Mac and online. It is essential that the developer has Microsoft SQL Server 2008 installed and is fully aware of how to use it.

It is also essential that the developer is able to read doc files as this is my way of communication.

To connect to the database, either local or online, is by a connection string and the developer must understand what to do with this.

I will NOT convert the database to MySQL, XML or any other format.

I will expect a progress report and all correspondence must be answered and NOT ignored.

I do not own an Apple Mac and I have never developed software for the IPhone operating system so I will require for the developer to suggest a way for me to view the beta and final versions.

The reason for being so strict is because this is the 3rd attempt in getting the app developed. I have been let down every time.

The questions are loaded in random from the MS SQL database before the quiz loads and this will need to happen on the App.

There are 4 pages in total on the online quiz.

The opening screen

The main quiz screen

The review screen

The result screen

When the quiz is finished the following bits of information need to be written back to the MS SQL database.

• Subject

• Username

• Score

• Status (Pass or Fail)

• Time taken in seconds

• Date

The IPhone App

Page 1 - Startup

Initially at start-up, the user will have to put in his username and password and then I would want the app to connect with my MS SQL database and check that the user is registered to use this app. If not then they are taken to a web page on my web site where they can register.

Page 2 - Main

Then we have the main menu, where the user can choose the subject quiz he would like to do.

Page 3 - Quiz

This is the quiz page, the user, if possible, will have the same view as if he was on the web site without the question ID. If the question has a link to a picture then an icon will show up so that they can view this. After the user selects the answer thy will get either a tick (correct) or cross (wrong) and a next button. The score will be updated before moving onto the next question.

Page 4 – End of Quiz

This will show a summary or all the questions that they have take with the result of either correct (tick) or wrong (cross)

Page 5 – Result

This page will show the same as what is on the web site result page

I would the like the result variables sent to a MS SQL database on my web site where I will write the code to put it in to main database.

Maximum characters

Question – 400 with html characters i.e. (</p>, <br />)

Answer A – 165

Answer B – 165

Answer C – 165

Answer D – 165

All information regarding web site address, variable names, subject, question ID, names and MS SQL database information will be given to the developer.

This IPhone application once completed will need to be uploaded onto the App store for approval. I personally do not have any experience in this field and will require the developer to take care of this procedure once all final checks have been completed.

All the logo’s needed will be supplied in any format.

The background colours and other logos will need to be discussed.

All graphics will be designed by the developer.

Minimal sound required.

Once the final application is finished I will require full copyright and all coding

ASP iPhone SQL

Nº del proyecto: #827365

Sobre el proyecto