Untitled

CREATE DATABASE company;

USE company;

CREATE TABLE EmployeeInfo_tbl(
                             EmpID INT PRIMARY KEY,
							 EmpFname VARCHAR(20),
							 EmpLname VARCHAR(20),
							 Department VARCHAR(20),
							 Project VARCHAR(2),
							 Addresses VARCHAR(30),
							 DOB DATE,
							 Gender VARCHAR (2)
							 
);

INSERT INTO EmployeeInfo_tbl(EmpID, EmpFname, EmpLname, Department, Project,  Addresses, DOB, Gender) VALUES
           (1, 'Sanjay' , 'Mehra', 'HR', 'p1', 'Hyderabad(HYD)','1976-01-12','M'),
           (2, 'Ananya' , 'Mishra', 'Admin', 'p2', 'Delhi(DEL) ','1968-02-05','F'),
           (3, ' Rohan ' , 'Diwan', 'Account', 'p3', 'Mumbai(BOM) ','1980-01-01','M'),
           (4, 'Sonia' , 'Kulkarni', 'HR', 'p1', 'Hyderabad(HYD)','1992-02-05','F'),
           (5, 'Ankit' , 'Kapoor', 'Admin', 'p2', 'Delhi(DEL)','1994-03-07','M');

SELECT*FROM EmployeeInfo_tbl;

CREATE TABLE EmployeePosition_tbl(
                           EmpId INT,
						   EmpPosition VARCHAR(20),
						   DateOfJoining DATE,
						   Salary VARCHAR(20)
						   FOREIGN KEY (EmpId) REFERENCES EmployeeInfo_tbl(EmpId)

);

INSERT INTO EmployeePosition_tbl(EmpId,EmpPosition,DateOfJoining,Salary) VALUES
                                (1,' Manager','2022-01-05',500000),
								(2,'Executive', '2022-02-05',75000),
								(3,'Manager', '2022-01-05',90000),
								(1,'Lead ', '2022-02-05',85000),
								(2,'Executive', '2022-01-05',300000);


SELECT*FROM EmployeePosition_tbl;


SELECT UPPER(EmpFname) AS EmpName
FROM EmployeeInfo_tbl;