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. Specifically, 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

Attached Images

er_bookshop_4.jpg (27.4 KB, 56 views)