3-tier Application (Using web you need to use PHP and MySQL database)

This assignment has two parts: the work outlined in this documentation and the project demonstration to the class. you need to design your database system first, then translation your design to a Web application using server side scripting language PHP. It is required that you use the open source database management system MySQL and the PHP language to do this 3-tier architecture.

You must supply the following website information:

Web address:

Website Administrative login:

Password:

The important guidelines for this assignment are the following:

your website should work on major features (especially those database operations).

your website should work on the below major features:

Have links or navigation tools in your main page to reach all the pages in your web site.

Able to successfully insert data into your database through a web interface.

Able to successfully display data from your database through a web interface.

Able to successfully update data in your database through a web interface.

Able to successfully delete data from your database through a web interface.

Problem Description: you need to choose an application domain by yourself. Some example domains are: online stores, online banking, online video stores, inventory management applications, etc.

Once the application domain is chosen, you need to do the design (include ER diagrams). Once the design is done, you translate the design into a real application.

REQUIREMENT FOR WEB PAGES

You need to develop a web site with modest complexity. Your website must have at least 7 vastly different pages. Two pages are considered vastly different if they have different structures and different contents; for example one is a form with gadgets and another is a main page with text. If two pages have the same structure and differ only in the content of the text, then they are not considered to be vastly different. Also, two form pages are vastly different if one is for data insertion, the other is for data updating or deleting.

Among this minimum number of pages, you must have at least three form pages: one for data insertion, one for data updating, and one for data deleting. You also need to have at least one page to display data coming from at least two database tables.

The Main Web Page

This is the first page of your website. Usually, the page is named index.html (or index.php). If you do that, a user can find your website by typing just the web server