MC170402209, Sql Server

Language: Layout:

CREATE DATABASE MC170402209

CREATE TABLE Customer
(
custID int primary key not null,
custName varchar(255) not null,
custAddress text not null,
Email text not null,
);
CREATE TABLE Catagory
(
catID int primary key not null,
custName varchar(255) not null,
InitailRate int not null,
);
CREATE TABLE S_ervices
(
serID int primary key not null,
serTitle varchar(255) not null,
serDescription varchar(255) not null,
serCharges int not null,
);
CREATE TABLE Food_Item
(
ItemID int primary key not null,
ItemName varchar (255) not null,
ItemDescription varchar(255) not null,
);
CREATE TABLE Menu
(
MenuID int primary key not null,
no_of_servings int not null,
quantity int not null,
no_of_items int not null,
);
CREATE TABLE Venue
(
venueID int primary key not null,
V_location varchar (255) not null,
city varchar (255) not null,
capacity int not null,
V_description varchar (255) not null
);
CREATE TABLE E_vent
(
eID int primary key not null,
eDATE date not null,
TimeSlot time not null,
);
insert into Venue ( venueID, V_location, city, capacity, V_description)
values ( '002', 'multan', 'multan', '120', 'not available currently')
select * from Venue;

View schema
Absolute service time: 0,17 sec