Project MySQL

I need you to develop some software for me. I would like this software to be developed using SQL. Project Specification

You are required to design and implement a web based application which records and updates information stored in a MySQL Database.

At a minium the application should (i) take information from the screen and insert it into a DB using the “Insert Into” command, (ii) Select Info from a DB and display it to the screen.

You are required to use a versioning approach to the system.

Version1 should be a simple webpage which communicates in some way with a Database. Every minor enhancement to the application should be a different version of the application. Each time you get some small aspect of functionality working take a copy of the folder you are currently working in and change its name to projectV2, projectV3.... and so on. In this way you are expected to be only working on one minor enhancement at a time.

When the time comes to submit the project, if the version currently being worked on is not working you will be required to submit the last working version of the project. In this way students will not be permitted to submit a non-working project. Students submitting a non-working project will receive a fail grade. In the case of a poorly implemented versioning system this will mean the student will be required to submit an early version with less functionality and will therefore find it harder to score well. In this way the “baby steps” approach will be strictly enforced.

Different aspects of functionality which can be introduced:

Multiple database tables. The first and second versions (insert into and select from) should just include one table. As you expand on your system you could introduce a second table. If you have a second table be sure to consider whether you need a primary key - foreign key relationship between your tables. (Your system could still score very well even with one table so its not absolutely necessary)

Login. Allowing users to login. Storing a username and password in the db and validating against these. Preventing access to certain pages unless the user is logged in.

Drop down lists populated from database tables.

Rich forms. i.e. use of a broad range of input controls - checkboxes, radio buttons, drop-downs, slider control etc.

Sessions - Timing out a user who has not accessed the page in more than 10 minutes (or however long)

Calculation based on a DateTime object. You could calculate a persons age given their date of birth or calculate the number of days between two dates.

Marks will be awarded in the following areas




Software Quality (Software quality will be considered in terms of comments in your code, proper indentation and a good versioning system)


Taidot: tietojärjestelmäarkkitehtuuri, testaus/laadunvarmistus

Näytä lisää: mysql project example, mysql project ideas, mysql website configuration tool download, mysql code examples, mysql database project ideas, mysql project download, mysql projection, database projects for students in mysql, availibility linux project mysql, integration services project mysql, ejb inventory project mysql, mini project mysql, attendance system project mysql, visual basic project mysql database, access project mysql, create setup project mysql database, online examination project mysql php, project mysql, project mysql php, php full project mysql

Tietoa työnantajasta:
( 0 arvostelua ) Ireland

Projektin tunnus: #15816295

Myönnetty käyttäjälle:


I am a professional web developer. I would like to develop a website for you. But first we need to discuss your project. Please send me a private message, so that I may start Relevant Skills and Experience Software A Lisää

$25 USD 1 päivässä
(0 Arvostelua)

4 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

$55 USD 1 päivässä
(0 arvostelua)

. . Relevant Skills and Experience mysql, php, java, python, cgi Proposed Milestones $22 USD - on acceptance $200 USD - on completion

$222 USD 5 päivässä
(0 arvostelua)

Sure. It is interesting to do this. Can show you demo of my previous work via teamviewer if you need to test the water before taking it. Thank you. Relevant Skills and Experience PHP, Mysql. Proposed Milestones Lisää

$111 USD 3 päivässä
(1 arvostelu)