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.

Question

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 Answer

1 Rating

Want to see the step-by-step answer?

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times may vary by subject and question complexity. Median response time is 34 minutes for paid subscribers and may be longer for promotional offers.
Tagged in
Engineering
Computer Engineering

Database Management

Related Computer Engineering Q&A

Find answers to questions asked by students like you.

Q: Define Clock cycles.

A:  The Speed of central processing unit (CPU) or computer processor is said to be Clock cycle which is...

Q: Please see question attached.

A: A logic circuit is basically a circuit which performs logical actions or operations on the input sig...

Q: Hi, my CIT 105 teacher is horrible, and does not teach. She wants an IF equation in microsoft excel ...

A: Hi Josh, hope the explanation below helps.  Actually you would need to incorporate the cell name in ...

Q: which of the following is an example of a computer system resource? a. CPU b. hard disk drive c. las...

A: The computer system resources include Central Processing Unit (CPU) and Hard Disk Drive (HDD).System...

Q: in javaWrite a program that generates 10 random doubles, all between 1 and 11, and writes them to a ...

A: The class FileWriteDouble generates random numbers within the given limits and writes it to a text f...

Q: Write a program that generates 10 random doubles, all between 1 and 11, and writes them to a text fi...

A: In the first program – Create an object for a file. Take an array of double type. Open a file using...

Q: Explain Parallel processing.

A: Parallel processing Parallel processing is a method of breaking up and running program tasks simult...

Q: zy 4.2. Row arrays b My Questions | bartleby G how to screenshot on windows A learn.zybooks.com/zybo...

A: Matlab program to shift the array element to the left by 1 position. After shifting the elements set...

Q: I have a Python programming question:  Write a program that prints all the even numbers divisible by...

A: Following is the python program:Approach: Initialize variable i with 1 as the given range starts fr...

Q: In javaScript, What is the difference between the setTimeout() and setInterval() methods. Which meth...

A: setTimeout(): It allows the programmer to execute the piece of code with some specified time (measu...

Q: You buy a chip that is 32Kx8. How many memory locations does the chip have?

A: Answer = 32K

Q: For the following MIPS assembly instructions above, what is a corresponding C statement?           a...

A: The first code statement of the MIPS assembly: add  f, g, h this statement means that adding the val...

Q: Explain Addressing modes.

A: Addressing modes Addressing modes are an aspect of instruction set architecture in most central pro...

Q: I have a Python programming question: Write a program that prints all the even numbers divisible by ...

A: Program Approach – Create a list named as a result. Use a while loop to iterate the value of i fro...

Q: I have a python programing question A junior magician has picked a secret number. He has hidden it i...

A: For writing a guessing game the following points are important: Store the secret number in a variab...

Q: In C# create an application that writes a series of random numbers to a file. Each random number sho...

A: Import the required library like System and System.io The variable numbercount is declared and initi...

Q: Given the analog signal shown in figure, what are the 8-bit pulse code modulated values that will be...

A: Pulse Code Modulation (PCM): PCM is one of the encoding techniques used for converting analog data ...

Q: I have a python programing question In 1937, a German mathematician named Lothar Collatz formulated ...

A: The program defines a function collatz which accepts a single integer parameter. It calculates the n...

Q: Write a program that deliberately contains an endless or infinite while loop. The loop should genera...

A: Program approach-Import the essential java packages.Declare the class.Define the main method.Use sca...

Q: Reference the code in the picture below. What will be the value of the global variable name after Bu...

A: Answer:

Q: We need to create a database for the Circulation Department of a public library. The database will s...

A: The database schema would have the following structure (primary keys are italicised and foreign keys...

Q: can you help me with 1 to 3

A: Slicing and dicing refers to data manipulation which could be one or more of the following: taking ...

Q: What decimal number does the bit pattern 0×0C000000 represent if it is a floating point number? Use ...

A: Given case: Here in the given case, Sign bit is “Positive”. Exponent bits are “00011000”, which is ...

Q: Write down the binary representation of the decimal number 63.25 assuming the IEEE 754 single precis...

A: Convert 63.25 to its binary form – First for the decimal part – Divide the number by 2 until the quo...

Q: Which cabling technology can travel the greatest distance?     a. twisted pair     b. co...

A: The answer is (c), that is, the fiber. The fiber cable, also known as optical fiber cable, can be al...

Q: throughput using go back n protocol

A: The window size 10 is specified in the given problem. The bandwidth 1500 bps is specified in the giv...

Q: What is 4365 - 3412 when these values represent signed 12-bit octal numbers stored in sign-magnitude...

A: The number is negative, if the sign bit is “1”. And the number is positive, if the sign bit is “0”. ...