[5] We have an (over simplified) university database, with attributes CLASS, SECTION, STUDENT, MAJOR INSTRUCTOR, RANK,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
[5] We have an (over simplified) university database, with attributes CLASS, SECTION, STUDENT, MAJOR INSTRUCTOR, RANK, SALARY, and TEXT. Intuitively a given CLASS (such as IS702) is divided into SECTION (such as Section 2) each of which has one INSTRUCTOR and various STUDENTS. Each CLASS has a set of TEXT BOOKS, which are used by all SECTIONS of the CLASS. Each STUDENT has one MAJOR. Each INSTRUCTOR has one RANK and one SALARY. Starting with one relation: R(CLASS, SECTION, STUDENT, MAJOR, INSTRUCTOR, RANK, SALARY, TEXT) Find all non-trivial functional and multi-valued dependencies Decompose into 4NF (and hence BCNF) 1. 2. [5] We have an (over simplified) university database, with attributes CLASS, SECTION, STUDENT, MAJOR INSTRUCTOR, RANK, SALARY, and TEXT. Intuitively a given CLASS (such as IS702) is divided into SECTION (such as Section 2) each of which has one INSTRUCTOR and various STUDENTS. Each CLASS has a set of TEXT BOOKS, which are used by all SECTIONS of the CLASS. Each STUDENT has one MAJOR. Each INSTRUCTOR has one RANK and one SALARY. Starting with one relation: R(CLASS, SECTION, STUDENT, MAJOR, INSTRUCTOR, RANK, SALARY, TEXT) Find all non-trivial functional and multi-valued dependencies Decompose into 4NF (and hence BCNF) 1. 2.
Expert Answer:
Answer rating: 100% (QA)
If a functional dependency XY holds true where Y is not a subset of X then this dependency is called ... View the full answer
Related Book For
Thermodynamics An Engineering Approach
ISBN: 978-0073398174
8th edition
Authors: Yunus A. Cengel, Michael A. Boles
Posted Date:
Students also viewed these accounting questions
-
A rm has two divisions, each of which has its own manager. Managers of these divisions are paid according to their effort in promoting productivity in their divisions, which is judged by comparison...
-
A consumer buys n light bulbs, each of which has a lifetime that has a mean of 800 hours, a standard deviation of 100 hours, and a normal distribution. A light bulb is replaced by another as soon as...
-
A train consists of 50 cars, each of which has a mass of 6.8 103 kg. The train has an acceleration of +8.0 10-2 m/s2. Ignore friction and determine the tension in the coupling (a) Between the 30th...
-
Look again at the financial forecasts for Growth-Tech given in Table 4.3. This time assume you know that the opportunity cost of capital is r = .12 (discard the .099 figure calculated in the text)....
-
Emmas adjusted gross income is $ 24,200. She has $ 1,800 in unreimbursed medical expenses. How much in medical expenses can Emma claim as an itemized deduction?
-
Find the response of an undamped system subjected to a square pulse \(F(t)=F_{0}\) for \(0 \leq t \leq t_{0}\) and 0 for \(t>t_{0}\) by using the Laplace transformation method. Assume the initial...
-
List the main stakeholder groups in a company. Consider whether and why each stakeholder group might be interested in corporate eco-efficiency indicators. What level of information is each group most...
-
Following is information for the Fulcrum Companys three business segments located in Europe. Fulcrums applicable tax rate for the segments is 30%, and its weighted average cost of capital for each...
-
Suppose a government has a deficit, and the government finances its deficit by issuing bonds. a. Do you think that it may have any impact on the Monetary Base of the economy? Explain your answer. b....
-
Today, Feb 14th, 2021, I have collected the following from Bloomberg: The spot rate: USD 1.21/EUR 2-year USD YTM=0.11% 2-year EUR YTM=-0.72%. Note: YTM is always quoted per year. if we want to make...
-
1. (2 marks) Write your complete work to convert -8210 to binary using the following methods. Are your answers the same? If you convert a positive number using these methods, are the answers the...
-
On June 30, Year 3, Walton Company's total current assets were $500,500 and its total current liabilities were $279,500. On July 1, Year 3, Walton issued a short-term note to a bank for $41,800 cash....
-
What Strengths are Four Seasons leverage against Market Wide Opportunities?
-
A charge q 1 = - 2 . 8 0 C is at the origin. A charge q 2 = 3 . 2 0 C is at x = 2 0 . 0 cm on the x axis. What is the electric potential in SI units at x = 3 0 . 0 cm ? You attach a 2 . 8 F capacitor...
-
Target Segment - Recreation (1st Priority) - Work (2nd Priority) - Mountain (3rd Priority) - Speed (4th Priority) - Youth 5th Priority Market Size To Focus on smaller, high margin segments Geographic...
-
Please fill in the empty spaces, show the excel formulas. Duration of a Bond Coupon Maturity (years) Maturity (t,) 0.5 1.0 1.5 2.0 Theoretical Price Bond Yield Bond Duration 6.00% 2.0 Cash Flow (c)...
-
Using the returns and the market risk premium data provided to you, answer the following: 1) If I only use historical means and historical covariances to make estimates, what are the a. Expected...
-
The age-old saying for investing is "buy low and sell high," but this is easier said than done. Investors who panic about falling prices sell their investments, which in turn lowers the price and...
-
Calculate the value of the Gibbs function for saturated steam at 500F as a saturated liquid, saturated vapor, and a mixture of liquid and vapor with a quality of 40 percent. Demonstrate that phase...
-
Using the EES software and the relations in Table A-32, calculate the one-dimensional compressible flow functions for an ideal gas with k = 1.667, and present your results by duplicating Table A-32.
-
An adiabatic capillary tube is used in some refrigeration systems to drop the pressure of the refrigerant from the condenser level to the evaporator level. R-134a enters the capillary tube as a...
-
In order to have a correlation coefficient between traits A and B, it is necessary to have: a. one group of subjects, some of whom possess characteristics of trait A, the remainder possessing those...
-
What would you guess the value of the correlation coefficient to be for the pair of variables: "number of man-hours worked" and "number of units of work completed"? a. Approximately 0.9 b....
-
True or False: Whenever r is calculated on the basis of a sample, the value which we obtain for r is only an estimate of the true correlation coefficient which we would obtain if we calculated it for...
Study smarter with the SolutionInn App