Database structure and table relations for a Library

[lana]

Dear All,

A data model is suggested for a library and book application (attached file).

I got this from the site introduced here in this forum (Industry Data Model).

My question is about the tables named : Books_by_Author and Books_by_Category.

Books_by_Author is connected to tables Books and Authors. Data must be added to tables Books and Authors by separate forms. When this is done, how can we add data to table Books_by_Author to complete the connection and data?
Do we have to design separate form to add this data?

The same goes to Books_by_Category.

Any help will be appreciated.
Thanks

 

[Mihail]

Data must be added to tables Books and Authors by separate forms

Not quite.
Create a form frmBooks OR a form frmAuthors
AND
a form frmBooks_by_Author.

Lets say that you have frmBooks.
In this form embed the frmBooks_by_Author as a subform.
Now, you can add a book and, in the subform, the authors for THAT book.

This is the theory but, in practice, is a little bit more to do in order to hide the unnecessary controls/fields that will be showed in this forms.

 

[lana]

Thanks for the reply.

My question is about Books_by_Author, first of all do we really need this? We can add a field to the Books tables by the name of Author....

Secondly, in order to complete this table " Books_by_Author" we need to have a form to enter the required field data? Right?
As you can see in the structure, only two fields are in this table , Author_id and isbn. we need to enter these two in this table somehow.
Thanks

 

[Mihail]

My question is about Books_by_Author, first of all do we really need this?

YES.

We can add a field to the Books tables by the name of Author....

What about a book that have 5 authors ?

Secondly, in order to complete this table " Books_by_Author" we need to have a form to enter the required field data? Right?

YES. Read again my first post.

 

[lana]

I think I solved my own question.!!!!

I put two sub forms on the main form which is Books input data. One is for Author(s) and one is for category(ies). Record source of each sub form is a query built with two tables.
In this manner both tables will be filled with proper data.
Thanks