display mean and variance of purchased items

This is a discussion on "display mean and variance of purchased items" within the Other Programming Languages section. This forum, and the thread "display mean and variance of purchased items are both part of the Program Your Website category.



Go Back   Webforumz.com > Main Forums > Program Your Website > Other Programming Languages

Notices


Reply
 
LinkBack Thread Tools
  #1 (permalink)  
Old Mar 12th, 2006, 00:19
New Member
Join Date: Mar 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
display mean 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. 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
File Type: jpg er_bookshop_4.jpg (27.4 KB, 56 views)
Reply With Quote

  #2 (permalink)  
Old Nov 4th, 2006, 21:10
New Member
Join Date: Nov 2006
Location: uk
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Re: display mean and variance of purchased items

If you message me with a bit more detail i'll help you through it.





THANKS ANDY!!!
-
teesside website design - website design in teesside -
Reply With Quote
Reply

Tags
display, mean, variance, purchased, items

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Div not expanding to contain items inside snappy Web Page Design 6 Dec 6th, 2007 13:54
summerizing multiple items at once. Javilen Databases 1 Sep 20th, 2007 20:45
passing items to paypal dab42pat PHP Forum 5 Jun 16th, 2007 10:13
Animation for menu items David Blake Flash & Multimedia Forum 12 Jun 14th, 2007 00:54
PHP includes menu - problems with sub-items fallen_angel PHP Forum 3 Jan 19th, 2007 17:15


All times are GMT. The time now is 23:59.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0 RC8
© 2003-2008 Webforumz.com : All Rights Reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43