Define constraints? Three types of constraints: 1.domain 2.entity 3.referential Domain has the following constraints types: 1.not null 2.check 3.default Entity has the following constraints types 1.primary key 2.unique key Referential has the following constraints types 1.foreign key
create table Dept ( Did int not null primary key DeptName varchar(7) ) create table Employee ( Empid int not null primary key, ,Ename varchar(20) unique not null ,EmpTax int default '1000' ,EmpJoindate date not null ,EmpSalary money check(EmpSalary>0) ,Deptid int Foreign key references Dept(Deptid) )
Cleaner Graphics
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.
Wider Scope
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.
Tablet Ready
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi.