Database design help
Posted: Mon Oct 26, 2020 2:22 pm
Sorry if this seems simple, but I'm bouncing before I get into deep.
I am building a database through nuBuilder that will enable me to make notes, identify keyword on my research on the Bible. I am thinking the following.
There are three levels Book > Chapter > Verse. I want to be able to make notes on each level. I also want to access by Chapter or verse.
Thinking Home would be have a button for each level
Book would enable me to go to Book > Chapter > Verse.
Chapter would enable me to go to Chapter > Verse.
Verse would enable me to go to Verse.
Would I build a form for each level and use lookups to get the level of detail?
The data in stored in a table
bible_id
bib_bible_books_id
b_name
b_index
b_book
b_chapter
b_verse
b_nasb
b_nkjv
b_esv
b_isv
b_amp
b_niv
Also have a keyword table and notes table.
Thanks Heaps
Paul
I am building a database through nuBuilder that will enable me to make notes, identify keyword on my research on the Bible. I am thinking the following.
There are three levels Book > Chapter > Verse. I want to be able to make notes on each level. I also want to access by Chapter or verse.
Thinking Home would be have a button for each level
Book would enable me to go to Book > Chapter > Verse.
Chapter would enable me to go to Chapter > Verse.
Verse would enable me to go to Verse.
Would I build a form for each level and use lookups to get the level of detail?
The data in stored in a table
bible_id
bib_bible_books_id
b_name
b_index
b_book
b_chapter
b_verse
b_nasb
b_nkjv
b_esv
b_isv
b_amp
b_niv
Also have a keyword table and notes table.
Thanks Heaps
Paul