Question: 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
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 mandatoriness of each entity, if applicable). Number of tables needed and the columns in the tables especially Primary and Foreign Key postings must be complete.
_____________________________________________________________
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.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
