I am currently using Microsoft Access to create a E-BookStore database, and have created 7 tables (Author, Book, Book Copies, Purchase, Member, Publisher and Feedback). No GUI is required its meant to be a simple database.
One of the database requirements is that members of the database can submit a score for the books that they have read (Score are from 1-10). I have tried many different ways of creating this relation but for some reason it doesn't seem to work.
The Pictures below will elaborate on the question even more.