Hi guys,
I have been working on a database project which is about SQL queries. As I become new to SQL, i cannot manage to do the queries. Anyway here are the questions below;
(a) Search for a book by ISBN and display its availability for loans (i.e., display loan status of
all its copies).
(b) Make a reservation for a book (i.e., to record which book title is being reserved by which
user).
(c) Produce a list of loans to users (i.e., to display user name, user number, book title and bar
codes for those books on loan).
and the tables;
Book:
ISBN Number, Title, Publisher, Date of Publication, Availability.
Loan:
Loan Number, User Number, ISBN Number, Loan Date, Due Date
Reservation:
User Number, ISBN Number, Title, Publisher, Date of Publication
User:
User Number, Name, Surname, Address, Post Code, Telephone
IF YOU PLEASE HELP ME TO DO THESE QUERIES, I WIL BE MUCH APPRECIATED.
I have been working on a database project which is about SQL queries. As I become new to SQL, i cannot manage to do the queries. Anyway here are the questions below;
(a) Search for a book by ISBN and display its availability for loans (i.e., display loan status of
all its copies).
(b) Make a reservation for a book (i.e., to record which book title is being reserved by which
user).
(c) Produce a list of loans to users (i.e., to display user name, user number, book title and bar
codes for those books on loan).
and the tables;
Book:
ISBN Number, Title, Publisher, Date of Publication, Availability.
Loan:
Loan Number, User Number, ISBN Number, Loan Date, Due Date
Reservation:
User Number, ISBN Number, Title, Publisher, Date of Publication
User:
User Number, Name, Surname, Address, Post Code, Telephone
IF YOU PLEASE HELP ME TO DO THESE QUERIES, I WIL BE MUCH APPRECIATED.