Back to course home
0% completed
Vote For New Content
3. Library Book Checkout Percentage (Easy)
Problem Statement
Table: Patrons
Each row in this table represents an individual library patron, detailing their unique ID and name.
+-------------+---------+
| Column Name | Type |
+-------------+---------+
| patron_id | int |
| patron_name | varchar |
+-------------+---------+
patron_id is the primary key for this table.
Each row contains the name and the ID of a library patron.
Table: Checkouts
This table tracks the checkout records of books by patrons, including the book ID and the patron ID who checked out the book.
+-----------+----------+
.....
.....
.....
Like the course? Get enrolled and start learning!
Table of Contents
Contents are not accessible
Contents are not accessible
Contents are not accessible
Contents are not accessible
Contents are not accessible