Currently using a "quick and dirty database design". So I can get an initial version of my app working
Currently consist of multiple pages that are not linked to each other
Learnt I need to "normalize" my database. That is, minimize redundancy
(for example, storing the same data in more than one table) and dependency.
It's seems I need to divide large tables into smaller (and less redundant) tables
and define relationships between them. The objective is to isolate data so that
additions, deletions, and modifications of a field can be made in just one table
and then propagated through the rest of the database via the defined relationship
Need to make it more sophisticated and scalable
Would like to make the entry page to this app a dash-board.
Revamped the whole look of the app using jquery-ui
The new interface has prompted me to further refine the "user experience" by using AJAX to
respond to users actions
The dashboard has been replaced with tabs. One for each operation
(Add new record, Find a record, Edit a recode, and Document management).
Need to find somebody that can help me make it look more appealing
THE DATABASE WILL NOT ACCEPT DUPLICATE CIT OR SERIAL NUMBERS.
The only input variables required to add a new record is a CIT #, S/N and Comment.
These are being used to track the movement of a piece of equipment.
Haven't spent much time on this yet... Have to decide if the make more input variables required.
Checks now being done by a jquery script.
Integrity checks of new record data is being done with php. The php script is being executed by jquery
(Note: input type=submit will not work with jquery need to use type=button)