Sharkey The Frog
New member
- Local time
- Today, 14:00
- Joined
- Jul 24, 2013
- Messages
- 5
Hey,
I was given a project to complete a library database and I have hit a snag :banghead:
So hear are my issues:
1)I need to automate lending and borrowing of books
2)I need to display a list of book collection grouped by subject category
3)Display a report of the Most borrowed and least borrowed books
4)Display overdue report of people who have not returned books and how much in terms of fines they owe in Library
*Fines increase in 30$ per day
*Person should not borrow more than 3 books
*Borrowing period is 2 weeks
QUERIES must be used for criteria
Please reply by 0400Hrs GMT
P.S. If you could physically update my database I would appreciate that even more cause I need it by 0430 GMT
Thanks.
I was given a project to complete a library database and I have hit a snag :banghead:
So hear are my issues:
1)I need to automate lending and borrowing of books
2)I need to display a list of book collection grouped by subject category
3)Display a report of the Most borrowed and least borrowed books
4)Display overdue report of people who have not returned books and how much in terms of fines they owe in Library
*Fines increase in 30$ per day
*Person should not borrow more than 3 books
*Borrowing period is 2 weeks
QUERIES must be used for criteria
Please reply by 0400Hrs GMT
P.S. If you could physically update my database I would appreciate that even more cause I need it by 0430 GMT

Thanks.
Attachments
Last edited: