Skrrp :bisexual_flag: on Nostr: #[0] 3NF at best. I'll admit to knowing fuck-all about Dewey, but I suspect that ...
Abby!!! (npub1qwf…2ea6) 3NF at best.
I'll admit to knowing fuck-all about Dewey, but I suspect that could be a sub-table.
ISBN, Issue, Issue Date and Publisher smells like another sub-table. Medium could probably be lumped in there too.
Rating should be a many-to-many relationship between Book and .. Rater? User? However you represent that in your system. Yeah, you could denormalise the aggregate rating on Book.
Oh, and 'Book'. Singular.
I'll admit to knowing fuck-all about Dewey, but I suspect that could be a sub-table.
ISBN, Issue, Issue Date and Publisher smells like another sub-table. Medium could probably be lumped in there too.
Rating should be a many-to-many relationship between Book and .. Rater? User? However you represent that in your system. Yeah, you could denormalise the aggregate rating on Book.
Oh, and 'Book'. Singular.