mysql - Database table relationship design -

i trying write out database design include following relationships, have tried work them out top down, hierarchically, relationships seem better connected way, cannot see, or express how.

(this comes fouo system work, names have been changed reflect classification, that's why names may odd.)

each branch 1:n functional areas,

each building 1:n groups,

each group 1:n units,

each functionalarea 1:n checklists,

each checklist 1:n items, and

each unit 1:n checklists ,

this solved re-evaluating relationships without concern size or data type hold. 1:n relationships used in lieu of n:n.

when designing database need specific relationships. example need mention things "a functional area can belongs 1 branch only". these determine either going have 1:1 relations or 1:n or else.

however have come answer.