BC160400549, Sql Server

BC160400549

create database bc160400549

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

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

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

create table FOODITEM(
itemID int primary key not null,
itemName varchar(50) 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,'07/15/2018', '05:09');

select * from EVENT;


run \| edit \| history \| help	0