I completed the Codecademy course on SQL Databases. At the end of the course, it prompted me to create my own database. I chose to create a database of some of the books in my personal library using the client Postbird.
The database includes three tables. The main table lists 40 books from my personal collection. The other tables identify the authors and publishers. I created a Primary Key using the book id and two foreign keys using the author_id and publisher_id.
I really enjoyed creating this database and practicing querying it. It was a bit tedious putting the information for each row in by hand, but my son helped me look up the information for each book.
Here is the GitHub link if you’re interested in seeing my repository: https://github.com/tinabear817/my_book_library