pleez i need some help in my DB

[metal-head1987]

hi

pleeez help ...

i need to implement these 2 tasks in my database:

stock maintenance :
when a customer buy one DVD , it will take one number of the '' copies' number '' field at '' DVD update'' table. and sooo on

profits or loss :
it will calculate the profits if there is any and the losses ( query ). for example if there is any DVD got dimaged or on sale season

thanx for ur time .....

 

[Darth Vodka]

you work for a DVD company?

 

[metal-head1987]

you work for a DVD company?

nah,, im just a IT studen ...
it is my final school project ...