Part A: Write 100-200 words per item below, explaining how each of the following approaches for updating the data in your database works, and its corresponding pros and cons.UpsertAppendDrop and ReplacePart B: Select one of the answers to the multiple-choice question below, and write 100-200 words explaining why you believe this is the correct answer:You are running a database for a University and need to perform regular updates on the database from an athletic association roster of students who are on sports teams. The roster can change week to week, and as such you need to have the data update once per week. Which method is best for bringing this new roster data into the tables within your database:UpsertAppendDrop & Replace

In the context of maintaining a University database with weekly updates of athletic association…

Answered: art A: Write 100-200 words per item…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Part A: Write 100-200 words per item below, explaining how each of the following approaches for updating the data in your database works, and its corresponding pros and cons.

Upsert
Append
Drop and Replace

Part B: Select one of the answers to the multiple-choice question below, and write 100-200 words explaining why you believe this is the correct answer:

You are running a database for a University and need to perform regular updates on the database from an athletic association roster of students who are on sports teams. The roster can change week to week, and as such you need to have the data update once per week. Which method is best for bringing this new roster data into the tables within your database:
1. Upsert
2. Append
3. Drop & Replace

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions