Database System Questions

Please create an enhanced entity-relationship (EER) with ERD below, complete with participation and disjoint constraints. And if the there's something wrong in normalization, you can correct it.

P.S:

- Please answer in a proper format - Please answer in a typed or softcopy format (Optional) - Please don't do it with pen or pencil, do it with software or tools (Optional) - If you want to ask any question, ask it in the comment section, I will try to answer it

Thanks!

customer PK lid guid varchar name employee PK lid guid name varchar phone_number varchar position varchar image birth_place varchar bod date phone_number varchar whatsapp_number varchar HPK id guid varchar url transaction branch guid guid menu_image FK menu_id guid FK image_id guid PK lid guid varchar name PK lid FK branch_id FK customer_id guid FK employee_id guid date menu date PK jid city varchar address varchar email varchar phone_number varchar whatsapp_number varchar guid varchar varchar name category region price quantity varchar numeric transaction_detail FK transaction_id guid FK menu_id guid quantity numeric discount numeric numeric customer PK lid guid varchar name employee PK lid guid name varchar phone_number varchar position varchar image birth_place varchar bod date phone_number varchar whatsapp_number varchar HPK id guid varchar url transaction branch guid guid menu_image FK menu_id guid FK image_id guid PK lid guid varchar name PK lid FK branch_id FK customer_id guid FK employee_id guid date menu date PK jid city varchar address varchar email varchar phone_number varchar whatsapp_number varchar guid varchar varchar name category region price quantity varchar numeric transaction_detail FK transaction_id guid FK menu_id guid quantity numeric discount numeric numeric