General Knowledge question about Databse structure and Logic

M

As you all know, I am completely new to this wonderful program. First, is there anyplace you know of where I can get a general overview of how to go about data modeling and the logic behind designing a database? I saw that one of the templates has a sub-table for example, which led me to think of why one would need a sub-table instead of just another table and having that be refered to from a table, my knowledge is that limited and i need to learn! My emails to Ninox about what I want to do have gone un-answered. I have a specific project I am working on and I have an Excel spreadsheet which mostly does what I want it to do, but doing it as a database would be, I think, more elegant and useful, considering I can change views on the go and see information in different relationships which is not as easy in Excel. Thanks in advance.

A

Hi Marek,

There are some good videos from these guys ww.nioxus.com

This is the first one:

https://www.youtube.com/watch?v=T5EJL7u4wlk

 

There are 3 in the series on structure I think but lots more on other things.

 

Good Luck!!

M

Thanks! I've looked at them, but they don't really deal with the idea of, for example, why sub-tables as opposed to linked tables. I'm kind of overthinking this perhaps. I'll continue looking.

 

Ninox Profile

I think, what you are looking for is named "Datebase normalization" and 1 Normal Form, 2NF, 3NF
Try to find these terms, this is how a database should be structured.

Best regards,
Peter

M

Thanks Peter!

Reply