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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started