Question: Consider two entity sets A and B that both have the attribute X a. If the two Xs are completely unrelated, how should the design

Consider two entity sets A and B that both have the attribute X

a. If the two Xs are completely unrelated, how should the design be improved?

b. If the two Xs represent the same property and it is one that applies both to

A and to B, how should the design be improved? Consider three subcases:

• X is the primary key for A but not B
• X is the primary key for both A and B
• X is not the primary key for A nor for B

Step by Step Solution

★★★★★

3.43 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a answer Basically it does not creating any problem When only one one person creator is managing the ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Database System Concepts Questions!

Q:

Are there two matrices A and B that are similar while A2 and B2 are not similar?

Q:

Two small stereo speakers A and B that are 1.40 m a part are sending out sound of wavelength 34 cm in all directions and all in phase. A person at point P starts out equidistant from both speakers...

Q:

Consider a many-to-one relationship R between entity sets A and B. Suppose the relation created from R is combined with the relation created from A. In SQL, attributes participating in a foreign key...

Q:

Consider two entity sets A and B that both have the attribute X (among others whose names are not relevant to this question). a. If the two Xs are completely unrelated, how should the design be...

Q:

6 . 1 8 Consider two entity sets A and B that both have the attribute X ( among others whose names are not relevant to this question ) . If the two X s are completely unrelated, how should the design...

Q:

HW 5 Construct an E - R diagram for a hospital with a set of patients and a set of medical doctors. Associate with each patient a log of the various tests and examinations conducted. Explain the...

Q:

A creative engineer suggests structuring the TLB so that not all the bits of the presented address need match to result in a hit. Suggest how this might be achieved, and what might be the costs and...

Q:

123 Compare the purely graphical properties of these two notations, and the ways in which the graphical properties of each display correspond to the information structure being defined. Describe...

Q:

Please be sure to not copy any answers verbatim. original answers needed will be scanned through the safe-assign system. read the Marketing Debate below What is the Best Way to Position a brand? and...

Q:

In this question assume that p and q are atomic formulae. (a) Compare and contrast path formulae and state formulae in temporal logic. [4 marks] (b) Describe and contrast the meanings of F(G p) and...

Q:

Find the expectation value of position 4 mom. of a partile whose wode fuen is -~-~P(x) = = 2// tikk in all space. e Calculate

Q:

Assume that you are a member of the Canadian Accounting Standards Board (AcSB) and are a guest speaker at a commercial lender. You have been asked to explain why the board concluded that it would be...

Q:

Costs that do not change with the change in the level of production for some time is classified as _ _ _ _ _ _ _ _ . a . variable costs b . fixed costs c . mixed costs d . None of these choices are...

Q:

2. Assume the following information for a hypothetical economy in year 1: money supply = $400 billion; long-term annual growth of potential GDP = 3 percent; velocity = 4. Assume that the banking...

Q:

The boolean indicator used to mark nodes in a red-black tree as being red or black is not strictly needed when we have distinct keys. Describe a scheme for implementing a red-black tree without...

Q:

Let T and U be (2,4) trees storing n and m entries, respectively, such that all the entries in T have keys less than the keys of all the entries in U. Describe an O(logn+logm)-time method for joining...

Q:

If the approach described in the previous problem were implemented as part of the TreeMap class, what additional modifications (if any) would be necessary to a subclass such as AVLTreeMap in order to...

Q:

Apple's bonds have 5 years remaining to maturity. Interest is paid semiannually, the bond has a $ 1 0 0 par value, and the annual coupon rate is 1 0 % . The bond has a YTM of 1 5 % . a . What should...

Q:

Using the following returns, calculate the arithmetic average returns, the variances, and the standard deviations for X and Y. Year 1 2 3 4 5 Returns Y 11 % 22 % 29 43 18 -19 -27 20 51 -13...

Q:

The cost to purchase the house the Bainters are considering is $195,000, but the Bainters plan to make a $40,000 down payment. The Bainters have been approved for a fixed-rate, 30-year mortgage with...