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.

An engine, weighing 3000 n, is supported on a pedestal mount. it has been observed that the engine induces vibration into the surrounding area through its pedestal at the maximum operating speed. determine the stiffness of the dynamic vibration absorber spring in (n/m) that will reduce the vibration when mounted on the pedestal. the magnitude of the exciting force is 250 n, and the amplitude of motion of the auxiliary mass is to be limited to 2 mm note: in this question type-in right numbers, no decimals, no fractions, no unit. approximate to right number if needed