Rickard.T.SQL.Project.Work.Code

DROP TABLE Employee;
DROP TABLE Department;

CREATE TABLE Department
(
	Id INT PRIMARY KEY IDENTITY (0,1),
	Name NVARCHAR(50) NOT NULL
)

INSERT INTO Department (Name) VALUES ('IT')

INSERT INTO Department (Name) VALUES ('Marketing')

INSERT INTO Department (Name) VALUES ('Sales')

INSERT INTO Department (Name) VALUES ('Inventory')

INSERT INTO Department (Name) VALUES ('Customer Services')

INSERT INTO Department (Name) VALUES ('Insurance')

INSERT INTO Department (Name) VALUES ('Human Resources')

INSERT INTO Department (Name) VALUES ('Management')

INSERT INTO Department (Name) VALUES ('Financial')

INSERT INTO Department (Name) VALUES ('R&D')

CREATE TABLE Employee
(
	EmployeeId INT PRIMARY KEY IDENTITY (1,1),
	Name NVARCHAR(100) NOT NULL,
	Email NVARCHAR(100) NOT NULL,
	Salary INT NOT NULL,
	DateOfBirth DATETIME NOT NULL,
	OnParentalLeave BIT NOT NULL,
	DepartmentId INT FOREIGN KEY REFERENCES Department(Id) NOT NULL,
)

INSERT INTO Employee (Name, Email, Salary, DateOfBirth, OnParentalLeave, DepartmentId)
VALUES ('Rickard Kamel', 'Rickardkamel@gmail.com', 38000, '1992-01-27', 'False', 0)

INSERT INTO Employee (Name, Email, Salary, DateOfBirth, OnParentalLeave, DepartmentId)
VALUES ('Jason Valentine', 'Jason.Valentine@gmail.com', 39000, '1991-04-24', 'True', 1)

INSERT INTO Employee (Name, Email, Salary, DateOfBirth, OnParentalLeave, DepartmentId)
VALUES ('Johan Sundin', 'JohanSundin@hotmail.com', 21000, '1995-11-07', 'False', 2)

INSERT INTO Employee (Name, Email, Salary, DateOfBirth, OnParentalLeave, DepartmentId)
VALUES ('Filip Helander', 'Fille333@hotmail.se', 21400, '1994-05-20', 'False', 3)

INSERT INTO Employee (Name, Email, Salary, DateOfBirth, OnParentalLeave, DepartmentId)
VALUES ('Anders Vimefall', 'Andersvimefall@sogeti.com', 55000, '1988-02-03', 'False', 4)

INSERT INTO Employee (Name, Email, Salary, DateOfBirth, OnParentalLeave, DepartmentId)
VALUES ('Johanna Carlsson', 'Johanna.Carlsson32@hotmail.se', 20000, '1992-04-29', 'False', 5)

INSERT INTO Employee (Name, Email, Salary, DateOfBirth, OnParentalLeave, DepartmentId)
VALUES ('Patrik Johansson', 'Patteputt@gmail.com', 23400, '1993-12-31', 'False', 6)

INSERT INTO Employee (Name, Email, Salary, DateOfBirth, OnParentalLeave, DepartmentId)
VALUES ('Jonas Petersson', 'Peterson.Johan@gmail.com', 29900, '1989-09-23', 'False', 7)

INSERT INTO Employee (Name, Email, Salary, DateOfBirth, OnParentalLeave, DepartmentId)
VALUES ('Oskar Nilsson', 'Nille.osk@gmail.com', 27500, '1984-02-22', 'True', 8)

INSERT INTO Employee (Name, Email, Salary, DateOfBirth, OnParentalLeave, DepartmentId)
VALUES ('Berit Ohlsson', 'Berit4932@gmail.com', 19000, '1978-07-18', 'True', 9)

SELECT * FROM Department

SELECT * FROM Employee

SELECT Employee.Name, Department.Name
FROM Employee JOIN Department ON Employee.EmployeeId = Department.Id