HomeworkLib
Question

Update anomaly. Which of the following constitutes a possible update anomaly that could occur in this...

Update anomaly. Which of the following constitutes a possible update anomaly that could occur in this table in its current state? StudentID StudentName CourseNo CourseName 56 Barnes 58 McCormick 58 McCormick 72 Bielinski 200 Marketing 100 Accounting 200 Marketing 300 Finance. a. When McCormick changes her last name the only record associated with marketing is changed. b. When Barnes changes her last name the only record associated with marketing is changed. c. When Barnes leaves the course, we loose the data for the marketing course.

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1 
There are two records in the table that belongs to person McCormick.

So, If we change last name of McCormick in one row (marketing) then we have to update the other row also.
If we don't update the second row of McCormick then it will lead to update anomaly.

So, Answer is 
When McCormick changes her last name the only record associated with marketing is changed, then there

a. When McCormick changes her last name the only record associated with marketing is changed.

0 0
Add a comment
Know the answer?
Add Answer to:
Update anomaly. Which of the following constitutes a possible update anomaly that could occur in this...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • In this exercise, we will re-visit the case study “A day in the life” at the...

    In this exercise, we will re-visit the case study “A day in the life” at the end of Chapter 1. Answer these questions: 1- Based on the information provided in the case, what kind of project management structure you think this organization uses? 2- What conclusions can you draw about the organization culture? Use dimensions introduced in Chapter 3 to support your answer. Case study: A Day in the Life Rachel The project manager of a large information systems project...

  • And there was a buy-sell arrangement which laid out the conditions under which either shareholder could...

    And there was a buy-sell arrangement which laid out the conditions under which either shareholder could buy out the other. Paul knew that this offer would strengthen his financial picture…but did he really want a partner?It was going to be a long night. read the case study above and answer this question what would you do if you were Paul with regards to financing, and why? ntroductloh Paul McTaggart sat at his desk. Behind him, the computer screen flickered with...

  • Luisa Fernandez pulled into a parking spot behind one of Superado’s stores on the outskirts of Seville but paused before...

    Luisa Fernandez pulled into a parking spot behind one of Superado’s stores on the outskirts of Seville but paused before getting out of the car. This was usually the best part of her week—visiting one of her company’s supermarkets, talking to the store manager, walking through the aisles, watching employees interact with the customers. She’d been doing it since she was a little girl, tagging along with her father as he grew his business from one small market in central...

  • Discussion questions 1. What is the link between internal marketing and service quality in the ai...

    Discussion questions 1. What is the link between internal marketing and service quality in the airline industry? 2. What internal marketing programmes could British Airways put into place to avoid further internal unrest? What potential is there to extend auch programmes to external partners? 3. What challenges may BA face in implementing an internal marketing programme to deliver value to its customers? (1981)ǐn the context ofbank marketing ths theme has bon pururd by other, nashri oriented towards the identification of...

  • Q1 Which of the following are included and which are excluded in calculating this year's GDP....

    Q1 Which of the following are included and which are excluded in calculating this year's GDP. Explain in each instance. a. A monthly scholarship cheque received by an economics student b. The purchase of an almost new tractor by farmer Kojo C. The cashing in of a savings bond d. An increase in business inventories e. Tim Horton's purchases a corner grocery store f. Fearless Qweenie Kong, a stuntwoman, purchases a life insurance policy for a billion dollars ($) g....

  • Cloud 9 - Continuing Case Sharon Gallagher and Josh Thomas have assessed the internal controls at...

    Cloud 9 - Continuing Case Sharon Gallagher and Josh Thomas have assessed the internal controls at Cloud 9 as being effective at an entity level. This means that, at a high level, the company demonstrates an environment where potential material misstatements are prevented or detected. Answer the following questions based on the information presented for Cloud 9 in the appendix to this text and the current and earlier chapters. You should also consider your answers to the case-study questions in...

  • 39. Cash was paid by Janer's Cleaning Service to creditors on account. Which of the following...

    39. Cash was paid by Janer's Cleaning Service to creditors on account. Which of the following entries for Janer's Cleaning Service records this transaction? a. Cash, debit; Debbi Janer, Capital, credit b. Accounts Payable, debit; Cash, credit c. Accounts Receivable, debit; Cash, credit d. Accounts Payable, debit; Accounts Receivable, credit 40. Which of the following statements is not true about liabilities? a. Liabilities are debts owed to outsiders. b. Account titles of liabilities often include the term "payable." e. Cash...

  • St. Francis Assisted Living Facility St. Francis Medical Center, a 450 bed rehabilitation non-profit hospital began...

    St. Francis Assisted Living Facility St. Francis Medical Center, a 450 bed rehabilitation non-profit hospital began to see a significant decline in admissions. St. Francis' mission focuses on inpatient and outpatient rehabilitation of the severely injured and catastrophically ill. While the patient census varied from month to month, it appeared to the St. Francis Board of Trustees that the inpatient population was slowly but steadily declining. The hospital's market researchers reported that fewer people were being severely injured due to...

  • Comprehensive Income Tax Course: Module 1 4. Randy turned 16 last year and had his first...

    Comprehensive Income Tax Course: Module 1 4. Randy turned 16 last year and had his first summer job. Even though his parents are claiming him as a dependent he wants to file a return in order to get his refund. He receives his W-2 and decides he can do his own return using form 1040-EZ. Which of the following information is not found on a Form W-2? a) The taxpayer’s Social Security number b) The taxpayer’s wages, tips and other...

  • Hello, If anyone can help me I will grestly appreciate it! I will also give a...

    Hello, If anyone can help me I will grestly appreciate it! I will also give a thumbs up! Autotech Manufacturing is engaged in the production of replacement parts for automobiles. One plant specializes in the production of two parts: Part 127 and Part 234. Part 127 produces the highest volume of activity, and for many years it was the only part produced by the plant. Five years ago, Part 234 was added. Part 234 was more difficult to manufacture and...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT