Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Processing Fundamentals, Design, and Implementation

Authors: David M. Kroenke, David J. Auer

14th edition

133876705, 9781292107639, 1292107634, 978-0133876703

More Books

Students also viewed these Databases questions