Question: Please normalize this table up to 3 normal form. You need to explain the steps of normalization by showing functional dependencies and show the final

Please normalize this table up to 3 normal form. You need to explain the steps of normalization by showing functional dependencies and show the final normalized tables.

(Ex. Sname Saddress, Sphone ) ** Note : without any explanation, showing the final tables will get partial credits. No proper steps -15; Incorrect steps - 1~4 per each; Incorrect final tables (missing table -5/each)

STU_NUM

STU_LNAME

STU_MAJOR

DEPT_CODE

DEPT_NAME

DEPT_PHONE

COLLEGE_NAME

ADVISOR_LNAME

ADVISOR_OFFICE

ADVISOR_BLDG

ADVISOR_PHONE

STU_GPA

STU_HOURS

STU_CLASS

211343

Stephanos

Accounting

ACCT

Accounting

4356

Business Admin

Grastrand

T201

Torre Building

2115

3.87

Junior

200128

Smith

Accounting

ACCT

Accounting

4356

Business Admin

Grastrand

T201

Torre Building

2115

2.78

Sophomore

199876

Jones

Marketing

MKTG

Marketing

4378

Business Admin

Gentry

T228

Torre Building

2123

2.31

117

Senior

199886

Ortiz

Marketing

MKTG

Marketing

4378

Business Admin

Tillery

T356

Torre Building

2159

3.45

113

Senior

223456

McKulski

Statistics

MATH

Mathematics

3420

Arts & Sciences

Chen

J331

Jones Building

3209

3.58

Junior

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!

Please normalize this table up to 3 normal form. You need to explain the steps of normalization by showing functional dependencies and show the final normalized tables. (Ex. Sname Saddress, Sphone )...

Please normalize this table up to 3 normal form. You need to show functional dependencies. (Ex. Sname --> Saddress) Proj_num Proj_name Emp_num Emp_name Job_class Chg_hour Hours 15 Evergreen 103 June...

1. Please normalize this table up to the 3rd normal form. You need to explain the steps of normalization by showing functional dependencies and show the final normalized tables. [25 points] (Ex....

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...

I need some assistance with my project proposal and its overview, my systems analysis and entity-relation diagram(ERD) and overall database creation. I am using Microsoft Visio and MS SQL 2012 as...

Assignment 1. You recognize that the existing table structure is very poor and need to improve it. Given what you see in the table above, a) Draw a dependency diagram. Identify the possible primary...

Database Design Problem You have been hired to review the accuracy of the books of Northeast Seasonal Jobs International (NSJI), a job broker. NSJI matches employers whose business is seasonal (like...

Dear Tutor, Attached please find my assignment. Could you help me? Thanks in advance . Database Design Problem You have been hired to review the accuracy of the books of Northeast Seasonal Jobs...

PART II - Normalizing to 3NF For each question, identify the current normal formUNF, INF, 2NF, 3NF, generate a few business rules functional dependencies). Then normalize the tables into 3NF. .You...

Given the relation below (note that there is a composite primary key in this relation): (PrescriptionNumber, PatientID, Date, Drug, Dosage, PrescriberID, PrescriberName, PatientName) Answer the...

Sierra Foxtrot Airport called for tenders for supplies of green seed for its runway surrounds, with a closing date of 1 June. The following tenders were submitted: Green Grow hand-delivered its...

Let P, denote the plaintiff's assessment of her probability of winning at trial, and P denote the defendant's assessment of this same probability. In other words, Pa is the defendant's assessment of...

Question 3 ( 1 point ) With an unlimited amount of funds, a firm could accept all positive NPV projects. However, with limited budgets, managers are forced to accept some positive NPV projects while...

The beginning and ending balances of retained earnings for the year were $81,000 and $94,500, respectively. If dividend payments made during the year were $8,100, determine the net income or net loss...

KEY QUESTION What are governments fiscal policy options for ending severe demand-pull inflation? Use the aggregate demandaggregate supply model to show the impact of these policies on the price...

KEY QUESTION Suppose that the aggregate demand and supply schedules for a hypothetical economy are as shown below: Amount of Amount of Real GDP Real GDP Demanded, Price Level Supplied, Billions...

KEY QUESTION The data in columns 1 and 2 in the accompanying table are for a private closed economy: a. Use columns 1 and 2 to determine the equilibrium GDP for this hypothetical economy. b. Now open...