Design Database to Store Book Related Information

User Story

• As a: developer,
• I want: a description of the information stored about all books in the database
• so that: I know what information I can use for the frontend and the machine learning backend.

Functional Requirements

• Short document outlining each column in a SQL database , example
  • id INT -- this is a unique id for EACH book
  • link_amazon TEXT --
  • ratings .....
• Put as many columns as possible, more data is better than less
• Only scrap 1 website
• Must use latex (use pdflatex to compile)
  • It is suggested that MikTex and TexStudio be installed on Windows machines
• Use paragraphs, no fancy graphics needed
• Store in documents/database-description/database-description.tex

Description

Database design is very important early on, as it allows developers to work on collecting data and other developers can continue develop while using the assumption that more data will be added to the database. Having a good database design early on can save a lot of time, especially because refactoring a database can be an expensive operation and might require changes to the source code as well.