Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

See the following table: STUDENT CLG_ID ST_ID ST_LNAME ST_MAJOR CLG_NAME DPT_CODE DPT_NAME DPT_PHONE ADV_LNAME ADV_OFFICE ADV_BLDG ADV_PHONE ST_GPA ST_HOURS ST_LEVEL 1 100 Stephanos Accounting Business

See the following table: STUDENT CLG_ID ST_ID ST_LNAME ST_MAJOR CLG_NAME DPT_CODE DPT_NAME DPT_PHONE ADV_LNAME ADV_OFFICE ADV_BLDG ADV_PHONE ST_GPA ST_HOURS ST_LEVEL 1 100 Stephanos Accounting Business Admin ACCT Accounting 4356 Grastrand T201 TEL Building 2115 3.87 75 L1 101 Smith 1 200 Jones Marketing 1 201 Ortiz 2 100 Stephanos Marketing Accounting 2 202 Johnson Graph Accounting Business Admin ACCT Business Admin MKTG Business Admin MKTG Arts & Sciences MATH Arts & Sciences MATH Accounting 4356 Marketing 4378 Grastrand T201 TEL Building 2115 2.78 45 LO Gentry T228 TEL Building 2123 2.31 117 L3 Marketing 4378 Tillery T356 TEL Building 2159 3.45 113 L3 Mathematics 3420 Mathematics 3420 Chen J331 Jones Building 3209 3.87 75 L1 Jackson J332 Jones Building 3210 3.42 115 L3 Field Name CLG_ID ST_ID ST_LNAME Description College ID number Student ID number ST_MAJOR CLG_NAME DPT_CODE DPT_NAME DPT_PHONE ADV_LNAME ADV_OFFICE ADV_BLDG ADV_PHONE ST_GPA ST_HOURS ST_LEVEL Student's last name Student major College name Student's department code department name department phone extension Advisor's last name Advisor's office room number Advisor's building Advisor's phone extension Student's GPA Student's completed hours Student's level Some data regarding the students in two colleges are entered into the table given in this question. However, the staff who are entering the data are complaining about the design of this table. What are some of the problems you can identify? Which one of the following anomalies can be identified in this table and why? Insertion anomaly Deletion anomaly Modification anomaly

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions

Question

=+1. What is the total price and per share price of a deal?

Answered: 1 week ago