Lab 7 : Binary Relation with M:N cardinality ratio for a supplier and engineering parts

Consider a binary relationship with M: N cardinality ratio. A supplier supplies many engineering parts, and a part is supplied by many suppliers. Do the following action and assume the circumstances to design the table.
                        a.   Design Table and consider non redundancy
                        b.   Necessary Constraints for cardinality radio.
                        c.   Check Constraint must be used for Suppliers’ City.
                        d.   Find the supplier NUMBER and CITY who supply part P2
e.  Find the supplier NUMBER(S) who belongs to London and   supplied part P2
f.   Find the supplier NUMBER who supplied maximum part

No comments:

Post a Comment

Popular Posts