Help In Book Lending Library System

[NotesAndSoft]

Dear Sir ,
I need help in my Books Lending Library System,
all i want is to create Checkin checkout system with transaction history ,
if i checkout a book , its one copy should be checked out and i should be able to check out remaining copies to other students
and if i am not mistaken its called inventory system
i can send you my project file if you don't understand me

ms access version: 2007

 

[NotesAndSoft]

No , its not model that i want,
And if you can help me , give me your Email , i am going to send you my project

 

[jdraw]

Please post a jpg (you'll probably have to zip it because of your post count) of your
tables and relationships (relationships window).
Without seeing your relationships, we can not give you a focused response.
Readers really want to see what you have done; understand what you are trying to do before getting into the nitty-gritty.

 

[NotesAndSoft]

Here is my Project you can download it from here
drive.google[.]com/file/d/0B6zopnQVtg_nam1mejFWMU1SSUE/edit?usp=sharing

just replace [.] by .

 

[jdraw]

Please review the data model at
http://www.databaseanswers.org/data_models/libraries_and_books/

You have a design problem.
When you post a database with a password, you might consider informing the reader.

 

[NotesAndSoft]

Oops ! Sorry Forgot that
username: PISJ (Capital)
PasswordISJ (Capital)

 

[NotesAndSoft]

Please help, Can't anyone even try helping

 

[jdraw]

Have you looked at the data model suggested in post#6?
If so, what comments do you have?
Have you created a list of business rules/facts that your database must support?
Do you have test data and test scenarios? Have you tried your test scenarios against your data model? What result?

 

[NotesAndSoft]

Yes i did (even before you suggested) , and my Database is bit more complicated than this ,
have you seen my datebase , if not please download and see