Question

Question 5: ERD and Relational Schema 10 marks Figure 1 shows an ER diagram for a university dining services organization that provides dining services to a university. 1- Transform the diagram to a set of relations and develop a relational schema (5 marks) Find the functional dependencies in the relations and determine their normal forms (5 2- marks) MENU EVENT Served at Event ID Menu ID Event Location Menu Description Event Time Menu Type Contains Supervises DISH WORK SCHEDULE STAFF DishID Start Time Name Dish Name End Time Salary (Skill) Prep Time (Ingredient Position

Answer 1

IF YOU HAVE ANY DOUBTS COMMENT BELOW I WILL BE TTHERE TO HELP YOU..ALL THE BEST..

Exancfor m EER diagsa fo a Sef a) of selartions and adevelops a atienal&chema tha relafionalschema deseoi bes tthe overall Stucture af tie data bose 4 he logi cal data bat mode Conveste Co Conceptua data ecef in the veloctional schema to Claly exprece relotionsltp amona the relation povided to an Eo ame unique Eindividual e tation paresent in the dato beuse the EER en hanced entit e Cer fonship) diaqam is amd les e Cationa schema Converted in eo Sef of elations Cs Scanned with CamScanner

Menu Menu Menu Mento esph Memudich Menu o Dieh 10 Dech Ducla D Dichnamt Prop time Dich Inarediant Sish iD Dnepediant ID Riaredrant Tnorediant D n Cedi ant ame Event EVent ip Event Dacte Event locaton Evanttime emu woK sehedule ventip tmpiD Pesiton tcrt time End time STAFF lempID Name Sa lary iupenision iD Skill EXPERT LEE Skill SKillnand CS Scanne EMPAD CHill ID CamScanner

) Pune bna dependency Of the elation FuneHonal dependlency fm a.soctottan bfwcen tte too attbuutes Same Ctoo Set of affoibuter having wiich is delottiona data base tatle Consfraimts is Same dependeney affxibeutes funciona{ly fable ane Eh a 2 andther affIbutes to tate dependenct One Value. the deagram &hoor tte oelafianar ecbema funch onal dependendes, as will uoos. Constratstt be Set of the dependency aftinbutes menu Valuaffan Punefanal depndencey meau descption menu ID menu type menu descjpHon ae fum ch danoell dependeat on nene 1D funch onal depndeney Dish velatian Tish iD-7 Dish name pacp ime atoe the attiiutes fumeianally dependent d ngrediont is CS Scanned with ch CamScanner D

Pun etional depndency in Tngoediant elation ngrediant name Pnoediant ID Engordient name a tthe aftaiates fumetionaflY dependent in ingoediont D DumeHonal dependeney in evane elatian uent data, event (olation, event time Eventp menuiD Dm Cional de pdeney in coor ehedule elartrons Postefon, Stat ime,end fime vent iD- Enp iD Cunctonal dependenty in staff sela tions Emp 1Dname te Salasy, Superisor D dim Ghonal dependeney in staAf selation! SKill ID Ssll mame CS Scanned with CamScanner

I HOPE YOU UNDERSTAND..

PLS RATE THUMBS UP..ITS HELPS ME ALOT..

THANK YOU...!!