Project Phase II

Project Groups Page


In this phase you form groups of 3 students, one from each domain of Phase I. Together, each group forms an E-Business company. Your company will provide a web shopping interface to clients, and a decision support workbench to managers in the company.

Through this project, you will learn:

About Grouping:




Most of you have web-shopping experiences, so it's easy to understand what needs to be done. In this part, you'll generate your own web-shopping site.

The details of web shopping includes:

Management Information Query

The second part of Phase II is to built a tool that helps the managers in the company get certain information for further business analysis and decision making. 

You should provide a simple front-end to answer the following 3 queries. Even though you are asked to provide answers only to the three queries below, you should try to figure out a general solution for the problem of querying across multiple databases. So when we give you some other queries at the end of Phase II, you should be able to implement the interfaces and answer the queries quickly. NOTE: you only have to consider select-project-join queries possibly with grouping and aggregation.

Rules and Restrictions

You should implement web-shopping based on the 3 separate databases for the 3 domains. 

What and When Do I hand in?