I am trying to create a schema for employees. So far Everything was working fine

Question

I am trying to create a schema for employees. So far Everything was working fine until i tried adding salary and it all went downhill from there.. Can anyone tell me what I am doing wrong?

create table employees (

eno         varchar(10) primary key,

  ename  varchar(30),

  zip         integer(5) references zipcodes,

  hire_date   date,

  function    varchar(100)

  Salary      varchar(10);

insert into employees values ('P5284100', 'John  Smith',95350, '2000-12-12', 'Boss', '$2,500');

insert into employees values ('P5284200', 'Jenifer thomson',95340, '2006-01-01','Purchasing clerk', '$11 per hour');

insert into employees values ('P5284300', 'Derick Bennett',95307, '2008-09-01', 'Accounts Payable', '$15 per hour');

Explanation / Answer

create table employees (

eno varchar(10) primary key,

ename varchar(30),

zip integer(5) references zipcodes,

hire_date date,

function varchar(100),

Salary varchar(10));

insert into employees values ('P5284100', 'John Smith',95350, '2000-12-12', 'Boss', '$2,500');

insert into employees values ('P5284200', 'Jenifer thomson',95340, '2006-01-01','Purchasing clerk', '$11 per hour');

insert into employees values ('P5284300', 'Derick Bennett',95307, '2008-09-01', 'Accounts Payable', '$15 per hour');

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

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