1. Engineering
  2. Computer Science
  3. can i get help with this sql question please can...

Question: can i get help with this sql question please can...

Question details

Part 2 (15 marks) Create a relation called Dependent that represents the dependence between entities. The table should have two attributes called entity and dependent, where entity is the primary key of the relation and dependent is a foreign key that references entity. Then insert three tuples representing the following information into this table: El is dependent on E2 E2 is dependent on E3 E3 is dependent on E1 1. 2. 3. Note that this problem is similar to chicken-egg problem but only involves one relation Submit proper DDL and DML statements in sequence that can accomplish this with Oracle-VM and then the QL statement to display the result table.

can I get help with this SQL question please?

Create a relation that represents the dependence between objects. The table should have two attributes called object and dependent, where object is the primary key of the relation and dependent is a foreign key that references object. Then insert three tuples into this table: 1. B is dependent on A 2, C is dependent on B 3. A is dependent on C Note that this problem is similar to chicken-egg problem but only involves one relation. What you need to submit is proper DDL and DML statements in sequence that can accomplish this in Oracle. create table part2 ( object char(10) primary key, dependent char(10), foreign key (dependent) references part2(object); insert into part2 values (C, null); insert into part2 values (B, C) insert into part2 values (A, B); update part2 set dependent A where object C

can answer be given in a form like this example?

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution