Draw a class diagram representing the application domain facts below, and map it to a relational schema.
• A project involves a number of participants.
• Participants can take part in a project either as project manager, team leader, or developer.
• Within a project, each developer and team leader is part of at least one team.
• A participant can take part in many projects, possibly in different roles. For example, a participant can be
a developer in project A, a team leader in project B, and a project manager in project C. However, the
role of a participant within a project does not change.
• The key to the exercise is to create a Role class between the participant and the project.
• The association between Manager and Project is not explicit in the above facts but should be known to the
student from the definition of project manager in the book. As a one-to-one association, it can be represented as a
buried association in either the Manager or the Project table.
• Also, implicit in the above description is that each participant takes part in a project in exactly one role, which
would have to be represented with an OCL constraint and checking code. This sample solution does not take into
account this constraint in the sense that it would allow a single person to take part in the same project in multiple
roles.
You might also like to view...
____________ namespace members appear to occupy the ___________ namespace and do not have to be qualified with a namespace name.
a. Global, unnamed. b. Unnamed, global. c. Named, static. d. Named, global.
The Group By clause has to be used with Sum, Count, and so on in order to display aggregated data
Indicate whether the statement is true or false
In some programming languages, strings are entered surrounded by either single or double quotation marks. Write a program that reads the three strings suzy, "suzy" and 'suzy'. Are the sin- gle and double quotes ignored or read as part of the string?
What will be an ideal response?
Which one of the following is not one of the three types of events recorded in Event Viewer?
a. Alerts b. Errors c. Warnings d. Informational