Datasets and data relations in relation to sql

Hi Experts,
As a beginner I am developing my first application in visual basic. The data is stored in a sql database.

Normally different types of relations, triggers, etc are set up in the database. However when using datasets in visual basic, data is temporarily "disconnect" from the database. Are the relations, triggers, etc from the database in any way used by the datasets? Or do the same relations have to be set up in the dataset, or must the programmer just read and write data on every change to make sure the data does not compromise the relations in the database?

Up to now I have used the database as a simple storage medium for data and not set up any relation in the database. However this is a timely solution to make the learning curve not to steep. Already it is clear to see that relations between tables would skip a lot of programming that is now needed to keep data integrity.

Based on above what is the right approach? Do relations have to be set up in sql, in the dataset or both?

I know the question is kind of general, but I hope someone can give me an answer or link to point me in the right direction, MBStart Free Trial