[Solved]Develop Er Diagram Fd Diagram Fd Diagram Need Integrated B Develop Database Design Providi Q37208908
a) develop an ER diagram and an FD diagram. The FD diagramneed not to be integrated.
b) develop a database design providing appropriaterationale
PART II Macomb Housing Authority (10 pts) Macomb Housing Authority (MHA) allocates apartments to low income families (tenants) and also maintains th (huName), address and phone (mgrPh), (assignDt) and the number of days it was vacant. The unit manage tenants. If a manager cannot fix a problem (water leak) he/she prepares a work order-do no subtypes. The work order has a wo# date of the order (ordDt), the date problem was fixed (fixDt), material estimates (matEst), labor estimates (labEst) and actual labor/material cost (labCost, matCost). It is desirable to know the number of days (woDays) before the problem is fixed. Please use abbreviated names for attributes as given. unit manager. The MHA maintains information on manager (mgrNm), manager from e housing. Apartments are part of housing units. Each housing unit has a unique name tenant(tName), apartment# (apt, nurnber of family members, when it was assigned rs handle maintenance requests 1) List Eclasses and attributes (2 pts) Show transcribed image text PART II Macomb Housing Authority (10 pts) Macomb Housing Authority (MHA) allocates apartments to low income families (tenants) and also maintains th (huName), address and phone (mgrPh), (assignDt) and the number of days it was vacant. The unit manage tenants. If a manager cannot fix a problem (water leak) he/she prepares a work order-do no subtypes. The work order has a wo# date of the order (ordDt), the date problem was fixed (fixDt), material estimates (matEst), labor estimates (labEst) and actual labor/material cost (labCost, matCost). It is desirable to know the number of days (woDays) before the problem is fixed. Please use abbreviated names for attributes as given. unit manager. The MHA maintains information on manager (mgrNm), manager from e housing. Apartments are part of housing units. Each housing unit has a unique name tenant(tName), apartment# (apt, nurnber of family members, when it was assigned rs handle maintenance requests 1) List Eclasses and attributes (2 pts)
Expert Answer
Answer to a) develop an ER diagram and an FD diagram. The FD diagram need not to be integrated.b) develop a database design provid… . . .
OR
