Problem 3: Normalization Consider the following table: STU_NUM STU_LNAME STU_MAJOR DEPT_CODE DEPT_NAME DEPT_PHONE 211343 Sanders Finance, Statistics АССT Accounting 4356 200128 Smith Accounting АССТ...

Problem 3: Normalization<br>Consider the following table:<br>STU_NUM<br>STU_LNAME<br>STU_MAJOR<br>DEPT_CODE<br>DEPT_NAME<br>DEPT_PHONE<br>211343<br>Sanders<br>Finance, Statistics<br>АССT<br>Accounting<br>4356<br>200128<br>Smith<br>Accounting<br>АССТ<br>Accounting<br>4356<br>Marketing,<br>Accounting<br>199876<br>Jones<br>MKTG<br>Marketing<br>4378<br>199913<br>Ortiz<br>Mathematics<br>МАТH<br>Mathematics<br>3420<br>223456<br>Smith<br>Statistics<br>МАТН<br>Mathematics<br>3420<br>STU_NUM> (STU_LNAME, STU_MAJOR)<br>DEPT_CODE-> (DEPT_NAME, DEPT_PHONE)<br>1) The table is susceptible to anomalies. Provide examples of insertion, deletion, and update anomalies<br>2) Describe and illustrate the process of normalizing the table into 3NF<br>

Extracted text: Problem 3: Normalization Consider the following table: STU_NUM STU_LNAME STU_MAJOR DEPT_CODE DEPT_NAME DEPT_PHONE 211343 Sanders Finance, Statistics АССT Accounting 4356 200128 Smith Accounting АССТ Accounting 4356 Marketing, Accounting 199876 Jones MKTG Marketing 4378 199913 Ortiz Mathematics МАТH Mathematics 3420 223456 Smith Statistics МАТН Mathematics 3420 STU_NUM> (STU_LNAME, STU_MAJOR) DEPT_CODE-> (DEPT_NAME, DEPT_PHONE) 1) The table is susceptible to anomalies. Provide examples of insertion, deletion, and update anomalies 2) Describe and illustrate the process of normalizing the table into 3NF

Jun 08, 2022

SOLUTION.PDF

Problem 3: Normalization Consider the following table: STU_NUM STU_LNAME STU_MAJOR DEPT_CODE DEPT_NAME DEPT_PHONE 211343 Sanders Finance, Statistics АССT Accounting 4356 200128 Smith Accounting АССТ...

Get Answer To This Question

Related Questions & Answers

Submit New Assignment