Hello I hope someone can help me write an application that creates a database na

Question

Hello I hope someone can help me write an application that creates a database named Personnel. The database should have a table named Employee, with columns for employee ID, name, position, and hourly pay rate. The employee ID should be the primary key. Insert at least five sample rows of data into the Employee table. With No user input and the platform I will be using is JCreator.

Last answer to my question was not answered about my question it was about a bank account so i hope someone can really help me this time.

Explanation / Answer

Table creation

CREATE TABLE Employee

{

employee_ID int,

name varchar(200),

position varchar(200),

hourly_pay_rate int

);

insertion of values

//inserting values to different rows

INSERT INTO Employee (employee_ID,name,position,hourly_pay_rate)VALUES (1,a1,manager,1000);

INSERT INTO Employee (employee_ID,name,position,hourly_pay_rate)VALUES (2,a1,officer,800);

INSERT INTO Employee (employee_ID,name,position,hourly_pay_rate)VALUES (3,a1,clerk,500);

INSERT INTO Employee (employee_ID,name,position,hourly_pay_rate)VALUES (4,a1,senmanager,1500);

INSERT INTO Employee (employee_ID,name,position,hourly_pay_rate)VALUES (5,a1,divmanager,2000);

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

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