Untitled
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...