URGENT PLEASE: DB Question

1. Database of a clothing store will be made. Made in this clothing store

The processes were analyzed and the results are listed below.

-The clothing store has sections such as men, women, children and sports.

-Each section has sub-sections. For example, in the men's section;

trousers, shirts and shoes in the women's section; such as dresses, skirts, blouses.

-There are products in the subsections. Each product; code, size, price, and

There is explanation information.

-The products have brands. Likewise, each brand has multiple (for example, the Adidas brand has both trousers and shirts, both shoes, etc. such as finding products).

-The name, address and telephone information of the customer who purchased the product is kept.

-An invoice is issued to the customer. Invoice number, date information are available. Multiple invoices can be issued to a customer.

-There can be more than one product in one invoice. One product in multiple invoices

can be found. Product quantity information is determined when the invoice is issued.

Question: According to the above information;

a. Create the entity-relationship (E-R) diagram of the clothing database.

b. Create the relationship diagram in the relational data model.