Database System : SQL Queries

Running head: DATABASE SYSTEM
DATABASE SYSTEM
Name of the Student:
Name of the University:
Author note

1
DATABASE SYSTEM
Table of Contents
Task 1...............................................................................................................................................3
Task 2...............................................................................................................................................5
Task 3...............................................................................................................................................6
Task 4...............................................................................................................................................6
Task 5...............................................................................................................................................7
Task 6...............................................................................................................................................7
Task 7...............................................................................................................................................7
Task 8...............................................................................................................................................8
Task 9...............................................................................................................................................8
Task 10.............................................................................................................................................8
Task 11.............................................................................................................................................8
Task 12.............................................................................................................................................8
Task 13.............................................................................................................................................9
Task 14.............................................................................................................................................9
Task 15.............................................................................................................................................9
Task 16.............................................................................................................................................9
Task 17...........................................................................................................................................10
Task 18...........................................................................................................................................10
Task 19...........................................................................................................................................10

2
DATABASE SYSTEM
Task 20...........................................................................................................................................10
Task 21...........................................................................................................................................11
The is 22........................................................................................................................................11
Task 23...........................................................................................................................................11
Task 24...........................................................................................................................................11
Overall experience.........................................................................................................................12
Bibliography..................................................................................................................................13

3
DATABASE SYSTEM
Task 1
In order to develop the database that I have used SQL queries. In order to develop the
SQL, query I have prepared the database using the ERD table so that it becomes easy to store the
data. In order to link all the data with the developed table it is important to manage and store data
properly. Firstly, the department table for the ERD diagram has been developed so that it
becomes easy to link it with the employee table. The following queries were used for the
development of the database:
CREATE TABLE `department` (
`Department_ID` int(11) NOT NULL,
`DeptName` varchar(30) NOT NULL,
`DeptLocation` varchar(20) NOT NULL,
`DeptFloor` varchar(30) NOT NULL
);
CREATE TABLE `employee` (
`Employee_ID` int(11) NOT NULL,
`EmpName` varchar(25) NOT NULL,
`ManagerID` int(11) NOT NULL,
`DateOfHire` date NOT NULL,