Chris Pollett > Students >
Sugi
    ( Print View )

    [Bio]

    [Project Blog]

    [CS 297 Proposal]

    [Intro to jQuery and YUI - PDF]

    [Deliverable 1]

    [Deliverable 2]

    [Deliverable 3]

    [Deliverable 4]

    [CS 297 Report - PDF]

    [CS 298 Proposal]

    [CS 298 Report - PDF]

    [CS 298 Slides - PPT]

    [CS 298 Codes - Zip] 

                          

























CS297 Proposal

Web-based IDE to create Model and Controller Components for MVC-based Web Applications on CakePHP

Sugiharto Widjaja (sugi@widjaja-online.com)

Advisor: Dr. Chris Pollett

Description:

The goal of this project is to develop a Web-based IDE that allows users to create Model and Controller components in a MVC-based Web applications in CakePHP. The IDE will allow users to use drag and drop to create database tables that they can use for their Web applications and they need not know any SQL queries. When the user created a model in the GUI online tool, the table should be created in the database. In addition, a simple php model file should be automatically created. The IDE should also allow users to build queries to perform various SQL operations (such as: select, insert, update, and delete). It should also create a php controller file that includes all the queries that the users have built. This project will be built by utilizing CakePHP framework and jQuery. By using this IDE, users can build dynamic database-based Web applications without having to know any SQL queries.

Schedule:

Week 1 - 2: Jan 26 - Feb 5Study the CakePHP and jQuery
Week 3 - 4: Feb 8 - Feb 19Deliverable 1 - write a simple PHP application in CakePHP that utilizes the jQuery drag-and-drop feature.
Week 4: Feb 22 - Feb 26Study about Query by Example (QBE)
Week 5 - 9: Mar 8 - Mar 23Deliverable 2 - Write a Web application to create DB tables with their attributes. The application will utilize the drag-drop- feature from jQuery
Week 10 - 11: Apr 5 - Apr 13Deliverable 3 - Write a simple Web application that demonstrates the usage of QBE. This application will use static tables.
Week 12 - 13: Apr 15 - Apr 30Deliverable 4 - Write a Web application that allows users to create DB tables with their attributes, link them to crete QBE, and construct SQL queries. (Integration of Deliverable 2 and 3)
Week 14 - 16: May 3 - May 21Deliverable 5 - CS 297 report due

Deliverables:

The full project will be done when CS298 is completed. The following will be done by the end of CS297:

1. Write a simple PHP application in CakePHP that utilizes the jQuery drag-and-drop feature.

2. Write a Web application to create DB tables with their attributes. The application will utilize the drag-drop- feature from jQuery.

3. Write a simple Web application that demonstrates the usage of QBE. This application will use static tables.

4. Write a Web application that allows users to create DB tables with their attributes, link them to crete QBE, and construct SQL queries. (Integration of deliverable 2 and 3)

5. CS 297 report due.

References:

CakePHP Manual. Retrieved December 7th 2009 from CakePHP Website: http://book.cakephp.org/

YUI 3 - Yahoo! User Interface Library. Retrieved December 7th 2009 from Yahoo! Developer Network: http://developer.yahoo.com/yui/3/

[2002] Database Systems: The Complete Book. Hector Garcia-Molina, Jeffrey D. Ullman, and Jennifer Widom. Prentice Hall. 2002

[2005] Database System Concepts. Avi Silberschatz, Henry F. Korth, and S. Sudarshan. McGraw-Hill. 2005