Quote:out how to link the Books table and the Authors TableI am assuming that each Book ID, et al, is unique, so you would include that in every table and can then reference Book to Author(s) by the Author ID in the Book table. If an Author has written more than one book, there will be more than one Book entry, each with the same Author ID. Searching for the Author ID will give you a list of books by that Author. I have some canned SQLite code and will try to work up some examples this evening.
sqlite3 db and table design
| Messages In This Thread |
|
sqlite3 db and table design - by pythonNoob - May-18-2018, 07:16 PM
RE: sqlite3 db and table design - by woooee - May-18-2018, 08:17 PM
RE: sqlite3 db and table design - by woooee - May-19-2018, 03:20 AM
RE: sqlite3 db and table design - by pythonNoob - May-21-2018, 05:04 PM
RE: sqlite3 db and table design - by woooee - May-22-2018, 11:21 PM
|
| Possibly Related Threads… | |||||
| Thread | Author | Replies | Views | Last Post | |
|
Using SQLAlchemy, prevent SQLite3 table update by multiple program instances | Calab | 3 | 852 |
Aug-09-2023, 05:51 PM Last Post: Calab |
| Adding data to a table in SQLite3 | djwilson0495 | 2 | 3,143 |
Aug-15-2020, 02:48 PM Last Post: djwilson0495 |
|
| Creating a table in SQLite3 | djwilson0495 | 2 | 2,143 |
Aug-10-2020, 03:01 PM Last Post: djwilson0495 |
|
| sqlite3 table structure and db tables | pythonNoob | 7 | 5,050 |
May-16-2018, 02:19 PM Last Post: pythonNoob |
|
Users browsing this thread: 1 Guest(s)