Software Engineering The questions are based on this case study. This case study

Question

Software Engineering

The questions are based on this case study. This case study concerns a system to keep track of a group of clubs (or similar type organizations) and their members. The system will keep track of people who belong to the clubs (or want to belong to the clubs). An administrator must add a person to the system. Once a person is in the system, they can add themselves as a member to a club. A person can also remove herself or himself from a club. When clubs have elections, an administrator can record the president and other officers. The president of a club can request a report giving a list of members and information about them, such as e-mail addresses. The system also keeps track of interest groups. These are groups of clubs that share a common interest. So, for example, the rugby club might be in a sports interest group. Clubs can be in many interest groups, or none. Continuing the example, the rugby club might also be in an international interest group. While an administrator must create interest groups, it is the club presidents who choose to add their club to an interest group or not. An administrator can get various reports, such as a list of interest groups and the clubs belonging to each one.

Explanation / Answer

a. entity classes in the case study

1. person

2. club

3. admin

4. president

5. group

b. attributes and there data types

1. person : pid number, pname varchar, cname varchar, email varchar

2. club : cid number, cname varchar

3. admin : aid number, aname varchar

4. president : prid number, prname varchar, cname varchar

5. group : gid number, gname varchar, cname varchar, aname varchar

c. relationship between the classes

1. person and club : many person can be in a club and a person can be in many clubs so many to many relationship

2. admin and person : an admin can add many person but a person can be added by one admin so one to many relationship

3. club and group : a club can be in a group but a group can have many clubs like rugby, snooker can be in sports group so many to one relationship

4. president and club : a club can have one president and a president can be of one club so one to one relationship

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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