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.