Question 2 (10 marks) Full mark This question assesses your understanding of Con

Question

Question 2 (10 marks)
Full mark
This question assesses your understanding of Conceptual Data Model (CDM) and the occurrence diagrams and the notation of Entity-Relationship diagrams as presented in Section 5 of Block 1.
Give a the CDM and the simplest possible representative occurrence diagram for each of the following situations; Include all 5 components of the CDM, making sure not to miss any parts of the CDM.
8
(a) Represent part of the military command structure of the armies of the 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 80,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.
4
(b) A sports club wants to maintain a sign-up list for its activities. Each club member may sign-up for multiple activity sessions, and each activity session may be booked by many members. Each activity has several sessions. A coach is assigned to supervise each activity session. An activity is described by a name and a brief description.

Explanation / Answer

i did this in my project......just give me a lifesaver rating and i will surely inbox it to u.......i dont normally do this but the time is the criteria

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.