MC170402209, Sql Server

Language: Layout:

Create database MC170402209;
CREATE TABLE Coustomer(
    
    custID smallint constraint cID primary key,
    cNAME Varchar(25),
    cADDRESS Text,
    cEMAIL Text,
    );
    
    SELECT*FROM Coustomer
    
    
    
CREATE TABLE Category(
    
    catID smallint constraint catID primary key,
    catNAME Varchar(25),
    initalRate int,
    );
    
    SELECT*FROM Category
    
    
    
CREATE TABLE Services(
    
    serID smallint constraint serID primary key,
    serTitle Varchar(50),
    setDescription Varchar(50),
    serCharges int,
    );
    
    SELECT*FROM Services
    
    
    
CREATE TABLE Food_item(
    
    itemID smallint constraint itemID primary key,
    itemName  Varchar(25),
    itemDescription Varchar(50),
    );
    
    SELECT*FROM Food_item
    
    
    
CREATE TABLE Menu(

menuID smallint constraint menuID primary key,
    no.Of.serving  int,
    Quantity       int,
    no.Ofitems     int,
    );
    
    SELECT*FROM Menu
    
    
CREATE TABLE Venue(
    
    location  Varchar(50),
    city      Varchar(50),
    capacity  Varchar(50),
    description  Varchar(50),
    );
    
    SELECT*FROM Venue
    
    
    
CREATE TABLE Event(
    
    eID smallint constraint eID primary key,
    Date datetime,
    timeSlot time,
    );
    
    SELECT*FROM Event
    
    INSERT INTO Event 
    VALUES('001','16.07.2018','12:00')
    
    SELECT*FROM Event

View schema
Absolute service time: 0,14 sec