Buabantu is a collection of Machinga entrepreneurs selling clothes, shoes, and female bags. Currently,

Bxabantu buys second$-$hand clothes, shoes, and bags, repairs them, washes them, and gets them ready

to be sold to their customers. According to Mwenda, one of the three partners who own the business, they

have more than $5000$ customers who buy their products located in different areas of Mwanza and Dar es

Salaam. The prices of their second$-$hand products depend much on the brand name of the supplier of the

specific item; for example, Nike and Gucci items are very expensive. Once they buy the product, they sort

it according to the suppliers or brand names. Currently, most of the activities are done manually. Once

they sort the products, they take pictures of each item and post them on Instagram and WhatsApp. When

a customer calls or orders any product over the phone or on social media, Amina and Veneranda check

the availability of the items in question. If the item is available, one of the clerks $($Amina or Veneranda$)$

will request that the customer make a payment, and arrangements will be made for delivery. If it's outside

the city, there will be some cost for transport. If the customer spends more than $200,000$ Tanzanian

shillings, there is a discount of $5\%.$ The challenge facing Bwabantu currently is knowing the stocks of

clothes, bags, and shoes so that they can update their social media platforms where they advertise their

products. Therefore, they want to take advantage of a database management system to control their

business and later develop the shop cart system to sell their products. As a database architect or consultant,

you are required to:

Construct an entity$-$relationship diagram $($ERD$)$ from the Buabantu case study:

Identify a minimum of eight entities and assign them appropriate names.

Specify all possible cardinalities in the relationships.

Indicate potential primary keys and foreign keys and incorporate at least two constraints.

Explain the Utilization of Business Rules:

Clarify how the identified business rules in the Bwabantu case study are incorporated into

the ERD. Detail how these rules influence the structure and behaviour of the database.

Implementation of the $5\%$ Discount Feature in ERD:

Clearly state whether it is feasible to implement the $5\%$ discount feature within the entity$-$

relationship model $($ERM$).$ Provide a robust defence for your answer, explaining how or

why the ERM can or cannot accommodate this discount feature.

Explain All Relationships Existing in Those Entities:

Elaborate on the nature and purpose of each relationship that exists among the identified

entities in the ERD. Provide insights into how these relationships contribute to the overall

functionality of the system.