We need to create an online student datbase software website that will allow users to login and manage a database filled with student pictures and information.
Security is important so we will need to create users and passwords.
Interface look is important too - we want it to have a nice clean feel with ease of use.
There will be a front end customer interface and a backend administrative user interface.
Additional information below in the detailed description area..
## Deliverables
We need to create an online student datbase software website that will allow users to login and manage a database filled with student pictures and information.
Security is important so we will need to create users and passwords.
Interface look is important too - we want it to have a nice clean feel with ease of use.
There will be a front end customer interface and a backend administrative user interface.
The front end will consist of the login screen with the user name, password, and school specific Pin number. The database will store multiple schools with multiple student records. Only one school will be accessible determined by the Pin number to that group of users and passwords.
Once logged in the user will see a database listing with Last name, First name, Grade, ID number and a thumbnail of that students image. There will be two user levels - an admin user can edit and read and a standard user can just read with no edit permission.
Admin user can edit records on the main screen. There should be a save button next to each record. User can also click on any of the name, grade, id or picture to open the individual student record which will take them to the next screen.
If a user clicks a record it should load an individual record screen where they can edit the fields and add or edit the uploaded picture.
On the backend side - User interface looks are less important because they will not be seen by the customer. We'll need to be able to Add Schools, Edit School and Delete Schools. There will need to be a listing of all schools with # of records and an auto generated school number (which is also the Pin).
We will also need an upload option to import all of our records from a CSV file. The file will always be formatted the same and will contain all of the information as well as the picture information to be imported. These files can sometimes contain thousands of records and pictures that all need to be uploaded into the program.
Important that the customer side can be viewed on mobile tablets as well.
Database will be MySQL - User interface can be whatever language you prefer - probably php