Draw an E-R diagram for each of the descriptions below. Q -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 their name, specialty, their level. There are three levels of associates (gold, silver, and bronze). The bronze associates report to one and only one silver associate (who typically 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.

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

100%

Draw an E-R diagram for each of the descriptions below.

Q -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 their name, specialty, their level. There are three levels of associates (gold, silver, and bronze). The bronze associates report to one and only one silver associate (who typically 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.

Expert Solution