Database design help

Questions related to using nuBuilder Forte.

Database design help

Postby vanman » Mon Oct 26, 2020 10:52 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
vanman
 
Posts: 22
Joined: Fri Mar 02, 2018 7:39 am

Re: Database design help

Postby kev1n » Mon Oct 26, 2020 11:45 pm

Hi Paul,

How about using three lookup objects (Book > Chapter > Verse)

You can use nuSetProperty() to set a hash cookie that filters the SQL.
If you like nuBuilder, please leave a review on SourceForge

nuBuilder Code Library (82)
Installation Guides
Updating nuBuilder

Join Discord to talk about nuBuilder!
kev1n
 
Posts: 1084
Joined: Mon Oct 15, 2018 2:13 am

Re: Database design help

Postby vanman » Tue Oct 27, 2020 12:14 am

Hi Kevin

Thanks
Will look into this seems less complex

I forgot about Hash Cookies


Paul
vanman
 
Posts: 22
Joined: Fri Mar 02, 2018 7:39 am

Re: Database design help

Postby admin » Thu Oct 29, 2020 9:28 am

Paul,

Here's a database you can muck around with...

vanman.zip
(113.83 KiB) Downloaded 18 times


Here's the database structure...

bible.PNG
bible.PNG (123.43 KiB) Viewed 134 times


Here is a Report to explain how you can use it...

report.png
report.png (69.55 KiB) Viewed 134 times



Steven
admin
Site Admin
 
Posts: 3402
Joined: Mon Jun 15, 2009 9:53 am

Re: Database design help

Postby vanman » Thu Oct 29, 2020 7:03 pm

Thanks Heaps Steven

Most Helpful
vanman
 
Posts: 22
Joined: Fri Mar 02, 2018 7:39 am


Return to General



cron