Go4Expert

Go4Expert (http://www.go4expert.com/)
-   JSP (http://www.go4expert.com/forums/jsp/)
-   -   Displaying th emean and variance of purchased items (http://www.go4expert.com/forums/displaying-th-emean-variance-purchased-t625/)

chickenyd 12Mar2006 06:10

Displaying th emean and variance of purchased items
 
Hi

i am trying to create a program using WML, WMLSCRIPT, AND JSP. The task is to create a website to be displayed in the WAP Browser. In the website for a company called 'BargainBook' that sells books and the ERD diagram for this is attached as picture (see attachement).

So now I have just finished creating a login and register page and nearly done on purchase page BUT what I want to do is to find out how to display the MEAN and VARIANCE of purchased books in a given period of time (let say 1 week for example) . Plus how can I extend my ER Diagram in order to add this because I think I may need a separate entity (or table) for this.

Any explanation will be very much appreciated. As I said I think need a new table for this BUT I do not know what kind of record should be stored on it that would help with the calculation. And also, I would like to know the suitable SQL queries to calculate the mean and variance for a given period of time.



thanks

chickenyd 12Mar2006 07:04

Sorry Here Is The Attachment Erd
 
1 Attachment(s)
Sorry I Forgot To Put The Erd Before. Here It Is..

shabbir 12Mar2006 10:45

Re: Displaying th emean and variance of purchased items
 
You need to store the "order time" and calculate the mean/variance based on the time frame a report demands.

coderzone 12Mar2006 10:51

Re: Displaying th emean and variance of purchased items
 
The ERD needs lots of modification specially some of the relationships specially Book-BestSeller and Order-Book

chickenyd 12Mar2006 17:48

Re: Displaying th emean and variance of purchased items
 
so shabir what you are trying to say is in the order entity i need tobstore time?? Ok i will try that then.

chickenyd 12Mar2006 18:24

Re: Displaying th emean and variance of purchased items
 
coder zone explain what you mean by the ERD needs a lot of modification ?? HOW??/

shabbir 12Mar2006 22:06

Re: Displaying th emean and variance of purchased items
 
Quote:

Originally Posted by chickenyd
so shabir what you are trying to say is in the order entity i need tobstore time?? Ok i will try that then.

Yup. As you are tracking orders and need the mean and variance you need to be storing lots of time like OrderTime, DeliveryTime, ShippingTime ...

coderzone 12Mar2006 22:15

Re: Displaying th emean and variance of purchased items
 
Quote:

Originally Posted by chickenyd
coder zone explain what you mean by the ERD needs a lot of modification ?? HOW??/

Book and Best seller your relationship is
One Book is to many BestSeller but actually it should be BestSeller is a type of Book relationship. i.e. Is a relationship.

Book and Order relationship
It is One book many order but it should be Many Books one order.

Offtopic comment:
Hey thats my Post No 100

shabbir 12Mar2006 22:20

Re: Displaying th emean and variance of purchased items
 
Quote:

Originally Posted by coderzone
Book and Best seller your relationship is
One Book is to many BestSeller but actually it should be BestSeller is a type of Book relationship. i.e. Is a relationship.

Book and Order relationship
It is One book many order but it should be Many Books one order.

I would like to add that Order should not be an entity but it should behave as a relationship between Account (Customer) and Book.
Quote:

Originally Posted by coderzone
Offtopic comment:
Hey thats my Post No 100

Also Congrats on completing 100 posts.


All times are GMT +5.5. The time now is 14:16.