Thursday, September 27, 2012

Table Level VS Column Level Constraints

Table Level VS Column Level Constraints:
In this article we will differentiate between column level constraints and row level constraints.
Constraint is a way of enforcing rules in the database, and it maintains the integrity of the database.

Wednesday, September 12, 2012

SQL Server Database Creation

SQL Server Database Creation:
Database Planning:
1.       Storage.
Space needed to store your database the size of database determines where you can store it, and the growth of database will determine the size of storage you need to store data.

Information Security: Phishing

          Phishing is a way of attempting to acquire information (and sometimes, indirectly, money) such as usernames, passwords, and credit card details by masquerading as a trustworthy entity in an electronic communication.

Monday, September 3, 2012

Difference between Primary Key and Candidate Key

Difference between Primary Key and Candidate Key:
Primary key is a uniquely identifies each record in the relation, it cannot accept null values. The primary key may be one attribute or a composite of attributes, e.g.