Elena-Tests, Sql Server

Language: Layout:

-- Create the first table in Sql Server

CREATE TABLE PRODUCTS( 
 
Product_id int, 
Product_Name varchar(50), 
Product_Description varchar(2000), 
Product_Category varchar(40), 
Price_List int,
Minimum_Price int
);

INSERT INTO Products (Product_id , Product_Name , Product_Description , Product_Category , Price_List , Minimum_Price )
VALUES (1, 'Tricou', 'Marca Nike ', 'Imbracaminte', 4406, 2900);

INSERT INTO Products (Product_id , Product_Name , Product_Description , Product_Category , Price_List , Minimum_Price )
VALUES (2, 'Bluza', 'Marca Nike ', 'Imbracaminte', 4106, 2900);

INSERT INTO Products (Product_id , Product_Name , Product_Description , Product_Category , Price_List , Minimum_Price )
VALUES (3, 'Rochie', 'Marca Nike ', 'Imbracaminte', 4096, 2900);

INSERT INTO Products (Product_id , Product_Name , Product_Description , Product_Category , Price_List , Minimum_Price )
VALUES (4, 'Fusta', 'Marca Nike ', 'Imbracaminte', 4076, 2200);

INSERT INTO Products (Product_id , Product_Name , Product_Description , Product_Category , Price_List , Minimum_Price )
VALUES (5, 'Pantaloni', 'Marca Nike ', 'Imbracaminte', 4406, 2600);

INSERT INTO Products (Product_id , Product_Name , Product_Description , Product_Category , Price_List , Minimum_Price )
VALUES (6, 'Blugi', 'Marca Nike ', 'Imbracaminte', 4906, 2901);

INSERT INTO Products (Product_id , Product_Name , Product_Description , Product_Category , Price_List , Minimum_Price )
VALUES (7, 'Palarie', 'Marca Adidas', 'Imbracaminte', 4006, 2900);

INSERT INTO Products (Product_id , Product_Name , Product_Description , Product_Category , Price_List , Minimum_Price )
VALUES (8, 'Curea', 'Marca Nike ', 'Imbracaminte', 4002, 2900);

INSERT INTO Products (Product_id , Product_Name , Product_Description , Product_Category , Price_List , Minimum_Price )
VALUES (9, 'Fular', 'Marca Adidas', 'Imbracaminte', 4076, 2900);

INSERT INTO Products (Product_id , Product_Name , Product_Description , Product_Category , Price_List , Minimum_Price )
VALUES (10, 'Palarie', 'Marca Adidas', 'Imbracaminte', 4606, 2902);

-- Create CUSTOMERS second tablesssssssssssssssssssssssssssssssssss

/*
comentariu pe mai multe linii - linia 1

comentariu pe mai multe linii - linia 2

comentariu pe mai multe linii - linia 3

-- Create CUSTOMERS second table

CREATE TABLE CUSTOMERS( 
 
Customer_id int, 
Customer_Firstname varchar(20), 
Customer_Lastname varchar(20), 
CustomerPhone varchar(20), 
Credit_Limit int,
Customer_email varchar(30),
Birthday DATE,
Status varchar(20),
Sex varchar(20),
Income_level varchar(20)
);

-- Create EMPLOYEES third table

CREATE TABLE EMPLOYEES( 
 
Employee_id int,
Employee_Firstname varchar(25), 
Employee_Lastname varchar(25), 
Employee_Email varchar(25),
Employee_Phone varchar(20), 
Hire_Date DATE,
Id_Function int,
Salary int,
Comission int,
Id_manager int,
Id_department int
);

View schema