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 guid PK lid name varchar birth_place varchar bod date phone_number varchar whatsapp_number varchar gender varchar address varchar email varchar employee PK lid guid name varchar Iphone number varchar position varchar image guid PK lid url varchar transaction menu_image FK menu_id FK Jimage_id guid guid PK lid guid FK customer_id guid FK branch_id guid FK employee_id guid date date menu HPK lid branch PK lid guid name varchar city varchar address varchar email varchar phone_number varchar whatsapp_number varchar guid varchar name transaction_detail varchar varchar FK transaction_id guid FK menu_id guid quantity numeric discount numeric category region Iprice quantity numeric numeric customer guid PK lid name varchar birth_place varchar bod date phone_number varchar whatsapp_number varchar gender varchar address varchar email varchar employee PK lid guid name varchar Iphone number varchar position varchar image guid PK lid url varchar transaction menu_image FK menu_id FK Jimage_id guid guid PK lid guid FK customer_id guid FK branch_id guid FK employee_id guid date date menu HPK lid branch PK lid guid name varchar city varchar address varchar email varchar phone_number varchar whatsapp_number varchar guid varchar name transaction_detail varchar varchar FK transaction_id guid FK menu_id guid quantity numeric discount numeric category region Iprice quantity numeric numeric