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 report about your solution A table with the students and their grades in different topics UnitID StudentID Date TutorID Topic Room Grade Book TutEmail U1 St1 23 02 03 Tut1 GMT 629 4 7 Deumlich tut1 fhbb ch U2 St1 18 11 02 Tut3 GIn 631 5 1 Zehnder tut3 fhbb ch U1 St4 23 02 03 Tut1 GMT 629 4 3 Deumlich tut1 fhbb ch U5 St2 05 05 03 Tut3 PhF 632 4 9 Dmmlers tut3 fhbb ch U4 St2 04 07 03 Tut5 AVQ 621 5 0 SwissTopo tut5 fhbb ch

The Answer is in the image, click to view...

Question: 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

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 report about your solution.

A table with the students and their grades in different topics.

UnitID	StudentID	Date	TutorID	Topic	Room	Grade	Book	TutEmail
U1	St1	23.02.03	Tut1	GMT	629	4.7	Deumlich	tut1@fhbb.ch
U2	St1	18.11.02	Tut3	GIn	631	5.1	Zehnder	tut3@fhbb.ch
U1	St4	23.02.03	Tut1	GMT	629	4.3	Deumlich	tut1@fhbb.ch
U5	St2	05.05.03	Tut3	PhF	632	4.9	Dümmlers	tut3@fhbb.ch
U4	St2	04.07.03	Tut5	AVQ	621	5.0	SwissTopo	tut5@fhbb.ch

Step by Step Solution

★★★★★

3.32 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock 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 Databases Questions!

The following table is from Exercise 5.23 classifying auto accidents by survival status (S = survived, D = died) and seat belt status of the individual involved in the accident. a. Estimate the...

Write a short report on Human resource management issue (some example of issue is shown below). In the report, you should only highlight the issues at hand.. Your choice of issues may be one from the...

The only information given for the following table is that the equilibrium exchange rate is 5 Egyptian pounds per U.S. dollar. Fill in the blank cells, constructing quantity demanded and quantity...

Operating budgets: materials purchasing plan Masefield Dairy is preparing a third-quarter budget (July, August, and September) for its ice cream products. It produces five brands of ice cream, and...

Shanks Inc., a nationwide advertising firm, wants to know whether the size of an advertisement and the color of the advertisement make a difference in the response of magazine readers. A random...

The Journal of Accountancy has published a series of articles that address different aspects of disaster recovery and business continuity planning: 1. Gerber, J. A., and Feldman, E. R. 2002. Is Your...

Exercises in compound interest, no income taxes. To be sure that you understand how to use the tables in Appendix B at the end of this book, solve the following exercises. Ignore income tax...

The Aubey Coffee Company is evaluating the within-plant distribution system for its new roasting, grinding, and packing plant. The two alternatives are (1) A conveyor system with a high initial cost...

Banks earn money by borrowing from depositors at low interest rates and lending to individuals and businesses at high interest rates. As banks grow, they split into functional divisions that either...

Sam and Suzy Sizeman need to prepare a cash budget for the last quarter of 2013 to make sure they can cover their expenditures during the period. Sam and Suzy have been preparing budgets for the past...

The Golden Gate Bridge in San Francisco has a main span of length 1.28 kmone of the longest in the world. Imagine that a taut steel wire with this length and a cross-sectional area of 4.00 X 10-6 m2...

(1) (ii) GCB Bank wishes to make some donations to academic institutions. One of the Directors of the Directors of GCB Bank is an ex-student of GIMPA. After consultation, it is decided that GCB Bank...

10. Consider the unity feedback control system in Figure 7.62 where L(s) =G(s)G(s)= 10(s+ z) s(s+4s+8) Using the root locus method, determine that maximum value of z for closed-loop stability. a. z =...

A company that leases trucks to other companies collect information on total miles driven (100,000 miles) and total maintenance cost (in thousand dollars) for each of 10 trucks in their rental fleet....

John is considering the purchase of a lot. He can buy the lot today and expects the price to rise to $15,000 at the end of 10 years. He believes that he should earn an investment yield of 8 percent...

Prove cos x = x for some x E (-? 2' 2

The Eubanks Corporation held the following potentially dilutive contracts at some point during the fiscal year ended December 31, YR7: Par/Face Amount $2,000,000 $3,000,000 8% convertible bonds...

Cash Flow Worksheet HW CHEE 442 Due 10/2 Done individually Problem statement: The balance sheet for a proposed project reveals a fixed capital investment of $350M. Annual total project expenses are...

paraphrased Weed Control Weed pressure is minimal due to the tunnel system and wick boxes. Manual removal is done occasionally, especially around the base of tunnels and walkways. Pruning and...

PROJECT SCOPE [Instructions for what to include in this section: Define the scope of work that will be undertaken to provide the deliverable(s) mentioned in the Project Charter (PC). Craft this...

Information for guestions 1.10 A country assembles cans using parts imported from the rest of the world. This country moses starim of 20% on imported already sented car and writo 375 on the imported...

My teacher edited my project with red comments and I am struggling with how to correct those mistakes within my project. The Goldsteins Risk Management and Insurance portfolio Table of Contents Page...

In this analysis, you will discuss the financial health of two companies (ZCL and Linamar) with the ultimate goal of recommending one of the companies to an investor. Your paper should consist of the...

1. Using the regression line to make predictions about Y Suppose you are interested in the relationship between foster care and incarceration for young adults who have been involved in the juvenile...

Recall in the one sample hypothesis testing scenario that we investigated the following presumptions based on previous research, "no evidence currently exists supporting or refuting the use of...