bc160402152, Sql Server

bc160402152

create database bc160402152

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

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

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

create table FOODITEM(
itemID int primary key not null,
itemName varchar(45) not null,
description varchar(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 varchar(250) not null,
city varchar(250) not null,
capacity varchar(250) not null,
description varchar(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