S
shanmukha.kovvuri
hey im currently creating a small library system for my college
project, and i need some help and advice.
My tables are;
* PK = Primary Key
tblBook
(PK)ISBN
Title
AuthorID
PublisherID
NumberOfCopies
CategoryName
PublicationYear
Picture
tblBookCopy
(PK)CopyID
ISBN
DatePurchased
ReplacementCost
Lending
tblBookLoan
(PK)LoanID
CopyID
MemberID
DateDueBack
tblMember
(PK)MemberID
Name
Surname
Sex
Address1
Address2
PostCode
TelNumber
i also have other tables, Author, Publisher, Category.
anyway, since ISBN is unique to each title of book, if i have multiple
copies of that book, each will have to be identitfied, im using
CopyID. For example NumberOfCopies of a book in tblBook is 5, how can
tblBookCopy be made to add 5 unique entries to of that Book, if you
understand wat i mean. also im new at this, but any help will be much
appreciated.
project, and i need some help and advice.
My tables are;
* PK = Primary Key
tblBook
(PK)ISBN
Title
AuthorID
PublisherID
NumberOfCopies
CategoryName
PublicationYear
Picture
tblBookCopy
(PK)CopyID
ISBN
DatePurchased
ReplacementCost
Lending
tblBookLoan
(PK)LoanID
CopyID
MemberID
DateDueBack
tblMember
(PK)MemberID
Name
Surname
Sex
Address1
Address2
PostCode
TelNumber
i also have other tables, Author, Publisher, Category.
anyway, since ISBN is unique to each title of book, if i have multiple
copies of that book, each will have to be identitfied, im using
CopyID. For example NumberOfCopies of a book in tblBook is 5, how can
tblBookCopy be made to add 5 unique entries to of that Book, if you
understand wat i mean. also im new at this, but any help will be much
appreciated.