|Problem I {total 24 points ) Assume the following real - world environment concerning a small supermarket , the Happy Valley Culinary...

Draw an ER diagram and SQL statement for creating the table according to the ER diagram.

• Attachment 1
• Attachment 2
• Attachment 3

|Problem I {total 24 points ) Assume the following "real - world" environment concerning asmall supermarket , the Happy Valley Culinary Boutique ITYLEY. TWICE is organized intodepartments , each of which has some employees . Items are sold by departments , and are*supplied by suppliers . Each supplier gives its own unique codes to the items it supplies . Alsozach supplier has exactly one contact person who is an employee .*Consider the relationSchemas !`Dents[alD , aName, budget !Gives the departments , their IN Home andd stands for department .budget .Employeeskelly, ally, ellame esalary!Gives the employees , their IN's, Where they'EStands for Ennuioverwork, their names and salaries .Suppliers ( s ID , sVame , ` CITY , State, elD]Gives the suppliers , their IN's, their names*{ stands for supplier .and where they are located Icity and state !*Abse tells which employees are contactpersons for the suppliers .Itemsis ID , SiCade , DID , IName HISRP !Gives the items and the departments that selli stands for item , si code stands for supplier -the items . MSRP_ manufacturer suggestedassigned item coderetail pricePrimary Keys are underlined . Each relation schema has one candidate key Itherefore , it's theprimary key', it may be missing candidate [unique ; Keys and foreign Keys .*Do the following ( 3 steps ) .1 . 1 8 points ; Complete (i.e., reverse Engineering ; the ER diagram below such that the*4 relationschemas above are exactly the result of a translation from the ERD to the relational model . Youare NOT allowed to add any additional enmity setDeptsItemsEmployeesSuppliers