All books that are checked out are due back in two weeks, with no exceptions. The late fee is 50 cents per day. The librarian would like to have a query that generates an overdue book list each day so she can telephone the miscreants.
I got a solution for this question but it answered a different section. Could I please have a My SQL eer diagram that sets up the following queries.
All books that are checked out are due back in two weeks, with no exceptions. The late fee is 50 cents per day. The librarian would like to have a query that generates an overdue book list each day so she can telephone the miscreants.
The library would like a query to search for a book by its title and see if it is currently checked out. Sometimes members can’t remember the full name of the book so the query needs to be able to search by a part of the title.
The library would like a query that can show them the Top 10 most popular books checked out over a particular date range.
The library would like to know the most popular day of the week for library members to visit the library and check out books.
The library would like to know which book categories are the most popular among members.
Step by step
Solved in 2 steps with 1 images
This doesn't answer the question I asked. This is for a different section.
I got a solution for this question but it answered a different section. Could I please have a My SQL eer diagram that sets up the following queries.
All books that are checked out are due back in two weeks, with no exceptions. The late fee is 50 cents per day. The librarian would like to have a query that generates an overdue book list each day so she can telephone the miscreants.
The library would like a query to search for a book by its title and see if it is currently checked out. Sometimes members can’t remember the full name of the book so the query needs to be able to search by a part of the title.
The library would like a query that can show them the Top 10 most popular books checked out over a particular date range.
The library would like to know the most popular day of the week for library members to visit the library and check out books.
The library would like to know which book categories are the most popular among members.