How to display remaining stock of the rental video shop

[phani2020]

Hi I am working on a video rental shop database. In my shop I will maintain only 1 stock each but with different formats like DVD,VHS and Blueray. Now Can someone please suggest about how to write a query on remaining stock? Thank you.

 

[Mihail]

Hi I am working on a video rental shop database. In my shop I will maintain only 1 stock each but with different formats like DVD,VHS and Blueray. Now Can someone please suggest about how to write a query on remaining stock? Thank you.

No. Until we don't know the DB's structure the answer is NO.

 

[Steve R.]

In my shop I will maintain only 1 stock each but with different formats like DVD,VHS and Blueray.

As Mihail pointed out, more needs to be known about the database. Based on only having one copy based on format type, you can have a logical field for "checked-out". You would not need to compute the stock-on-hand.

Of course the downside to that approach is that if you get more than one copy based on the same format type, the approach mentioned above would not work without further modification.

 

[phani2020]

Shall I attach my project here?

 

[Mihail]

Shall I attach my project here?

Yes. Access 2003 format

 

[phani2020]

I have attached my work here. Can you please help me on "how many copies of titles(movies/games) are still available?". Thank you