Complete 1 through 4 for the following scenario.
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.
Draw an ER model using any standard notation, clearly denoting maximum and minimum cardinality constraints.
Write the one liner and four sentences for each diagram (statements that specify degree and mandatory aspects of each entity, if applicable).
List the number of tables needed and the columns in the tables including the Primary and Foreign Key postings.
List the SQL/Oracle statements to create the tables.