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