Q1. is the given table in first normal form? In case of Yes/No justify your answer....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Q1. is the given table in first normal form? In case of Yes/No justify your answer. And normalize the given table up to 3rd normal form. Student Info Student ID Name Email Course No. GradePoints NN204, SI204, 100111 John Doe doe@usna.edu 2.3,3 IT221 92244 Matt Smith smith@usna.edu SM223, EE301 4,4 113221 Melinda Black black@ usna.edu SI204 3 NN204, SI204, IT221 90110 Tom Johnson Johnson@usna.edu 4.2,3 Q1. is the given table in first normal form? In case of Yes/No justify your answer. And normalize the given table up to 3rd normal form. Student Info Student ID Name Email Course No. GradePoints NN204, SI204, 100111 John Doe doe@usna.edu 2.3,3 IT221 92244 Matt Smith smith@usna.edu SM223, EE301 4,4 113221 Melinda Black black@ usna.edu SI204 3 NN204, SI204, IT221 90110 Tom Johnson Johnson@usna.edu 4.2,3
Expert Answer:
Answer rating: 100% (QA)
Ans No the given table is not in the first normal form because there is no atomic single value in the 1st 2nd and 4th rows So we have to first convert ... View the full answer
Related Book For
Finite Mathematics and Its Applications
ISBN: 978-0134768632
12th edition
Authors: Larry J. Goldstein, David I. Schneider, Martha J. Siegel, Steven Hair
Posted Date:
Students also viewed these computer engineering questions
-
The following table is already in first normal form (1NF). There is only one entry per field. Please convert this table to the third normal form (3NF) using the techniques you learned. Write a short...
-
John Smith took out a student loan to complete his four-year engineering degree. He borrowed $5000, four years ago when the interest rate was 5% per year. A further $6000 was borrowed 3 years ago at...
-
Matt Johnson delivers newspapers and is putting away $15.00 every month from his paper route collections. Matt is eight years old and will use the money when he goes to college in ten years. What...
-
Problem 1: The three velocities shown would indicate that the body is not rigid. Given that the body is known to be rigid, one of the three velocities is clearly incorrect. Draw all lines and take...
-
The statement is not accompanied by footnotes, but you have discovered the following: The average completion period for the companys jobs is 18 months. The companys method of journalizing contract...
-
Rank the following substituted phenols in order of increasing acidity, and explain your answer: CH
-
The Athens Company has two divisions, Alpha and Delta. Delta Division produces a product at a variable cost of \($7\) per unit, and sells 150,000 units to outside customers at \($12\) per unit and...
-
Hammer Orthopedic Corporation periodically invests large sums in marketable equity securities. The investment policy is established by the investment committee of the board of directors and the...
-
Rodgers Corporation produces and sells football equipment. On July 1, 20Y1, Rodgers issued $84,000,000 of 20-year, 14% bonds at a market (effective) interest rate of 12%, receiving cash of...
-
Bradley, age 26, recently graduated from college. He had coverage earlier as a dependent under his father's group health insurance policy, which provided coverage for him to age 26. However, he has...
-
List of Accounts (c) Determine whether the overhead was under- or overapplied and by how much. Overhead $ eTextbook and Media List of Accounts Save for Later Attempts: 5 of 5 used Attempts: 0 of 5...
-
A company has received a contract to supply cement to three new construction sites located in the cities A, B, C. Experts have estimated that the amount of cement which will be required at the three...
-
Verde Custom Cabinets issued $3,200 and $5,400 of direct materials into production for Jobs ABX and DFY, respectively. Direct labor of $2,300 was distributed to Job ABX and $3,400 to Job DFY. Factory...
-
f of This week, you made 200 units of Product F88, which has the following standards and actuals: Direct Labor Hours standard: 6.0 hours per unit $15.00 per hour Direct Labor Hours actuals: 6.3 hours...
-
Which the type of budgeting requested for investment in large assets
-
Bingo Ltd's statement of financial position shows an item of machinery that cost $180 000 and that has accumulated depreciation of $60 000.For taxation purposes, the asset has a net value of $100...
-
General Motors Company operates three business segments: Automotive, Finance, and Technology. The total overhead costs for the year amounted to $12 million. Using the activity-based costing (ABC)...
-
Using the information in P11-2B, compute the overhead controllable variance and the overhead volume variance. Data From Problem 11-2B: Huang Company uses a standard cost accounting system to account...
-
1. Suppose that you are voting in an election for state delegate. Two state delegates are to be elected from among seven candidates. In how many different ways can you cast your ballot? Note: You may...
-
Consider the nutrition problem in Example 1 of Section 3.3. Solve the problem by the simplex method, and then determine the optimal quantities of soybeans and rice in the diet, and the new cost, if...
-
Celsius and Fahrenheit temperatures are related by a linear equation. Use the fact that 0C = 32F and 100C = 212F to find an equation.
-
Is corporate governance relevant at companies over which the state exercises full control?
-
Does the regular rotation of a firms statutory auditors improve corporate governance?
-
What are your views on a firm that replaces its one-tier board with a two-tier board and then, a few years later, reverts to a one-tier board, like Suez did, or which asks its chief executive officer...
Study smarter with the SolutionInn App