Visual Basic .NET

In my previous tutorial I discuss on “How to Add Table to Your Existing Database”. Now, I will explain to you on how to create database relationships between one or more tables. Relationship is very important to prevent data inconsistency in your database. For example, you cannot add record in the related table without first adding a record in the primary table.

A relationship exists when two tables are related using a primary key and a foreign key.

In my previous tutorial I discuss on “How to Create Database in SQL Server 2005 Express Edition”. This time you will learn how to add a table in your “LibSys” database using SQL Server Management Studio.

Since LibSys database may contain several tables, I will only teach you to create at least one table and the rest will be done by executing a script.

In this tutorial you will learn how to create a Database in SQL Server 2005 Express Edition. The name of the database that we are going to create is “LibSys” which stands for Library System.

Note that I am using SQL Server Management Studio that is bundled with SQL Server 2008 R2. Regardless of version that you are using the environment still looks the same.

Please follow the steps below to create a database.

In this tutorial I will teach you on how to create a Windows Application using Visual Basic .NET 2008. For the sake of this tutorial I will be using Library System as the system model.

I came up with this idea in the hope to help beginner who wish to learn Visual Basic .NET the EASY WAY. I know there are a lot of tutorials out there but they focus on different things. Unlike this tutorial I will create an actual application which will guide you up to the end of this article.