Ok.. i have this dta model... i have created a schema etc etc.. and i have some questions for which i ave formulated some queries.. Please have a look and tgell me if you can find any flaws in the query.. and are there better ways in formulating the same queries.. i have posted my data model and the queries... and excuse my data model for the double ended confusing relation depiction....

if youn need more info to see what is happening please post..

thanx in advance