Reply: SQL View - Library Database

  • Thread starter Thread starter Marko
  • Start date Start date
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?
 
Back
Top