From the course: Creating a Book Search Engine from Scratch Using Java and GitHub Copilot
Join today to access over 25,300 courses taught by industry experts.
Designing the book schema
From the course: Creating a Book Search Engine from Scratch Using Java and GitHub Copilot
Designing the book schema
- [Instructor] Alright, welcome back. So far, we have focused on creating a database inside a Docker container. Now it's a good time for us to move on to the next step where we are going to insert books information in this database. Now all the books information are available on a CSU file sitting in a remote GitHub gist. And I'm going to take a small sample of that. There are data for almost 20,000 books, along with their author information. I'm copying the first four rows, and going to put that in a spreadsheet so that we can look easily. So we have lot of dimensions here, starting with book ID, title, author, rating, description, and so on and so forth. And I've copied four books' information. And what we need to do is not take this entire CSV and dump in a single database table, because that is not a good design. At the very minimum in the context of this course, we want to split the author's table separate from the books table, because one book may have more than one author as a…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.