M
Marko
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
Book Title
From studying my SQL view can you see what I need to do
now? Currently in the student table the key field is
student name, in the loan table I have a composite key
which is Student name and book number in instance the
primary key is Book Number and ISBN is the foreign key
and finally in Book ISBN is my primary key.
My query works ok [does what I want it to do but
replicates each entry five times why is this?
Can you help?
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
Book Title
From studying my SQL view can you see what I need to do
now? Currently in the student table the key field is
student name, in the loan table I have a composite key
which is Student name and book number in instance the
primary key is Book Number and ISBN is the foreign key
and finally in Book ISBN is my primary key.
My query works ok [does what I want it to do but
replicates each entry five times why is this?
Can you help?