Construct an Entity$-$Relationship diagram for the given scenarios $($entities and associated attributes are provided$)$ by incorporating following considerations:

$1.$ Specify key attributes, and multivalued or composite attributes.

$2.$ Self$-$referencing type $($for employees$)$

$3.$ Relationship type

$4.$ Mention cardinality ratio

$5.$ Is there any weak entity type? Justify your answer.

Scenarios:

The Company is organized into departments $($Department$),$ and each department has a unique name $($DName$),$ address $($Daddress$),$ Department number $($DNumber$)$ and phone $($CPhone$),$ and a particular employee id$,$ who is incharge$($Erole$),$ id of employee $($EID$),$ product id of product manufactured $($PID$)$ and the start date $($CStartDate$)$ when that employee began working in the department.

The department produces products $($Products$),$ and each product has unique name $($PName$),$ product id $($PID$),$ product price $($Price$),$ manufacture date $($Mdate$),$ expiry date $($Edate$),$ id of employee $($EID$).$

The employees $($Employees$)$ working in each department within which products has employees name $($Ename$),$ id of employee $($EID$),$ salary $($Salary$),$ address$($Eaddress$),$ role $($Brole$),$and$$age$($Eage$).$