130 likes | 374 Views
Web Interface to Dissertation Database. Matt Rotundo, Arun Jose, Brian Richards, Patrick Stankard, and Diah Schur. Description of System. PHP , MySQL, HTML, and CSS used Create web interface for DPS dissertation database system Add/delete/modify tables and queries Listing tables for queries.
E N D
Web Interface to Dissertation Database Matt Rotundo, Arun Jose, Brian Richards, Patrick Stankard, and Diah Schur
Description of System PHP, MySQL, HTML, and CSS used Create web interface for DPS dissertation database system Add/delete/modify tables and queries Listing tables for queries
Summary of Specifications • Provide User Authentication and authorization • Provide an easy to use administration interface to Add/Edit/Delete data • Improve quality of existing reports
Design Decisions and Related Tradeoffs Aimed for simple and accessible design Visually-pleasing Print tables in an organized and easy-to-read manner No tradeoffs were required in designing web pages (HTML and CSS) All customer requests were fulfilled
How to Address Changes in Requirements? • The system is made flexible to handle changes • Address critical issues immediately • Prioritize the change requests • Implement high changes based on priority and resource availability • Use Model-View-Controller (MVC) development methodology to create a readily modifiable application structure
Components Built / Planned Built: • Interface to • View/Add/Edit People • View/Add/Edit Dissertations • View/Add/Edit External Publications • Basic authentication • User profile view
Components Built/ Planned (Continued...) Planned: • Multi-tier authentication • Validation of input data Potential: • CSV / XML data export • E-Mail notifications • Social media integration
Application Structure • PHP Based • MVC Structure • Controllers • Authentication • Database abstraction • Models • Person • Dissertation • External Publication • Category • Research Method
On to the application! http://vulcan.seidenberg.pace.edu/~cs691-team03-2012/
Possible Additions • Input validation • Advanced user administration roles • Detailed user profile pages • User profile admin (image upload, email, login/pass reset) • Send e-mail on action (edit dissertation, add user to system, etc.) • Content uploading / storage (pdf/doc files) • extend publication reference functionality • Data export csv/xml • Social networking integration • front-end individual document views (not just tabular views)