Draw an ER schema diagram for the database that is to keep track of information for a manufacturer. Assume that the following requirements were collected:

I.Each Vendor supplies a specify quantity (SUP_QTY) of a given Raw Material on a specific date (SUP_DATE) at a specific unit price (SUP_PRICE). Some Vendors supply multiple Raw Materials, and some Raw Materials are supplied by multiple Vendors.

II.Each Product is made using one or more Raw Materials. Some Raw Materials are used in the manufacture of several Products. For each unit of a given Products, the quantity (U_QTY) of each Raw Material that is used is also recorded.

III.Products are produced in Batches at Work Centers. Typically there would be multiple Batches of a given Product, with each Batch being for a single Product. Similarly there would be multiple Batches produced at each Work Center, with each Batch being produced at a specific Work Center.

IV.Each Batch has a batch number (BHNO) but it is possible that multiple batches could have the same BHNO, and so to uniquely identify a Batch the associated product number (PNO) has to be specified.

V.Each Employee has at least one Skill, with some having multiple Skills. At a given point in time it may be possible that for some Skills there is no current Employee who has that Skill.

VI.At least one Skill is used in the development of each Product, with some Skills being used In the development of several Products.

VII.Every Work Center has at least one Employee who is assigned to it. Some Employees are assigned to different Work Centers in different periods (ASGN_START, ASGN_END).

VIII.Some of the Employees are Managers while some of the others are Technicians. The date (PROM_DATE) on which an Employee was promoted to be a Manager is recorded along with his/her Bonus if production targets are exceeded; the pay grade (PAYGRADE) is recorded for each Technician but not for Managers.

IX.A single Manager supervises the production of each Batch of a given Product. One or more Technicians are associated with the production of each Batch of a given Product. Some Managers supervise the production of several Batches but some recently appointed Managers might not have supervised the production of any Batch

	Identifier	Other Attributes
Vendor	VDNO	VD_NAME, VD_ADDR
Raw Material	RMNO	RW_NAME, RW_DESCR
Product	PRNO	PR_NAME, PR_PRICE
Batch	BHNO	BH_DATE, BH_QTY
Work Center	WCNO	WC_NAME, WC_LOCATION, WC_SIZE
Employee	EMNO	EM_NAME, EM_ADDR, EM_DOB
Skill	SKNO	SK_NAME