Maybe I think to much in normalized databases.
I have 50 books that I like to share with friends. Every friend who reads a book is registered and I like to know their thoughs about every book read.
I have four sheets:
ReaderID FirstName LasteName Age FavGenreID
BookID Title NoPages GenreID
GenreID Genre Description
ReaderID BookID DateTimeStamp Rating Reveu
I like to make an app with three items:
Readers -> List of readers. when you select a reader I like to show a list of books he has read. When I select a book from the list I like to show the details of that book. I like to add a BooksRead item from this screen.
Books -> A list of all books with their overall rating. When I select a book I like to see who read it and what the rating was.
Genre-> Here I like to see a list of Genres. per Genre the list of books. I also like to add new genres overhere and generate a new unique identifier for the newly added genre.
So thats the long answer to my basic question