This is database system concept. My question is that Populate the tables you cre

Question

This is database system concept.

My question is that Populate the tables you created for the previous question with data. Be careful about the order you populate the tables with data.

I do not understand and how to do it. I am using oracle anyway.

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
);

Explanation / Answer

You have to populate the data in the following order.

Make sure the order is correct as works table references employee and company. Similarly managers table references works and employee.

For inserting data you can use simple insert queries like:

insert into employee(employee_name, street, city) values ('Dipen', 'bhatstree', 'gandhinagarcity');

insert into employee(employee_name, street, city) values ('Manager1', 'bhatstree1', 'gandhinagarcity1');

insert into company(company_name, city) values ('DipenCompany', 'gandhinagarcompanycity');

insert into works(employee_name, company_name, salary) values ('Dipen','DipenCompany', 10000);

insert into works(employee_name, company_name, salary) values ('Manager1','DipenCompany', 20000);

insert into manangers(employee_name, mananger_name) values ('Dipen','Manager1');

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

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