employee ( employee name , street , city ) works ( employee name , company name

Question

employee (employee name, street, city)
works (employee name, company name, salary)

company (company name, city)

manages (employee name, manager name)

Using Oracle. I have created this SQL schema for the figure above:

create table employee

(

  employee_name varchar(20)

  street   char(30)

  city   varchar(20)

  primary key (employee_name)

);

create table company

(

  company_name varchar(20)

  city   varchar(20)

  primary key (company_name)

);

create table works

(

  employee_name varchar(20)

  company_name varchar(20)

  salary   numeric(8, 3)

  primary key (employee_name)

  foreign key (employee_name) references employee

  foreign key (company_name) references company

);

create table manangers

(

  employee_name varchar(20)

  mananger_name varchar(20)

  primary key (employee_name)

  foreign key (employee_name, mananger_name) references works and employee

);

I need to Populate the tables created for this schema with data.

Explanation / Answer

To populate the tables use the following insert queries :

You can use any Names instead of the names I have used.

INSERT INTO employee (employee_name, street, city) VALUES ("employee1", "street1", "city1");

INSERT INTO company (company_name, city) VALUES("company1"," city1");

INSERT INTO works (employee_name, company_name, salary) VALUES ("employee1","company1",95000);

INSERT INTO managers (employee_name, manager_name) VALUES("employee1","employee1");

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

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