logo

Data Modelling & Database Design | Assignment

Create tables for employees, departments, and salary levels. Insert records into these tables. Write queries to perform various tasks such as increasing salary, finding employees with minimum and maximum salary, displaying employees who joined after a certain year, displaying employees within a salary range, and updating salary for a specific employee.

9 Pages842 Words22 Views
   

Added on  2022-09-07

Data Modelling & Database Design | Assignment

Create tables for employees, departments, and salary levels. Insert records into these tables. Write queries to perform various tasks such as increasing salary, finding employees with minimum and maximum salary, displaying employees who joined after a certain year, displaying employees within a salary range, and updating salary for a specific employee.

   Added on 2022-09-07

ShareRelated Documents
Running head: Data Modelling & Database Design
DATA MODELLING & DATABASE DESIGN
Name of the Student
Name of the University
Author Note
Data Modelling & Database Design | Assignment_1
DATA MODELLING & DATABASE DESIGN
1
Task 1:
Department Table:
CREATE TABLE department (
Department_id int(11) NOT NULL,
Deptname varchar(30) NOT NULL,
DeptLocation varchar(20) NOT NULL,
DeptFloor varchar(20) NOT NULL,
PRIMARY KEY (Department_id)
);
Employee Table:
CREATE TABLE employee(
employee_id int(11) NOT NULL,
Empname varchar(25) NOT NULL,
Managerid int(11) NOT NULL,
Data Modelling & Database Design | Assignment_2
DATA MODELLING & DATABASE DESIGN
2
Dateofhire date NOT NULL,
Jobname varchar(15) NOT NULL,
Salary decimal(10,2) NOT NULL,
Department_id int(11) NOT NULL,
DOB date NOT NULL,
Address varchar(30) NOT NULL,
PRIMARY KEY (employee_id),
FOREIGN KEY (Department_id) REFERENCES Department(Department_id));
Salary Table:
CREATE TABLE salary(
salary_level int(11) NOT NULL,
Data Modelling & Database Design | Assignment_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Database Design in DBMS Tutorial: Learn Data Modeling
|17
|1795
|26

Database Design and SQL
|9
|1255
|102

Task 1 CREATE TABLE EMPDB
|7
|1224
|62

Database Design and Development Case | Assignment 1
|13
|2159
|29

Database Modelling Assignment | Task
|11
|1429
|21

Assignment on Data Modelling & Database Design
|11
|2081
|24