Kelsey wants to create queries to answer management questions from a relational database she does not have much experience with.  Why might a Relationships report help her create the queries?

What will be an ideal response?


A Relationship report would show her how the relational database is designed and includes table names, field names, primary key fields, and one-to-many relationships.  This is information that is helpful when creating queries given a query often requires that you select fields from multiple tables.  Therefore, she first needs to know the field names, tables, and how the tables are related  in order to select the fields you want for the query.  The less familiar she is with the database, the more valuable the Relationship report is in explaining how it is structured.

Computer Science & Information Technology

You might also like to view...

What is a default constructor? When does a class not have a default constructor?

What will be an ideal response?

Computer Science & Information Technology

Which of the following devices is NOT limited to a single app store?

A. Android phone B. iPhone C. iPad D. Windows phone

Computer Science & Information Technology

When an application begins by searching a binary tree, it starts at

a. the outermost leaf node b. the middle node, halfway between the root and the longest branch c. the rightmost child of the root node d. the root node e. None of these

Computer Science & Information Technology

Most databases can import electronic data from other software applications

Indicate whether the statement is true or false

Computer Science & Information Technology