Because of the need to know the functional dependencies in a database,it is a good idea to create a(n)________.
A)conceptual schema
B)internal schema
C)dependency graph
D)table-relationship diagram

Question

Quizplus · Accepted Answer

A dependency graph is a visual representation of the functional dependencies in a database, and can aid in identifying potential issues with normalization and data integrity. A conceptual schema defines the high-level conceptual model of a database, an internal schema defines the physical organization of the data on the storage medium, and a table-relationship diagram is focused on visualizing the relationships between tables in a database. While all of these may be useful in understanding a database, a dependency graph is the best choice for analyzing and understanding functional dependencies.

Because of the Need to Know the Functional Dependencies in a Database,it