Deck 8: Data Flow Diagramming

Question 1

Refer to the illustrations below as you answer the question: If the partial flowchart were converted to a data flow diagram, which of the following would most closely represent it?

A)Diagram A
B)Diagram B
C)Diagram C
D)Diagram D

Answer 1

A

Question 2

Pablo had been asked by his supervisor to create a document explaining the process of paying an invoice.Based on research results reported by Bradford et al.:

A)he is more likely to create a flowchart than a data flow diagram.
B)he is more likely to create a data flow diagram than a flowchart.
C)he is highly likely to use some form of information technology to complete the task.
D)he is highly unlikely to use some form of information technology to complete the task.

Answer 2

A

Question 3

A circle in a data flow diagram represents:

A)A data flow
B)An external entity
C)A database
D)A business process

Answer 3

D

Question 4

Which of the following is most likely to be represented with a rectangle in a data flow diagram?

A)Customer file
B)Bank
C)Deposited checks
D)Any of these

Question 5

Please refer to the following short case as you respond to the question: A painter accepts orders for original works from customers in person or via the Internet.Based on the order, the painter creates an initial sketch, which must be approved by the customer; the customer may make changes to the initial sketch.After customer approval, the painter selects appropriate materials and gives the customer a price quote.If the customer accepts the price quote, the painter creates the original work; if not, the project is abandoned.The painter stores data about customers, previous orders and previously completed works in an electronic database.Data flow diagrams incorporate four symbols.Which of the following pairs of items would be represented with the same symbol in a DFD of the case?

A)Painter, customer
B)Initial sketch, price quote
C)Customer, initial sketch
D)Painter, price quote

Question 6

Please refer to the following short case as you respond to the question: A painter accepts orders for original works from customers in person or via the Internet.Based on the order, the painter creates an initial sketch, which must be approved by the customer; the customer may make changes to the initial sketch.After customer approval, the painter selects appropriate materials and gives the customer a price quote.If the customer accepts the price quote, the painter creates the original work; if not, the project is abandoned.The painter stores data about customers, previous orders and previously completed works in an electronic database.In a data flow diagram of the case, "create initial sketch" is most likely to be represented with a:

A)Rectangle
B)Numbered circle
C)Unnumbered circle
D)Some other symbol

Question 7

Which of the following statements about systems flowcharts and data flow diagrams is most true?

A)Processes are numbered in a flowchart, but not in a data flow diagram.
B)Processes are numbered in a data flow diagram, but not in a flowchart.
C)Processes are numbered in both flowcharts and data flow diagrams.
D)Processes are unnumbered in both flowcharts and data flow diagrams.

Question 8

Which of the following statements about systems flowcharts and data flow diagrams is most true?

A)If a systems flowchart has three columns, the leveled set of data flow diagrams should have at least four levels.
B)If one column of a systems flowchart has three process symbols, the leveled set of data flow diagrams should have a maximum of six process symbols.
C)Both if a systems flowchart has three columns, the leveled set of data flow diagrams should have at least four levels and if one column of a systems flowchart has three process symbols, the leveled set of data flow diagrams should have a maximum of six process symbols are true.
D)Neither if a systems flowchart has three columns, the leveled set of data flow diagrams should have at least four levels nor if one column of a systems flowchart has three process symbols, the leveled set of data flow diagrams should have a maximum of six process symbols is true.

Question 9

A circle in a data flow diagram may be labeled similarly to which shape in a systems flowchart?

A)A rectangle
B)An inverted triangle
C)A circle
D)Any of these

Question 10

Please refer to the following short case as you respond to the question: A painter accepts orders for original works from customers in person or via the Internet.Based on the order, the painter creates an initial sketch, which must be approved by the customer; the customer may make changes to the initial sketch.After customer approval, the painter selects appropriate materials and gives the customer a price quote.If the customer accepts the price quote, the painter creates the original work; if not, the project is abandoned.The painter stores data about customers, previous orders and previously completed works in an electronic database.In a data flow diagram of the case, "previously completed works" are most likely to be represented with a:

A)Rectangle
B)Set of parallel lines
C)Numbered circle
D)Unnumbered circle

Question 11

Which of the following is most likely to be represented with a set of parallel lines in a data flow diagram?

A)Sell product to customers
B)Customer file
C)Sold products
D)Any of these

Question 12

A line in a data flow diagram represents:

A)A data flow
B)An external entity
C)A database
D)A business process

Question 13

A systems flowchart contains two process symbols, one manual process symbol and one predefined process symbol.If that same system were depicted with a leveled set of data flow diagrams, how many circles would the context diagram have?

A)One
B)Two
C)Three
D)Four

Question 14

Please refer to the following short case as you respond to the question: A painter accepts orders for original works from customers in person or via the Internet.Based on the order, the painter creates an initial sketch, which must be approved by the customer; the customer may make changes to the initial sketch.After customer approval, the painter selects appropriate materials and gives the customer a price quote.If the customer accepts the price quote, the painter creates the original work; if not, the project is abandoned.The painter stores data about customers, previous orders and previously completed works in an electronic database.Which of the following pairs an element from the case with an appropriate symbol in a data flow diagram of the case?

A)Price quote, parallel lines
B)Initial sketch, rectangle
C)Select appropriate materials, circle
D)Painter, rectangle

Question 15

A line in a data flow diagram may be labeled similarly to which shape in a systems flowchart?

A)A line
B)A circle
C)A document symbol
D)A cylinder

Question 16

Which of the following statements about systems flowcharts and data flow diagrams is most true?

A)Lines are used in both, but they represent different things.
B)Circles are used in both, but they represent different things.
C)Both lines are used in both, but they represent different things and circles are used in both, but they represent different things are true.
D)Neither lines are used in both, but they represent different things nor circles are used in both, but they represent different things is true.

Question 17

Please refer to the following short case as you respond to the question: A painter accepts orders for original works from customers in person or via the Internet.Based on the order, the painter creates an initial sketch, which must be approved by the customer; the customer may make changes to the initial sketch.After customer approval, the painter selects appropriate materials and gives the customer a price quote.If the customer accepts the price quote, the painter creates the original work; if not, the project is abandoned.The painter stores data about customers, previous orders and previously completed works in an electronic database.A data flow diagram of the case contains three items: create initial sketch, initial sketch, finalize sketch.How are those three items likely to be represented in the data flow diagram?

A)A circle and a set of parallel lines connected by a line
B)Two circles with a set of parallel lines
C)Some other way
D)A circle and a rectangle connected by a line

Question 18

Refer to the illustrations below as you answer the question: Suppose the partial flowchart was converted to one of the data flow diagrams illustrated.Which of the following statements is most true?

A)The partial flowchart should be converted to Diagram B; the circles would be labeled "create invoice" and "update customer database."
B)The partial flowchart should be converted to Diagram C; the circle would be labeled "create invoice."
C)The partial flowchart should be converted to Diagram D; the rectangle would represent the customer database.
D)None of these statements is true.

Question 19

Pablo had been asked by his supervisor to create a document explaining the process of paying an invoice.If he wants to create a diagram that focuses on data, he could create:

A)A systems flowchart
B)A data flow diagram
C)Either a systems flowchart or a data flow diagram
D)Some other representation of the system

Question 20

Please refer to the following short case as you respond to the question: A painter accepts orders for original works from customers in person or via the Internet.Based on the order, the painter creates an initial sketch, which must be approved by the customer; the customer may make changes to the initial sketch.After customer approval, the painter selects appropriate materials and gives the customer a price quote.If the customer accepts the price quote, the painter creates the original work; if not, the project is abandoned.The painter stores data about customers, previous orders and previously completed works in an electronic database.A data flow diagram of the case includes two circles connected by a line.The three symbols are most likely to be labeled with which of the following?

A)Develop price quote, price quote, create original work
B)Create original work, original work, completed works database
C)Either develop price quote, price quote, create original work or create original work, original work, completed works database
D)Neither develop price quote, price quote, create original work nor create original work, original work, completed works database

Question 21

Refer to the Level Zero data flow diagram below and the CWM case in responding to the question: Comprehensive Waste Management (CWM) provides trash hauling services for several communities in southern California.When a new client wants to establish service, the client calls the company's main office on the phone.A CWM employee collects the following information from the client: name, street address, city, state, ZIP code, area code, telephone number, e-mail address.The employee gives the new client information regarding regular weekly service dates, special services provided by the company, fees and billing procedures.CWM bills its clients every two months in advance of the service; for example, bills are sent to clients at the beginning of January for the months of January and February.Initially, CWM does all its billing manually; they send out paper bills and collect payment from clients via check.Once service is established, a client can create an online account; the online account provides an option for paperless billing and a separate option for charging a credit card rather than paying with a mailed check.To create an online account, the client creates login credentials (user name and password); they provide their CWM account number (provided on the invoice) and relevant credit card data (type of card, name, billing address, and security code).CWM's database uses the account number to look up the client's original information, then merges the new information with it. Which of the following is most likely to be the name of Process 1.0?

A)Perform intake interview
B)Give client service information
C)Create online account
D)None of these is likely to be the name of Process 1.0.

Question 22

Refer to the Level Zero data flow diagram below and the CWM case in responding to the question: Comprehensive Waste Management (CWM) provides trash hauling services for several communities in southern California.When a new client wants to establish service, the client calls the company's main office on the phone.A CWM employee collects the following information from the client: name, street address, city, state, ZIP code, area code, telephone number, e-mail address.The employee gives the new client information regarding regular weekly service dates, special services provided by the company, fees and billing procedures.CWM bills its clients every two months in advance of the service; for example, bills are sent to clients at the beginning of January for the months of January and February.Initially, CWM does all its billing manually; they send out paper bills and collect payment from clients via check.Once service is established, a client can create an online account; the online account provides an option for paperless billing and a separate option for charging a credit card rather than paying with a mailed check.To create an online account, the client creates login credentials (user name and password); they provide their CWM account number (provided on the invoice) and relevant credit card data (type of card, name, billing address, and security code).CWM's database uses the account number to look up the client's original information, then merges the new information with it. Which of the following statements about the Level Zero data flow diagram is most true?

A)Process 1.0 is likely to be labeled "Perform intake interview."
B)Process 2.0 is likely to be labeled "Bill client and collect payment."
C)Both process 1.0 is likely to be labeled "Perform intake interview" and process 2.0 is likely to be labeled "Bill client and collect payment" are true.
D)Neither process 1.0 is likely to be labeled "Perform intake interview" nor process 2.0 is likely to be labeled "Bill client and collect payment" is true.

Question 23

Please refer to the following case as you answer the question: Comprehensive Waste Management (CWM) provides trash hauling services for several communities in southern California.When a new client wants to establish service, the client calls the company's main office on the phone.A CWM employee collects the following information from the client: name, street address, city, state, ZIP code, area code, telephone number, e-mail address.The employee gives the new client information regarding regular weekly service dates, special services provided by the company, fees and billing procedures.CWM bills its clients every two months in advance of the service; for example, bills are sent to clients at the beginning of January for the months of January and February.Initially, CWM does all its billing manually; they send out paper bills and collect payment from clients via check.Once service is established, a client can create an online account; the online account provides an option for paperless billing and a separate option for charging a credit card rather than paying with a mailed check.To create an online account, the client creates login credentials (user name and password); they provide their CWM account number (provided on the invoice) and relevant credit card data (type of card, name, billing address, and security code).CWM's database uses the account number to look up the client's original information, then merges the new information with it.CWM stores clients' information electronically.The database file would be represented in a data flow diagram with a(n):

A)Circle
B)Arrow
C)Rectangle
D)Set of parallel lines

Question 24

The generalized model of business process management discussed in the text comprises seven steps.Data flow diagrams could be used in a BPM project to: (i) select the process and define its boundaries, (ii) observe, document and map the process steps and flow, (iii) optimize the process.

A)I and II only
B)I and III only
C)II and III only
D)I, II and III

Question 25

Refer to the Level Zero data flow diagram below and the CWM case in responding to the question: Comprehensive Waste Management (CWM) provides trash hauling services for several communities in southern California.When a new client wants to establish service, the client calls the company's main office on the phone.A CWM employee collects the following information from the client: name, street address, city, state, ZIP code, area code, telephone number, e-mail address.The employee gives the new client information regarding regular weekly service dates, special services provided by the company, fees and billing procedures.CWM bills its clients every two months in advance of the service; for example, bills are sent to clients at the beginning of January for the months of January and February.Initially, CWM does all its billing manually; they send out paper bills and collect payment from clients via check.Once service is established, a client can create an online account; the online account provides an option for paperless billing and a separate option for charging a credit card rather than paying with a mailed check.To create an online account, the client creates login credentials (user name and password); they provide their CWM account number (provided on the invoice) and relevant credit card data (type of card, name, billing address, and security code).CWM's database uses the account number to look up the client's original information, then merges the new information with it. Which of the following statements about the Level Zero data flow diagram is most true?

A)Process 2.0 is likely to be labeled "Bill client and collect payment."
B)Process 3.0 is likely to be labeled "Establish online account and update data store."
C)Both process 2.0 is likely to be labeled "Bill client and collect payment" and process 3.0 is likely to be labeled "Establish online account and update data store" are true.
D)Neither process 2.0 is likely to be labeled "Bill client and collect payment" nor process 3.0 is likely to be labeled "Establish online account and update data store" is true.

Question 26

Please refer to the following case as you answer the question: Comprehensive Waste Management (CWM) provides trash hauling services for several communities in southern California.When a new client wants to establish service, the client calls the company's main office on the phone.A CWM employee collects the following information from the client: name, street address, city, state, ZIP code, area code, telephone number, e-mail address.The employee gives the new client information regarding regular weekly service dates, special services provided by the company, fees and billing procedures.CWM bills its clients every two months in advance of the service; for example, bills are sent to clients at the beginning of January for the months of January and February.Initially, CWM does all its billing manually; they send out paper bills and collect payment from clients via check.Once service is established, a client can create an online account; the online account provides an option for paperless billing and a separate option for charging a credit card rather than paying with a mailed check.To create an online account, the client creates login credentials (user name and password); they provide their CWM account number (provided on the invoice) and relevant credit card data (type of card, name, billing address, and security code).CWM's database uses the account number to look up the client's original information, then merges the new information with it.How many data stores will be shown in CWM's Level Zero data flow diagram?

A)Zero, since all the information is stored electronically
B)One, labeled "client database"
C)Two, labeled "client database" and "invoice database"
D)More than two

Question 27

Please refer to the following case as you answer the question: Comprehensive Waste Management (CWM) provides trash hauling services for several communities in southern California.When a new client wants to establish service, the client calls the company's main office on the phone.A CWM employee collects the following information from the client: name, street address, city, state, ZIP code, area code, telephone number, e-mail address.The employee gives the new client information regarding regular weekly service dates, special services provided by the company, fees and billing procedures.CWM bills its clients every two months in advance of the service; for example, bills are sent to clients at the beginning of January for the months of January and February.Initially, CWM does all its billing manually; they send out paper bills and collect payment from clients via check.Once service is established, a client can create an online account; the online account provides an option for paperless billing and a separate option for charging a credit card rather than paying with a mailed check.To create an online account, the client creates login credentials (user name and password); they provide their CWM account number (provided on the invoice) and relevant credit card data (type of card, name, billing address, and security code).CWM's database uses the account number to look up the client's original information, then merges the new information with it.How many processes will be shown in a context diagram for the CWM case?

A)Zero
B)One
C)Two
D)More than two

Question 28

Please refer to the data flow diagram below in answering the question: Which of the following statements about the data flow diagram is most true?

A)"External stakeholders" will be decomposed in subsequent levels.
B)"Ledger" must be maintained electronically.
C)Process 3.0 will be decomposed in subsequent levels.
D)All of these statements are true.

Question 29

If an accounting information system is documented with a systems flowchart:

A)It does not need to be documented with a data flow diagram.
B)It cannot be documented with a data flow diagram.
C)It may also be documented with a data flow diagram.
D)A data flow diagram would serve no practical purpose.

Question 30

Refer to the Level Zero data flow diagram below and the CWM case in responding to the question: Comprehensive Waste Management (CWM) provides trash hauling services for several communities in southern California.When a new client wants to establish service, the client calls the company's main office on the phone.A CWM employee collects the following information from the client: name, street address, city, state, ZIP code, area code, telephone number, e-mail address.The employee gives the new client information regarding regular weekly service dates, special services provided by the company, fees and billing procedures.CWM bills its clients every two months in advance of the service; for example, bills are sent to clients at the beginning of January for the months of January and February.Initially, CWM does all its billing manually; they send out paper bills and collect payment from clients via check.Once service is established, a client can create an online account; the online account provides an option for paperless billing and a separate option for charging a credit card rather than paying with a mailed check.To create an online account, the client creates login credentials (user name and password); they provide their CWM account number (provided on the invoice) and relevant credit card data (type of card, name, billing address, and security code).CWM's database uses the account number to look up the client's original information, then merges the new information with it. Based on the Level Zero data flow diagram, which of the following statements about the context diagram is most true?

A)The client database will not be shown in the context diagram.
B)The external entity "client" must have at least three data flows coming out of it.
C)The external entity "client" must have at least one data flow going into it.
D)All of these statements are true.

Question 31

Data flow diagrams can be used for: (i) completing the steps in the accounting cycle, (ii) making business processes more efficient and effective, (iii) completing one or more steps of the systems development life cycle.

A)I and II only
B)I and III only
C)II and III only
D)I, II and III

Question 32

Please refer to the following case as you answer the question: Comprehensive Waste Management (CWM) provides trash hauling services for several communities in southern California.When a new client wants to establish service, the client calls the company's main office on the phone.A CWM employee collects the following information from the client: name, street address, city, state, ZIP code, area code, telephone number, e-mail address.The employee gives the new client information regarding regular weekly service dates, special services provided by the company, fees and billing procedures.CWM bills its clients every two months in advance of the service; for example, bills are sent to clients at the beginning of January for the months of January and February.Initially, CWM does all its billing manually; they send out paper bills and collect payment from clients via check.Once service is established, a client can create an online account; the online account provides an option for paperless billing and a separate option for charging a credit card rather than paying with a mailed check.To create an online account, the client creates login credentials (user name and password); they provide their CWM account number (provided on the invoice) and relevant credit card data (type of card, name, billing address, and security code).CWM's database uses the account number to look up the client's original information, then merges the new information with it.Which of the following data flow diagram levels provides the highest level view of the CWM information system?

A)Context
B)Level Zero
C)Level One
D)Some other level

Question 33

A data flow diagram can be used:

A)Instead of a systems flowchart in AIS work.
B)In addition to a systems flowchart in AIS work.
C)Both instead of a systems flowchart in AIS work and in addition to a systems flowchart in AIS work.
D)Neither instead of a systems flowchart in AIS work nor in addition to a systems flowchart in AIS work.

Question 34

Please refer to the data flow diagram below in answering the question: The preceding data flow diagram is:

A)A context diagram of the accounting cycle.
B)A Level Zero diagram of the accounting cycle.
C)A Level Zero diagram of the transaction analysis process.
D)A Level One diagram of the transaction analysis process.

Question 35

Please refer to the following case as you answer the question: Comprehensive Waste Management (CWM) provides trash hauling services for several communities in southern California.When a new client wants to establish service, the client calls the company's main office on the phone.A CWM employee collects the following information from the client: name, street address, city, state, ZIP code, area code, telephone number, e-mail address.The employee gives the new client information regarding regular weekly service dates, special services provided by the company, fees and billing procedures.CWM bills its clients every two months in advance of the service; for example, bills are sent to clients at the beginning of January for the months of January and February.Initially, CWM does all its billing manually; they send out paper bills and collect payment from clients via check.Once service is established, a client can create an online account; the online account provides an option for paperless billing and a separate option for charging a credit card rather than paying with a mailed check.To create an online account, the client creates login credentials (user name and password); they provide their CWM account number (provided on the invoice) and relevant credit card data (type of card, name, billing address, and security code).CWM's database uses the account number to look up the client's original information, then merges the new information with it.CWM's manual billing process will be represented in a data flow diagram with a(n):

A)Circle
B)Arrow
C)Rectangle
D)Set of parallel lines

Question 36

Please refer to the following case as you answer the question: Comprehensive Waste Management (CWM) provides trash hauling services for several communities in southern California.When a new client wants to establish service, the client calls the company's main office on the phone.A CWM employee collects the following information from the client: name, street address, city, state, ZIP code, area code, telephone number, e-mail address.The employee gives the new client information regarding regular weekly service dates, special services provided by the company, fees and billing procedures.CWM bills its clients every two months in advance of the service; for example, bills are sent to clients at the beginning of January for the months of January and February.Initially, CWM does all its billing manually; they send out paper bills and collect payment from clients via check.Once service is established, a client can create an online account; the online account provides an option for paperless billing and a separate option for charging a credit card rather than paying with a mailed check.To create an online account, the client creates login credentials (user name and password); they provide their CWM account number (provided on the invoice) and relevant credit card data (type of card, name, billing address, and security code).CWM's database uses the account number to look up the client's original information, then merges the new information with it.Assume CWM wants no more than three processes shown on its Level Zero data flow diagram.All of the following are likely to be processes except:

A)Perform intake interview
B)Bill client and collect payment
C)Establish online account
D)Update client database

Question 37

Data flow diagrams can be used in which of the following steps of the systems development life cycle: (i) requirements analysis, (ii) design, (iii) implementation.

A)I and II only
B)I and III only
C)II and III only
D)I, II and III

Question 38

Accounting information systems have five generic elements.A data flow diagram would be least helpful for which of the five?

A)Processes
B)Outputs
C)Storage
D)Internal control

Question 39

Please refer to the data flow diagram below in answering the question: In the next level of data flow diagrams, Process 3.1 is most likely to be labeled:

A)Record adjusting entries.
B)Prepare financial statements.
C)Close nominal accounts.
D)Complete first step of year-end work.

Question 40

Please refer to the data flow diagram below in answering the question: In the next level of data flow diagrams:

A)Process 1.0 could be decomposed into two steps.
B)Process 3.0 can only be decomposed if both the other processes are.
C)Additional data stores are likely to appear.
D)The data flows "financial statements" and "account balances" can be combined.

Question 41

Booksellers of Bufluffia is a small, independent bookstore that both publishes and sells very specialized titles.They currently have about 50 clients; they publish and sell 30 different books at present.The company's management has asked you to create database tables to support their operations.If the database includes a sales/inventory junction table, its primary key is most likely to be:

A)The same as the primary key of the sales table.
B)The same as the primary key of the inventory table.
C)A compound primary key.
D)None of these

Question 42

"Diagram Y" is:

A)a decomposition of Diagram X
B)balanced with Diagram X
C)both a decomposition of Diagram X and balanced with Diagram X
D)neither a decomposition of Diagram X nor balanced with Diagram X

Question 43

Consider the following illustration as you respond to the questions: Which of the following is the most appropriate symbol for "qualified applicants database?"

A)circle
B)set of parallel lines
C)database cylinder
D)rectangle

Question 44

Booksellers of Bufluffia is a small, independent bookstore that both publishes and sells very specialized titles.They currently have about 50 clients; they publish and sell 30 different books at present.The company's management has asked you to create database tables to support their operations.If the database includes a "sales" table, its primary key is most likely to be:

A)Transaction date
B)Client name
C)Transaction number
D)Total revenue earned

Question 45

Booksellers of Bufluffia is a small, independent bookstore that both publishes and sells very specialized titles.They currently have about 50 clients; they publish and sell 30 different books at present.The company's management has asked you to create database tables to support their operations.Suppose the database includes four tables: clients, inventory, sales and sales/inventory.In which table would you expect to see a field titled "total amount billed?"

A)Clients table
B)Sales table
C)Sales/inventory table
D)None of these

Question 46

Booksellers of Bufluffia is a small, independent bookstore that both publishes and sells very specialized titles.They currently have about 50 clients; they publish and sell 30 different books at present.The company's management has asked you to create database tables to support their operations.The database is likely to contain all of the following tables except:

A)Clients
B)Sales
C)Inventory
D)Bookstore

Question 47

Booksellers of Bufluffia is a small, independent bookstore that both publishes and sells very specialized titles.They currently have about 50 clients; they publish and sell 30 different books at present.The company's management has asked you to create database tables to support their operations.Any database tables that are in third normal form should:

A)Eliminate repeating groups.
B)Eliminate redundant data.
C)Eliminate columns not dependent on the primary key.
D)All of these.

Question 48

Consider the following illustration as you respond to the questions: Suppose a decision maker wanted to determine how many applicants submitted their materials within a specified one-week time frame.Which database objects would the decision maker use?

A)a table and a query
B)a query and a process
C)a data flow and a table
D)some other combination

Question 49

Consider the following illustration as you respond to the questions: "Diagram X" is:

A)A context flowchart
B)A context diagram
C)A Level Zero diagram
D)A database diagram

Question 50

Booksellers of Bufluffia is a small, independent bookstore that both publishes and sells very specialized titles.They currently have about 50 clients; they publish and sell 30 different books at present.The company's management has asked you to create database tables to support their operations.Suppose the database includes four tables; in which table would you expect to find a field titled "quantity sold?"

A)Transactions table
B)Inventory table
C)Sales table
D)Sales/inventory table

Question 51

Consider the following illustration as you respond to the questions: The most appropriate label for Symbol A is:

A)Submit application materials
B)Receive application materials
C)Application materials
D)Resume and references

Question 52

Booksellers of Bufluffia is a small, independent bookstore that both publishes and sells very specialized titles.They currently have about 50 clients; they publish and sell 30 different books at present.The company's management has asked you to create database tables to support their operations.Which table(s) should be in third normal form?

A)The client table only
B)The books table only
C)Both the client table and the books table
D)Neither the client table nor the books table

Question 53

Booksellers of Bufluffia is a small, independent bookstore that both publishes and sells very specialized titles.They currently have about 50 clients; they publish and sell 30 different books at present.The company's management has asked you to create database tables to support their operations.Which of the following junction tables is likely to be included in the database?

A)Clients/inventory
B)Clients/sales
C)Inventory/sales
D)All of these.

Question 54

Booksellers of Bufluffia is a small, independent bookstore that both publishes and sells very specialized titles.They currently have about 50 clients; they publish and sell 30 different books at present.The company's management has asked you to create database tables to support their operations.Suppose the database includes four tables: clients, inventory, sales and sales/inventory.In which table(s) would you expect to see a field labeled "client ID?"

A)Clients table only
B)Sales table only
C)Both clients table only and sales table only
D)Neither clients table only nor sales table only

Question 55

Consider the following illustration as you respond to the questions: The illustration would best be described as:

A)a pair of systems flowcharts
B)a leveled set of data flow diagrams
C)a comprehensive set of data flow diagrams
D)two pages of a systems flowchart

Question 56

Consider the following illustration as you respond to the questions: The most appropriate label for Symbol C is:

A)qualified applicants data
B)interviewee data
C)rejection letter
D)Symbol C should not be labeled.

Question 57

Consider the following illustration as you respond to the questions: A relational database of the process depicted would include all of the following tables except:

A)applicant
B)perform initial screening
C)applicant/rejection letter
D)interview applicant

Question 58

Booksellers of Bufluffia is a small, independent bookstore that both publishes and sells very specialized titles.They currently have about 50 clients; they publish and sell 30 different books at present.The company's management has asked you to create database tables to support their operations.Suppose the database includes a sales/inventory table.You would expect to find all of the following fields in that table except:

A)Sales transaction number
B)Inventory item number
C)Quantity purchased
D)Total amount billed

Question 59

Consider the following illustration as you respond to the questions: A relational database of the process depicted would include the "perform initial screening" table.Which of the following statements about that table is most true?

A)It must have "applicant ID" as its primary key.
B)It will not be in third normal form if it includes "applicant ID" as a field.
C)It may include the same date in more than one record.
D)Including the same date in more than one record violates the principles of second normal form.

Question 60

Consider the following illustration as you respond to the questions: The most appropriate label for Symbol B is:

A)Send rejection letter
B)Rejection letter
C)New employee materials
D)Some other label

Question 61

Consider the following case as you respond to the next problem:
The Festival Theatre produces twelve plays per year.Patrons can buy tickets for a single play; alternatively, they can purchase a season pass for either three plays or six plays.Three-play passes offer a 10% discount from the prices of single tickets; six-play passes, a 25% discount.Since most patrons live within 30 miles of the theatre, all ticket sales are done at the box office only.The theatre has an "open seating" plan, so patrons do not reserve a specific seat at any performance.Single-play purchases must be paid for in cash; season passes can be paid for with cash or major credit card.The Festival Theatre deposits all its cash receipts in the bank daily.Create a Level Zero data flow diagram for the process described in the case.

Question 62

Both systems flowcharts and data flow diagrams can be used to document accounting information systems.Explain two similarities of and two differences between the methods.

Question 63

Several items that might appear in a systems flowchart and/or a data flow diagram are listed below.For each item, draw the symbol you would use to represent it in both forms of systems documentation.If no appropriate symbol exists, use an "X."
a.Customer check
b.Electronic sales transaction file
c.End of a process
d.Evaluate credit application
e.First National Bank
f.Grant credit?
g.Inventory master file (digital)
h.Paper file of payroll documents
i.Sales invoice
j.Start of a process

Question 64

The Festival Theatre produces twelve plays per year.Patrons can buy tickets for a single play; alternatively, they can purchase a season pass for either three plays or six plays.Three-play passes offer a 10% discount from the prices of single tickets; six-play passes, a 25% discount.Since most patrons live within 30 miles of the theatre, all ticket sales are done at the box office only.The theatre has an "open seating" plan, so patrons do not reserve a specific seat at any performance.Data flow diagrams incorporate four types of symbols.Give one example of each symbol you would expect to find in a Level Zero data flow diagram of the preceding process.(You do not need to create the actual DFD.)

Question 65

Bumble Beasley wanted to create three database tables for the information items shown below: supplies table, purchases table and purchases/supplies table.Apply the principles of normalization to show how he should organize them.Specify primary keys by underlining and foreign keys with bracket
"As of" date for beginning inventory
Beginning quantity on hand
Cost per unit purchased
Cost per unit-beginning inventory
Item description-office supplies
Office supplies item number
Purchase date
Quantity purchased
Transaction number
Vendor ID

Question 66

Fill in the blanks below based on the rules/conventions associated with data flow diagrams presented in the text.
a.A data store has a ___ phrase label.
b.A process has a ___ phrase label.
c.No process can have only ___.If an object has only ___, it must be a data store.
d.No process can have only ___.If an object has only ___, then it must be an external entity.
e.The ___ to a process should differ from the outputs of a process.

Question 67

The Festival Theatre produces twelve plays per year.Patrons can buy tickets for a single play; alternatively, they can purchase a season pass for either three plays or six plays.Three-play passes offer a 10% discount from the prices of single tickets; six-play passes, a 25% discount.Since most patrons live within 30 miles of the theatre, all ticket sales are done at the box office only.The theatre has an "open seating" plan, so patrons do not reserve a specific seat at any performance.Create specifications (table names and field names) for three tables the theatre would need to track ticket sales; if a junction table is indicated, you must include its specifications as one of the three.

Question 68

Consider the following illustration as you respond to the questions: Is Diagram X balanced with Diagram Y?

A)No, because X includes only one process while Y includes two.
B)No, because Y includes more data flows than X.
C)Yes, because the one process in X has been properly decomposed in Y.
D)Yes, because the data flows into and out of the external entity are the same.

Question 69

List and discuss two ways data flow diagrams are used in accounting information systems work.

Question 70

Consider the partial data flow diagrams shown below.Match each one with the item it most likely represents. 1.Access employee records
2.Add comments about vendor
3.Deliver goods and bill client
4.Interview applicant
5.Look up payroll information
6.Post transactions to ledger
7.Reconcile bank statement and record related journal entries
8.Review vendor quality information
9.Take customer order
10.Update employee records

Question 71

For which of the following tasks would a data flow diagram be appropriately used in AIS work?

Question 72

Specify the data flow diagram symbol that would be used to represent each item in the list below.
a.Bank
b.Check
c.Disburse cash
d.Inventory master file
e.Purchase/inventory file
f.Purchase inventory
g.Purchase order
h.Vendor
i.Vendor file
j.Vendor invoice

Question 73

Data flow diagrams incorporate four symbols.List the symbols; for each one, give two examples of how it might be used in a DFD.

Question 74

Determine which of the following statements are: (a) true for systems flowcharts only, (b) true for data flow diagrams only, (c) true for both or (d) true for neither.1) Can be prepared using information technology tools
2) Clearly specifies responsibility for business processes
3) Commonly thought of as the one best way to represent an AIS
4) Incorporates verb phrases to label processes
5) Labels data flows between processes
6) May span multiple pages
7) Processes can be represented with different types of symbols
8) Represents processes with a single symbol type
9) Should be uncluttered and easy to read
10) Uses a symbol to represent a database

Question 75

Consider the following case as you respond to the next problem:
The Festival Theatre produces twelve plays per year.Patrons can buy tickets for a single play; alternatively, they can purchase a season pass for either three plays or six plays.Three-play passes offer a 10% discount from the prices of single tickets; six-play passes, a 25% discount.Since most patrons live within 30 miles of the theatre, all ticket sales are done at the box office only.The theatre has an "open seating" plan, so patrons do not reserve a specific seat at any performance.Single-play purchases must be paid for in cash; season passes can be paid for with cash or major credit card.The Festival Theatre deposits all its cash receipts in the bank daily.Generate field names for the patron table, sales table and the sales/play table.

Question 76

Suppose a leveled set of data flow diagrams incorporates the levels indicated below.Specify how processes would be numbered at each level.