Create a databse for the below application using MySQL and upload the sql file t

Question

Create a databse for the below application using MySQL and upload the sql file that shows create and insert statements for the tables:

A small accounting firm wants a simple HR application that will help it to keep track of its employees, their positions, office locations, salary scales, and which company vehicles their employees drive.

The application must keep track of all the positions at the firm, the employees filling these positions, the offices for these positions which may have more than one employee, the salary scales for these positions, and the company vehicles assigned to these positions.

Explanation / Answer

Here I have created a table named EMP

which will contain Employee name, Employee ID, Employee Position, Employee Office location, Employee salary, Employee Vehicle.

The sql file will contain the below code.

create database EMPLOYEE;
use EMPLOYEE;
create table EMP(
EMP_NAME varchar(30),
EMP_ID int(5) AUTO_INCREMENT PRIMARY KEY,
EMP_POS varchar(30),
EMP_OFF_LOC varchar(40),
EMP_SAL INT(10),
EMP_VEHICLE varchar(30)
);
insert into emp values("James",0001,"CEO","Palo Alto",30000,"Mercedes");

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.