1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Ahat [919]
3 years ago
15

Create a Relational Schema for the following scenario. Include all primary and foreign keys and list any assumptions you make. 

A research facility has many chemists who work on one or more projects.  Attributes of chemists include a unique employee id, a name, rank and email.  Each project has one chemist who is given the title of project leader. A chemist may be the leader of several projects.  Attributes of a project include a unique project number, start date and description.  Each project is assigned to one or more laboratories but each laboratory can house at most one project at any time.  Attributes of a laboratory include a building name, room number, capacity and type. The combination of building name and room number is unique.  Chemists can borrow equipment from the stockroom. Each time a piece of equipment is borrowed the check-out date is recorded and when it is returned a return date is recorded. The return date is set to 00-00-0000 until the piece of equipment has been returned. Historical data on the equipment is maintained and a chemist can check out the same piece of equipment on multiple dates.  Attributes of equipment include a unique serial number, description and cost.

Engineering
1 answer:
NARA [144]3 years ago
4 0

Answer:

See explaination

Explanation:

Some of the Important Observation used in Entity Relational Diagram.

1. A Chemist can be involved one project or many projects

2. A project can hire just one or many chemists.

3. A chemist can lead over one or many projects

4. A project can have only one project leader chemist.

5. A project can be done in 1 or many laboratories.

6. A laboratory can host 0 or 1 projects.

7. A laboratory can have 1 or many equipments.

8. An Equipment can be in 1 or 0 laboratories.

9. A chemist can have 0 or many types of equipments.

10. An Equipment can have 0 or 1 chemist at a time

Notations:

PK=Primary Key:

A primary key, also called a primary keyword, is a key in a relational database that is unique for each record. It is a unique identifier, such as a driver license number, telephone number

FK=Foreign Key:

A foreign key is a column or group of columns in a relational database table that provides a link between data in two tables. It acts as a cross-reference between tables because it references the primary key of another table, thereby establishing a link between them

Composite key:

A composite key is a combination of two or more columns in a table that can be used to uniquely identify each row in the table when the columns are combined uniqueness is guaranteed, but when it is taken individually it does not guarantee uniqueness

You might be interested in
A company wants to develop audio speakers using an inexpensive type of plastic that has a very high quality of sound output. Whi
topjm [15]

Answer:A

Explanation:

Those who want to save money and will use the product for only a few years

5 0
3 years ago
A master precision square is used to validate the
kumpel [21]

Answer:

me you same I didn't understand good luck

4 0
2 years ago
Imagine the reaction A + B LaTeX: \Longleftrightarrow⟺ C + D proceeds at room temperature (25 °C) and is determined to have a re
Wittaler [7]

Answer:

0.2 kcal/mol is the value of \Delta G for this reaction.

Explanation:

The formula used for is:

\Delta G_{rxn}=\Delta G^o+RT\ln Q

\Delta G^o=-RT\ln K

where,

\Delta G_{rxn} = Gibbs free energy for the reaction

\Delta G_^o =  standard Gibbs free energy  

R =Universal  gas constant

T = temperature

Q = reaction quotient

k = Equilibrium constant

We have :

Reaction quotient of the reaction = Q = 46

Equilibrium constant of reaction = K = 35

Temperature of reaction = T = 25°C = 25 + 273 K = 298 K

R = 1.987 cal/K mol

\Delta G_{rxn}=-RT\ln K+RT\ln Q

=-1.987 cal/K mol\times 298 K\ln [35]+1.987 cal/K mol\times 298K\times \ln [46]

=-2,105.21 cal/mol+2,267.04 cal/mol=161.82 cal/mol=0.16182 kcal/mol\approx 0.2 kcal/mol

1 cal = 0.001 kcal

0.2 kcal/mol is the value of \Delta G for this reaction.

5 0
3 years ago
The Reynolds number is a dimensionless group defined for a fluid flowing in a pipe as Re Durho/μ whereD is pipe diameter, u is f
Gala2k [10]

Answer:

the flow is turbulent

Explanation:

The Reynolds number is given by

Re=ρVD/μ

where

V=fluid speed=0.48ft/s=0.146m/s

D=diameter=2.067in=0.0525m

ρ=density=0.805g/cm^3=805Kg/m^3

μ=0.43Cp=4.3x10^-4Pas

Re=(805)(0.146)(0.0525)/4.3x10^-4=14349.59

Re>2100  the flow is turbulent

Note: if you do not want to use a calculator you can use the graphs to calculate the Reynolds number according to their properties

8 0
3 years ago
Design a calculator circuit which can perform either addition or subtraction on a 4-digit binary input and generate a 5-digit bi
uysha [10]

Answer: See attachment below

Explanation:

7 0
3 years ago
Other questions:
  • A furnace wall is to be built of 20-cm firebrick and building (structural) brick of same thickness. The thermal conductivities o
    14·1 answer
  • Design a plan for ""your yard"" (no matter where you live) that will capture and utilize rainwater. You can prepare the plan in
    13·1 answer
  • Atmospheric pressure is measured to be 14.769 psia. a. What would be the equivalent reading of a water barometer (inches of H20)
    11·1 answer
  • A _____ satellite system employs many satellites that are spaced so that, from any point on the Earth at any time, at least one
    10·1 answer
  • Convert mechanical energy into electric energy. What can he use?
    13·1 answer
  • The heat transfer rate per unit area in a thermal circuit is equivalent to what quantity in an electric circuit? A. voltage B. c
    6·1 answer
  • The following displacement (cm), output (V) data have been recorded during a calibration of an LVDT. Displacement (cm), output (
    15·1 answer
  • This problem has been solved!
    10·1 answer
  • Storing parts outside doesn't cause any environmental risks as long as the items are covered.
    12·2 answers
  • State three characteristic of lines of magnetic flux​
    7·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!