mc170403050, Sql Server

mc170403050

create database mc170403050

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

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

create table SERVICES(
serID int primary key not null,
serTitle nvarchar(50) not null,
serDescription nvarchar(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 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,'07/12/2018', '08:34');

select * from EVENT;


run \| edit \| history \| help	0