Creating a data model is like a lot of projects in data. It is significantly easier if you plan first.
The first step to planning a data model is trying to think of all the questions that would be asked of this data.
The next step was to list out all of the different sheets in this data set and what their foreign and Primary Keys would be. With this step I came up with this model.
After these small models I found which data sets most commonly link with each other. For example Sales always links to edition, and Book and Information have a 1 to 1 cardinality so therefore they can be joined together instead of it being a relationship.
With Primary Keys being what dictates the granularity of a data set and foreign keys being what can be found in other sets.
A 1:1 link is when 2 sheets can get joined together on the same primary key.
In this model you can see which are the Primary Keys and which are the Foreign Keys.