Database Reference
In-Depth Information
Primary key
type
Table name
Hash key
Range key
Publisher (publisher-
Id,..)
Hash key
publisherId
—unique publisher ID
NA
So, here it makes sense to use the composite hash and range key for the
Book
table,
which will allow us to have balanced books data depending on their year of publishing.
As we don't have many ranges for the
Author
and
Publisher
table, so here we have
opted for only the hash key.
After the redesign, sample
Book
items would look like the following screenshot:
