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/12/2018', '08:34');
select * from EVENT;
by bc160401882, 2 years ago
create database bc160401882
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/12/2018', '08:34');
create database bc160401882
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/12/2018', '08:34');
select * from EVENT;
by bc160401882, 2 years agocreate database bc160401882
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/12/2018', '08:34');
select * from EVENT;
by bc160401882, 2 years agoPlease log in to post a comment.