so I am trying to design a relational database and I think I am on the right track, but I am a little confused as to how I will actually update the data...
Normally I build a flat file table and use a web form to add/update/delete data, however, I am trying to build a larger database and this is no longer practical...
This is still not too complex, I think I can accomplish what I want with three tables...
Here is what I have so far:
- poem-ID - pk
- Author-ID - fk
- Book-ID - fk
- Author-ID - pk
- Book-ID - pk
Obviously I want to create a database containing poems. On the website the user can read the poem. I want them to be able to search by Poem, Author, or Book.
So if this is the proper database design how do I actually input the data using only 1 form?
If this is not correct can someone help me design the tables better and instruct me on how to make this updateable using only 1 form?
Any input or help is really appreciated!