Exercise 1

Create a table for storing books in your book list. The table should be able to contain the book's title, the author, and the date of publication as a string.

Exercise 2

Create a table for storing information about a person that writes book reviews. For each person, store their name, their location as a string, and how many book reviews they have written.

Exercise 3

Create a table for storing temperature readings of a thermometer inside a greenhouse. Each reading should contain the temperature as well as the date and time of the reading, as a string.

Solutions

The solution for exercise 1:

CREATE TABLE books (title TEXT, author TEXT, publication_date TEXT);

The solution for exercise 2:

CREATE TABLE book_reviewers (name TEXT, location TEXT, review_count INTEGER);

The solution for exercise 3:

CREATE TABLE temperature_readings (temperature REAL, date_time TEXT);