Create an ERD for each of the following statements that describe the current business rules for ABC.
For each new statement being the business rule, extend the ERD to include the additional business
rule in the ERD (created in previous point – for example; B will include A&B, C will include A, B & C,
etc.)
Use Crows Foot notations and include all the following in each part:
FNDS015: Information Technology-2018.1
? All entities must have Primary key.
? All related entities must have appropriate foreign key attribute/s;
? In each entity add at least 2 other attributes in addition to Primary key and/or foreign key;
? Make sure to show the relationships between entities;
? The cardinality and optionality of each relationship;
? Any M:N relationships are be resolved to 1:M relationships.