M
Marko
I've jut finished doing a query to show information about
students who loan books. However, each row of information
has been replicated four times. What have I done?
The query shows Student Name, Book Number, Loan Date,
Loan Due, Loan Returned, Days Late and Fine Amount.
my table relationships are
STUDENT LOAN INSTANCE BOOK
Student Name Student Name Book Number ISBN
Age Book Number ISBN Author
Class Loan Date Instance Number Genre
Loan Due Department
Loan Returned Age Group
Fine Publisher
Can anyone help.
students who loan books. However, each row of information
has been replicated four times. What have I done?
The query shows Student Name, Book Number, Loan Date,
Loan Due, Loan Returned, Days Late and Fine Amount.
my table relationships are
STUDENT LOAN INSTANCE BOOK
Student Name Student Name Book Number ISBN
Age Book Number ISBN Author
Class Loan Date Instance Number Genre
Loan Due Department
Loan Returned Age Group
Fine Publisher
Can anyone help.