Can anyone help me in this Question .
found the entity type and the constraint , limitation, assumption and diagram
Represent part of the mlitary command structure of the armies of world. It is desired to represent every command unit and all army personnel, along with their ranks and personal details. Each country has one army who has a Commander-In-Chief. Each army is divided into a number of field armies. Each field army has between 90,000 - 200,000 soldiers and is headed by a General. There is only one Field Marshall in each army. Not all generals head a field army.
I think that entity type is :
I think the attribute of countru is the name and the primary key is code >> what you said
country( countryCode, countryName)
so the entity and there attribute but i am not sure it's correct
country : name , code , army name
Army (army name , country name , field army )
- field army : solders number , field army name , army name
- Solders : name , ID , rank
- General : army name , field army name ,
- Marshall : army name , ID , filed army name
- commander – in chief: name ,ID , army name , country name
So please if any one can help me??