Question: Have a textbook stored in an sqlite database. Create the database in a file called study.db It should have at least 3 tables in the

Have a textbook stored in an sqlite database.

Create the database in a file called study.db

It should have at least 3 tables in the file.

One is a book to study - you choose what book. It should have a main book called books

in books are fields i,r,t where i is a unique number (integer), r is a reference key varchar, and t is a line of text from the book

A second table should be list of topics in the books table

It should have i (integer), start (integer), and topic (varchar) and where(integer) the record from books where there is stuff pertaining to this topic in the books table

Finally a third table should be one called when

When should have i (integer), date (varchar), topic (varchar), time (varchar)

To keep a record of when the topic was studied

Submit the the database of the three tables and the sql code used to build it.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!