Question

A military information system on a base overseas tracks personnel on the base.  Each military member is tracked by ID#, name, rank, and address.  Each military member belongs to an organization on the base which has an organizational name, located in a building on the base and has a primary function (e.g. Communications Squadron).  Each of these organizations is also commanded by one of the military members .  In tracking command sponsorship each military member may have one or more dependents.  Each dependent has an ID#, name, age, and sex.  Each organization on the base is involved working issues or projects which may be of interest to the base commander.  Each organization also belongs to a command which has a location and a unique numerical designation.  The Organization's projects are tracked by a serial number and an origination date.  The information system you are designing will also track descriptions of the projects and their close-out dates.

Build an entity relationship model for the above scenario.  Show all attributes and indicate all of your key attributes in red.