The Student Room Group

Bookstore database creation

Hi,

As part of my uniersity corusework, I have to create a bookstore database using simple SQL queries and MS Access.

Now I have create most of the tables n they are as followed:

Bookstock
Customers
Suppliers
Publishers
Customer Payments
Supplier Payments
Stock reordering

The problem is that I am not sure whether or not these entities are good for a bookstore database.

Also, we have to create four different B2Me statements such as "recommended books in the favourite genre of the customers" and these are hard to create query wise when yo uare not a computer wiz.

SO was wondering if you guys had any tips for me, website or software that could really facilitate the task!

Thanks guys

Latest

Trending

Trending