Question

Let tables PART and PART_STRUCTURE be defined as follows: CREATE TABLE PART (P# P#, DESCRIPTION CHAR(100), PRIMARY KEY (P#)); CREATE TABLE PART STRUCTURE ( MAJOR P#, P#, MINOR P# P#, QTY QTY, PRIMARY KEY (MAJOR_P#, MINOR P#), FOREIGN KEY (MAJOR_P#) REFERENCES PART, FOREIGN KEY (MAJOR_P#) REFERENCES PART); Table PART_STRUCTURE shows which parts (MAJOR_P#) contain which other parts (MINOR_P#) as first level components. Write an SQL program to list all component parts of a given part, to all levels .

$1.99
Sales0
Views172
Comments0
  • CreatedNovember 03, 2009
  • Files Included
Post your question
5000