Author Question: What is a dependency graph, and what is it used for in database redesign? What will be an ideal ... (Read 84 times)

Alainaaa8 · **on:** Jul 7, 2018

What is a dependency graph, and what is it used for in database redesign?

What will be an ideal response?

Question 2

The MySQL transaction isolation level can be manually set using a MySQL SET SCOPE TRANSACTION ISOLATION LEVEL LEVEL OPTION command.

Indicate whether the statement is true or false

zacnyjessica · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

Dependency graphs are not a graphical display like a bar chart, but rather a set of connected nodes. The nodes represent objects such as tables, view, triggers, stored procedures, etc., in the database. Line segments show the interconnections, or dependencies, between these objects. Thus, a dependency graph is useful for determining how a change to one object in a database might affect other objects in the database.

Answer to Question 2

TRUE