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
gogolik [260]
3 years ago
10

Suppose we have a database for an investment firm, consisting of the following attributes: B (broker), O (office of a broker), I

(investor), S (stock), Q (quantity of stock owned by an investor), and D (dividend paid by a stock), with the following functional dependencies: SD, I B.IS a Find a key for the relation scheme R(B,O,S,Q,I,D). b. Find a decomposition of R into third normal form, having a lossless join and preserving dependencies c.Find a lossless join decomposition of R into Boyce-Codd normal form.
Engineering
1 answer:
Snowcat [4.5K]3 years ago
8 0

Answer:

Given, FDs are:

S -> D

I -> B

IS -> Q

B -> O

a)

"I" and "S" must be there in any candidate key because they do not appear on the right side of any functional dependency.

The only candidate key is: IS

IS -> ISBDQO

b)

Decomposition of R into 3NF: (I, B), (S, D), (B, O), (I, S, Q)

c)

Decomposition of R into BCNF:

Decompose R by I → B into R1 = (I, B) and R2 = (I, O, S, Q, D).

R1 is in BCNF

Decompose R2 by S → D into R21 = (S, D) and R22 = (O, I, S, Q).

R21is in BCNF

Decompose R22 by I → O into R221 = (I, O) and R222 = (I, S, Q).

R221 is in BCNF.

R222 is in BCNF.

The decomposition is: (I, B), (S, D), (I, O), (I, S, Q)

We can also write it as: (I, B), (S, D), (B, O), (I, S, Q)

Explanation:

The answer above is rendered in a very explanatory way.

You might be interested in
The two boxcars A and B have a weight of 20 000 Ib and 30 000 Ib, respectively. If they coast freely down the incline when the b
Tpy6a [65]

Answer:

Answer for the question :

"the two boxcars A and B have a weight of 20 000 Ib and 30 000 Ib, respectively. If they coast freely down the incline when the brakes are applied to all the wheels of car A causing it to skid, determine the force in the coupling C between the two cars. The coefficient of kinetic friction between the wheels of A and the tracks is μk=0.5. The wheels of car B are free to roll. Neglect their mass in calculation."

is explained in the attachment.

Explanation:

Download pdf
3 0
3 years ago
Read 2 more answers
An ideal vapor-compression refrigeration cycle operates at steady state with Refrigerant 134a as the working fluid. Saturated va
Ksju [112]

Explanation:

Note: Refer the diagram below

Obtaining data from property tables

State 1:

\left.\begin{array}{l}P_{1}=1.25 \text { bar } \\\text { Sat - vapour }\end{array}\right\} \begin{array}{l}h_{1}=234.45 \mathrm{kJ} / \mathrm{kg} \\S_{1}=0.9346 \mathrm{kJ} / \mathrm{kgk}\end{array}

State 2:

\left.\begin{array}{l}P_{2}=5 \text { bor } \\S_{2}=S_{1}\end{array}\right\} \quad h_{2}=262.78 \mathrm{kJ} / \mathrm{kg}

State 3:

\left.\begin{array}{l}P_{3}=5 \text { bar } \\\text { Sat }-4 q\end{array}\right\} h_{3}=71-33 \mathrm{kJ} / \mathrm{kg}

State 4:

Throttling process  h_{4}=h_{3}=71.33 \mathrm{kJ} / \mathrm{kg}

(a)

Magnitude of compressor power input

\dot{w}_{c}=\dot{m}\left(h_{2}-h_{1}\right)=\left(8 \cdot 5 \frac{\mathrm{kg}}{\min } \times \frac{1 \mathrm{min}}{\csc }\right)(262.78-234 \cdot 45)\frac{kj}{kg}

w_{c}=4 \cdot 013 \mathrm{kw}

(b)

Refrigerator capacity

Q_{i n}=\dot{m}\left(h_{1}-h_{4}\right)=\left(\frac{g \cdot s}{60} k_{0} / s\right) \times(234 \cdot 45-71 \cdot 33) \frac{k J}{k_{8}}

Q_{i n}=23 \cdot 108 \mathrm{kW}\\1 ton of retregiration =3.51 k \omega

\ Q_{in} =6 \cdot 583 \text { tons }

(c)

Cop:

\beta=\frac{\left(h_{1}-h_{4}\right)}{\left(h_{2}-h_{1}\right)}=\frac{Q_{i n}}{\omega_{c}}=\frac{23 \cdot 108}{4 \cdot 013}

\beta=5 \cdot 758

3 0
3 years ago
Why might construction crews want to install pipes before the foundation is poured?
denpristay [2]
I’m a concrete mason myself and I can tell you it is a pain in the butt to Roto hammer a hole into the concrete to put the pipe in it’s a lot easier to just pour the concrete around it
6 0
2 years ago
How would you describe what would happen to methane if the primary bonds were to break?
erastova [34]

Answer:

All the bonds in methane (CH4CH4) are equivalent, and all have the same dissociation energy.

The product of the dissociation is methyl radical (CH3CH3). All the bonds in methyl radical are equivalent, and all have the same dissociation energy.

The product of that dissociation is methylene (CH2CH2). All the bonds in methylene are equivalent, and all have the same dissociation energy.

The product of that dissociation is methyne (CHCH) .

The C-H bonds in methane do not have the same dissociation energy as C-H bonds in methyl radical, which in turn do not have the same dissociation energy as the C-H bonds in methylene, which are again different from the C-H bond in methyne.

If (by some miracle) you were able to get all four bonds in methane to dissociate absolutely simultaneously, they would all show the same dissociation energy… but that energy, per bond broken, would be different than the energy required to break just one C-H bond in methane, because the products are different.

(In this case, it’s CH4→C+4HCH4→C+4H versus CH4→CH3+HCH4→CH3+H.)

To alter hydrocarbons you add enough energy to break a C-H bond. Why does only one bond break? What concentrates the energy on one C-H bond?

the weakest CH bond is the one that breaks. in plain alkanes it has to do with the molecular orbital interactions between neighboring carbon atoms. look at propane for example. the middle carbon has two C-C bonds, and each of those C-C bonds is strengthened by slight electron delocalization from the C-H bonds overlapping with the antibonding orbitals of the adjacent carbons.

since the C-H bonds on the middle carbon donate electron density to both of its neighbors, those two are weakest.

one of them will break preferentially.

which one actually breaks depends on the reaction conditions (kinetics). frankly it's whichever one ramdomly approaches a nucleophile first. when the nucleophile pulls of one of the H's, the other C-H bonds start to share (delocalize) the negative charge across the whole molecule. so while the middle C feels the majority of the negative charge character, the other two C's take on a fair amount as well...

by the way, alkanes don't really like to break and form anions like that.

a better example would be something like isopropyl iodide, where the C-I bond breaks and the I carries away the electron pair, forming a carbocation (also not particularly stable, but more so than the carbanion).

7 0
3 years ago
How will you maintain the orderliness of your storage area 2pts?​
fiasKO [112]

Explanation:

Label and group products. One would think that a general cleanup would be the first step, but no, it's not. ...Clean up the area. ...Put up demarcation lines. ...Stack properly. ...Keep the aisles, paths and ramps clear. ...Have all the safety signs in place.

4 0
2 years ago
Other questions:
  • ): drivers must slow down from 60 to 40 mi/hr to negotiate a severe curve. A warning sign is visible for a distance of 120 ft. H
    7·1 answer
  • Explain about Absolute viscosity, kinematic viscosity and SUS?
    11·1 answer
  • A program is seeded with 30 faults. During testing, 21 faults are detected, 15 of which are seeded faults and 6 of which are ind
    12·1 answer
  • DO NOW: Name the three main legal categories of ownership.
    12·1 answer
  • Steam enters a heat exchanger at a pressure of 1.5 bar and a temperature of 400°C with a mass flow rate of 0.05 kg/s and exits a
    11·1 answer
  • A satellite at a distance of 36,000 km from an earth station radiates a power of 10 W from an
    8·1 answer
  • What are the specifications state that all work shall be done?
    10·1 answer
  • 2. The speaker argues that more data allow us to see new things. Think about your favorite hobby—skateboarding, listening to mus
    8·2 answers
  • Using the tables for water, determine the specified property data at the indicated states. In each case, locate the state on ske
    10·1 answer
  • Answer my question I will mark brainliest
    13·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!