Ternary Troubles
An example of a ternary relation is described. It includes the entities client, project, and architect with the relation assigned.
Consider the situation where this is used in an actual firm. Additionally, the firm has heard the rumor that one of the architects is planning on leaving and taking a client with to start a new firm. The leaders of the organization have asked IT to prepare a report that lists any architects that have multiple projects with a single client.
Deliverables - 1000 to 1200 words.
1. A discussion of whether it is possible to extract this information from this relationship.
2. A discussion of what changes to the database would be required to be able to produce this report.