$3.$ Draw an EER diagram for the following description. A sport equipment manufacturing

company wants to build a database for its products. Equipment are of two types: protective and

specific sport. Other types of equipment can be added. All equipment have three attributes: EID,

EName, and EPrice. Protective equipment have two attributes: ProtectArea, and ProtectMaterial.

Specific Sport equipment have two attributes: SportName, and EquipPurpose. It is possible for

an equipment to be both protective and specific sport. The company has three types of

employees: salespeople, designers and repair staff. It is possible for an employee to belong to

more than category. All employees share these attributes: EID, EName $($EFname$,$ ELname$),$

EAge and EPhoneNo. EAge is a derived attribute. Salespeople have two additional attributes:

SalesQuota, SalesRegion. Designers have an additional attribute: TerminalDegree. It is important

for the company to maintain the last diploma that a Repair staff received and the date on which

they did. Sales staff sell equipment to customers. Customer attributes include: CID, CName and

CAddress. CAddress is a composite attribute, consisting of CNumber, CStreet, CCity. CState,

and CZip. The date and quantity of the sale must be captured and stored. Repair staff fix any

number of specific sport equipment and specific sport equipment can be fixed by any number of

repair staff. It is important to store the date on which the equipment is fixed. A designer can help

any number of customers and a customer can be helped by only one designer. An employee can

manage zero to many other employees and an employee can be managed by only one employee.

Make your assumptions explicit.