Multi Branch Mall Management System
Hotel Reservation System in MS Access
Figaro Coffee Company
Online Enrollment And Grading System using MVC 3 (Razor)
Deifferent patterns
SQL PRIMARY KEY Constraint
Every table must be identified with a unique key or the Primary Key. Primary Key uniquely identifies each record in the table. It makes searching of record faster.
A Primary Key cannot contain a NULL values and must be unique in every record.
Different DBMS have different implementations to set the primary keys, so let’s see each of them below.
SQL PRIMARY KEY Syntax
Matrix Arithmetic ( addition ,multiply & subtraction)
SQL Create Database Statement
Besides creating the database from the DBMS software like Oracle, MyQL, Microsoft Access etc. We can also create database with the query language. It is as simple as writing a SELECT, INSERT, UPDATE, DELETE Statement.
Creating a database using query language is very useful if for example you deploy your application to a computer that doesn’t have a database yet.
We can create a new database with the following syntax
SQL Create Database Syntax