Draw an ERD for the following case. The head of the Chemistry Department wants to develop...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Draw an ERD for the following case. The head of the Chemistry Department wants to develop a small database system for the laboratories of the department. The department has many professors and scientists, who support all the courses related to chemistry and biochemistry. You might have taken the course from the department and have had the chance to work in the laboratory. A laboratory has many researchers who are experts in a particular professional area (organic chemistry, analytical, non-organic, etc.). These researchers work on one or more research projects. A researcher is often assigned to a role (e.g., chief chemist, assistant chemist) in a project. Researchers also may use certain kinds of equipment to conduct research. A researcher generally has an employee id, a name, and several phone numbers shared by several researchers. A researcher must participate in at least one project and use at least one equipment. An equipment also can be used by many researchers. A project usually includes many researchers and many pieces of equipment. An equipment needs not be assigned to a project. The start date and ending date of a project must be recorded. An equipment includes a serial number and cost. An equipment is either new or recycled. Researchers usually are categorized in terms of their professional degrees, which range from 5(low) to 1(high). When a researcher uses an equipment, the checkout date and the returning date needed to be recorded. Draw an ERD for the following case. The head of the Chemistry Department wants to develop a small database system for the laboratories of the department. The department has many professors and scientists, who support all the courses related to chemistry and biochemistry. You might have taken the course from the department and have had the chance to work in the laboratory. A laboratory has many researchers who are experts in a particular professional area (organic chemistry, analytical, non-organic, etc.). These researchers work on one or more research projects. A researcher is often assigned to a role (e.g., chief chemist, assistant chemist) in a project. Researchers also may use certain kinds of equipment to conduct research. A researcher generally has an employee id, a name, and several phone numbers shared by several researchers. A researcher must participate in at least one project and use at least one equipment. An equipment also can be used by many researchers. A project usually includes many researchers and many pieces of equipment. An equipment needs not be assigned to a project. The start date and ending date of a project must be recorded. An equipment includes a serial number and cost. An equipment is either new or recycled. Researchers usually are categorized in terms of their professional degrees, which range from 5(low) to 1(high). When a researcher uses an equipment, the checkout date and the returning date needed to be recorded.
Expert Answer:
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date:
Students also viewed these computer network questions
-
Draw an ERD for each of the following situations. (If you believe that you need to make additional assumptions, clearly state them for each situation.) Draw the same situation using the tool you have...
-
Draw an ERD for the following situation (Batra et al., 1988). Also, develop the list of words for qualifiers and classes that you use to form attribute names. Explain why you chose the words on your...
-
Consider the following function. def f(x): a = [] while x > 0: a.append(x) f(x-1) A new object of type list is created for each recursive invocation of f. True or False
-
Write a paper on Management of Information Security in which you need to write about Minimizing Recurrence of the Risk, Interaction with the operator and Collecting Forensic Evidence
-
A solid conducting sphere of radius R carries a charge Q. Calculate the electric-field energy density at a point a distance r from the center of the sphere for (a) r < R and (b) r > R. (c) Calculate...
-
The toroid in Figure 28.31 has 1000 windings carrying a current of \(1.5 \mathrm{~mA}\). Each winding is a square of side length \(10 \mathrm{~mm}\), and the toroid's inner radius is \(10...
-
In the normal course of performing their responsibilities, auditors often conduct audits or reviews of the following: 1. Federal income tax returns of an officer of the corporation to determine...
-
1 Explain briefly about six sigma and capacity maturity models? 2 Explain about the contemporary management practices taking place in Indian business model? 3 4 What is performance management?...
-
Please write a short (limit 1000 words) essay on the United Nations Human Rights Council's 2017 report on the financialization of housing (relevant links below). You may either agree or disagree with...
-
Make your own "Pledge of Commitment" stating that despite the many challenges you are facing now, still you are able to manage life with courage and determination.
-
You have just completed an exciting employment interview, and you want the interviewer to remember you favorably. Your Task. Write a follow-up thank-you letter to Meredith Murillo, Human Resources...
-
Describe the challenges of the job market in the wake of the COVID-19 pandemic and the skills that will help you weather any economic climate.
-
_____________ likely that the old smartphone and _____________ limited storage capacity wont work much longer. a. Its, its b. Its, its c. Its, its For the above sentence, write the correct letter in...
-
At the all-hands meeting of _____________, the companys executive _____________ were discussed. a. stakeholders, salaries b. stakeholders, salaries c. stakeholders, salarys For the above sentence,...
-
No one likes to give it or receive it, but sometimes criticism is unavoidable, even desirable. Constructive criticism in the workplace is necessary when team members need feedback and managers must...
-
Pharoah Electronics issues a $393,500, 5%, 15-year mortgage note on December 31, 2019. The proceeds from the note are to be used in financing a new research laboratory. The terms of the note provide...
-
Show, if u(x, y) and v(x, y) are harmonic functions, that u + v must be a harmonic function but that uv need not be a harmonic function. Is e"e" a harmonic function?
-
Figure 4-38 includes an EER diagram for a medium-size software vendor. Transform the diagram into a relational schema that shows referential integrity constraints (see Figure 4-5 for an example of...
-
List 10 potential benefits of the database approach over conventional file systems.
-
Indicate whether data administration or database administration is typically responsible for each of the following functions: a. Managing the data repository b. Installing and upgrading the DBMS c....
-
A candlestick chart is similar to a bar chart except that the candlestick chart: A. Represents upward movements in price with Xs. B. Also graphically shows the range of the periods highs and lows. C....
-
What considerations might encourage a market analyst to rely more on a top-down or bottom-up forecast of S&P 500 operating earnings?
-
Which of the following criticisms expressed by Ryan about the use of historical data is the least valid? A. In a context of hyperinflation, the approach may not be appropriate. B. The companies...
Study smarter with the SolutionInn App