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)