An architectural design firm has a number of design projects underway at any point in time. Each of these projects is identified by a unique project identification code. Additional data stored for each project includes a description, a target completion date, and a dollar budget amount. Design associates staff these projects. These associates include architects, engineers, and computer CAD (Computer-Aided Design) specialists. Each associate is identified by a unique code. Other information about associates includes a field for their name and a field for their specialty, and field for their level. There are three levels of associates (gold, silver, and bronze). The bronze associates report to one and only one silver associate (who has at least one bronze associates reporting to her), and the silver associate reports to a gold associate in the same fashion. Each project staffed by at least one associate staff. It is also common to find any particular associate assigned to several projects. Some of these associates may not be assigned to any projects. The firm likes to keep track of each of the associate’s commitment to a project and they do this by recording the percentage of an associate’s time that is allocated to a specific project. The firm has three partners who manage the firm’s projects. Information about partners includes a unique partner identifier, their name, and their phone number. Since there are only three partners, they each have several projects for which they have a responsibility and they each have at least one project. However, to maintain accountability, each project is managed by a single partner.