Untitled

 avatar
unknown
plain_text
3 years ago
665 B
4
Indexable
CREATE DATABASE CUS
create table Customer(
	cusID int identity (1,1) primary key,
	name varchar (50) not null,
	Age int not null check (Age>=18),
	Adress varchar (200) null,
	salary decimal (18,2) null
)
Insert into Customer(name,Age,Adress,salary)
values  ('Nahid', 21, 'Gulshan', 2000.00),
		('Jahid', 22, 'Mirpur', 2000.00),
		('Tonmoy', 21, 'Banani', 2000.00),
		('Jui', 20, 'Footpath', 2000.00),
		('Jannat', 24, 'Lalbagh', 2000.00),
		('Rudra', 27, 'Dhanmondi', 2000.00);
create table orders(
OrderId int identity (11,1) primary key,
CustomerID int not null foreign key references Customer(cusID),
Date date null,
Amoung money null

)
Editor is loading...