The sample data provided below for a student helper scheduling database is included in one table Put the data in this table into 3 rd normal form (3NF) Functional Dependencies are StudentID Student name, topic HelperID Helper email SessionID date, room, student, helper, book used is just an arrow SessionID StudentID StudentName Date Topic HelperID Room Book HelperEmail S1 St1 Smith 2 6 FIN Tut1 629 Deumlich tut1 fhbb ch S2 St1 Smith 3 7 SQL Tut3 631 Kroenke Tut3 fhbb ch S4 St4 Jones 2 9 FIN Tut1 629 Deumlich tut1 fhbb ch S3 St2 Davis 2 10 ACC Tut3 632 Deumlich Tut3 fhbb ch S5 St2 Davis 3 1 SQL Tut5 621 Kroenke Tut5 fhbb ch

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

Question: The sample data provided below for a student-helper scheduling database is included in one table. Put the data in this table into 3 rd normal

The sample data provided below for a student-helper scheduling database is included in one table. Put the data in this table into 3^rd normal form (3NF).

Functional Dependencies are:

StudentID -> Student name, topic

HelperID ->Helper email

SessionID -> date, room, student, helper, book used

-> is just an arrow.

SessionID	StudentID	StudentName	Date	Topic	HelperID	Room	Book	HelperEmail
S1	St1	Smith	2/6	FIN	Tut1	629	Deumlich	tut1@fhbb.ch
S2	St1	Smith	3/7	SQL	Tut3	631	Kroenke	Tut3@fhbb.ch
S4	St4	Jones	2/9	FIN	Tut1	629	Deumlich	tut1@fhbb.ch
S3	St2	Davis	2/10	ACC	Tut3	632	Deumlich	Tut3@fhbb.ch
S5	St2	Davis	3/1	SQL	Tut5	621	Kroenke	Tut5@fhbb.ch

Step by Step Solution

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!

Normalize the following draw [or write them in the standard format] the set of tables that puts these into 3NF. The sample data provided below for a student-tutor scheduling database is included in...

Identify functional dependencies. (These are your business rules-in this case, you will want to make those rules by looking the data-some questions include - How will you identify customers, works of...

Page. 1 210.02 Lab 210.02 Data Normalization Lab (Revised 2/11/04) Data Normalization Basics This exercise consists of two exercises that will demonstrate your ability to normalize data using the...

Topic : Database, IT Part A The Security office at College X keeps a list of parking tickets which have been issued to vehicles parked illegally on the campuses. This is the portion of the table for...

Introduction to Coursework You are part of a consultancy company that specialises in the provision of database applications. The Director of FastCabs has recently approached your company to undertake...

From the case study below answer Task 1-3 Whenever a customer makes a booking on the web page, they must enter their customer details. A new customer will automatically be assigned an account number,...

From the case study below answer Tasks 1-3 Whenever a customer makes a booking on the web page, they must enter their customer details. A new customer will automatically be assigned an account...

1. Introduction to Computer Architecture concepts; The MIPS R2000 architecture allows for up to four external coprocessors. Our local systems arIPS external coprocessors are used by describing, in...

1 This executable program is installed with MongoDB and it is used to import data into a MongoDB database. a . Document import b . Mongoimport c . Database import d . MongoDB import 2 How would you...

A large, cylindrical roll of tissue paper of initial radius R lies on a long, horizontal surface with the outside end of the paper nailed to the surface. The roll is given a slight shove (vi 0) and...

Your client has systematically contributed $3000 to her RRSP at the beginning of every three months for the past 17 years. If the RRSP has earned 8.8% compounded quarterly, what is its value today?...

1 5 - 3 Would it ever be rational for a firm to borrow money in order to pay cash dividends? Explain.

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

2. What potential barriers would you encourage Samuel to avoid?

6. How would you design your ideal position?

1. What do you know about Samuels career anchors that would make this a good choice for him?