Let tables PART and PART_STRUCTURE be defined as follows: CREATE TABLE PART (P# P#, DESCRIPTION CHAR(100), PRIMARY

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 .