Archive for the ‘Databases’ Category

NORMALIZATION OF DATABASE TABLES

Creating a good database requires a good database design plus a good database structure. If the database contains a good table structures then the database will work well. A good database should avoid data redundancy or data anomalies which can be prevented through a well-defined table structures. The process is called normalization. Table is the […]

read more

INSERT, DELETE, UPDATE AND SELECT Data in MS-Access with VB 2008

The video contains tutorial on how to create/code the INSERT, ADD, EDIT and DELETE commands in VB 2008. This video is courtesy of youtube.

read more

Creating Login Form using VB.NET 2008 and MySQL Database

The video helps you in connecting MySQL database to your VB.Net. Courtesy of youtube

read more

Working With Databases in VB 2005

This is a video presentation in creating databases in Visual Basic 2005 (Courtesy of youtube).

read more

Relational Model

The relational database model was first introduced by E.F. Codd of IBM Research in 1970 in a classic paper, and attracted immediate attention due to its simplicity and foundation. The model uses tables as its basic building blocks. A table in the relational database model is also called relation and is made up of named […]

read more

SQL JOINS

SQL joins are used to query data from two or more tables, based on a relationship between certain columns in these tables. The JOIN keyword is used in an SQL statement to query data from two or more tables, based on a relationship between certain columns in these tables. To read more click here.

read more

How to Add Primary Key?

A primary key is used to uniquely identify each row in a table. Primary keys can be specified either when the table is created (using CREATE TABLE) or by changing the existing table structure (using ALTER TABLE). CREATING TABLE WITH PRIMARY KEY SYNTAX: CREATE TABLE table_name(field_name datatype(index),…,field_nameN datatype(index),PRIMARY KEY(field_name_primary_key)); Say for example, you are going […]

read more

How to Create a Foreign Key?

A foreign key is a field (or fields) that points to the primary key of another table. The purpose of the foreign key is to ensure referential integrity of the data. In other words, only values that are supposed to appear in the database are permitted. For example, say we have two tables, a CUSTOMER […]

read more