Exam 6: Data Flow Diagramming

Both DFDs and flowcharts are concerned with:

Which of the following partial data flow diagrams has a poorly defined system boundary?

In a data flow diagram, "retrieve inventory from warehouse" would be represented by:

In a data flow diagram, a(n) ___ process has been decomposed as much as possible.

-The primary key from the ___ table would be posted as a foreign key in the ___ table.

In a data flow diagram, a circle represents:

-Which process would most likely need to be exploded?

In designing an accounting information system, a data flow diagram can help with: (i) database construction, (ii) communication.

In a leveled set of data flow diagrams, which of the following is most likely to be a primitive process?

Bill and Lisa are trying to understand how sales invoices are processed in their client's accounting information system. Which of the following would be most helpful?

Data flow diagram and flowchart comparison Indicate whether each of the statements applies to: (a) data flow diagrams only, (b) flowcharts only, (c) both data flow diagrams and flowcharts or (d) neither data flow diagrams nor flowcharts. ______ 1. "Marketing department" and "customer" denoted by rectangles. ______ 2. Column headings read "marketing department" and "customer". ______ 3. Contains four different symbol types. ______ 4. Document is read from left to right. ______ 5. Incorporates more than four symbol types. ______ 6. Line is labeled "send data to accounting". ______ 7. Processing tools, such as computers, are clearly indicated. ______ 8. Rectangle is labeled "1.0: assemble raw materials". ______ 9. Spans more than one page. ______ 10. Vendor database is represented by two parallel lines.

Database table design Several independent statements regarding database table design appear below. Indicate the highest normal form that applies to each statement: (a) first normal form, (b) second normal form, (c) third normal form or (d) not in any normal form. ______ 1. A sales staff/automobile table connects two tables: one with data about automobiles, the other with data about sales staff. ______ 2. All columns depend on the table's primary key. ______ 3. An "automobile" table contains the name of the sales staff member with the greatest dollar sales for the month. ______ 4. An inventory table contains the following fields: item number, item description, beginning inventory quantity, average cost of beginning inventory, beginning inventory date. ______ 5. Customer table contains information about sales transactions. ______ 6. Each record in a sales table contains four fields: transaction number, transaction date, customer name and sales staff name. Each student is paired with a single advisor; an advisor's name appears more than once in a table. ______ 7. Redundant data does not appear in the table. ______ 8. The sales table contains one field for accounts debited and credited. ______ 9. The table eliminates repeating groups.

Which of the following symbols would you find in a flowchart, but not in a data flow diagram?

-Which symbol above would be represented in a data flow diagram with two parallel lines?

-Which of the following statements is least true?

All of the following violate the rules for preparing data flow diagrams except:

Piper's firm typically uses flowcharts to document business processes. Explain two similarities and two differences between data flow diagrams and systems flowcharts.

-Which symbol above would be represented in a data flow diagram with an arrow?

A process labeled "Update employee information" has "employee information" flowing into it and nothing flowing out. Which of the following is most true?