bc160402152, Sql Server

bc160402152

create database bc160402152

create table CUSTOMER(
custID int primary key not null,
Name nvarchar(45) not null,
address nvarchar(45) not null,
email nvarchar(45) not null
);

create table CATEGORY(
catID int primary key not null,
catName nvarchar(45),
intialRate float(45)
);

create table SERVICES(
serID int primary key not null,
serTitle nvarchar(45) not null,
serDescription nvarchar(max) not null,
serCharges float(45) not null
);

create table FOODITEM(
itemID int primary key not null,
itemName nvarchar(45) not null,
description nvarchar(max) not null,
);

create table MENU(
menuId int primary key not null,
noOfserving int not null,
Quantity int not null,
noOfItems int not null,
);

create table VENUE(
location nvarchar(250) not null,
city nvarchar(250) not null,
capacity nvarchar(250) not null,
description nvarchar(250) not null
);

create table EVENT(
eId int primary key not null,
Date date not null,
timeSlot time not null
);

insert into EVENT values(1,'7/14/2018', '1:45');
select * from EVENT;


run \| edit \| history \| help	0