Experiment No:3
Aim: To implement Constraints
Primary Key Constraint
Program:
SQL>Create table book (bookid number(4) primary key, bookname
varchar(20) not null ,authorname varchar(20), price number(8));
Output:
Table Created.
SQL>select *from book;
Output:
Foreign Key Constraint
Program:
SQL>Create table publisher(pubid number(4) primary key, pubname
varchar(20) not null ,bookid number(4),foreign key(bookid)references
book);
Output:
Table Created.
SQL>select *from publisher;
Output:
Check Constraint
Program:
SQL>Create table student (studentid number(4), studentname varchar(20),
age number(3),sex char(10),batch varchar(25) check(batch
in(‘science’,’commerce’)),total number(4));
Output:
