Parts are described by partnum, color, and price. Parts can be subassemblies as well and this means that they contain other parts. One part cannot be a component of more than one subassembly but a subassembly can contain many other parts. A part need not be a component of any subassembly (please note that a subassembly is a part well), but a subassembly must contain more than one part.

Need sql statements to create the table above. I am using ORACLE.