Deck 7: Data Flow Diagramming

Question 1

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 the above

Answer 1

B

Question 2

Refer to the illustrations below as you answer the next 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 the above statements is true.

Answer 2

D

Question 3

Refer to the illustrations below as you answer the next 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 3

A

Question 4

Please refer to the following short case as you respond to the next 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 5

Please refer to the following short case as you respond to the next 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 6

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 7

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 the above

Question 8

Please refer to the following short case as you respond to the next 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 9

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 10

Please refer to the following short case as you respond to the next 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 11

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 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

Please refer to the following short case as you respond to the next 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 A or B
D)Neither A nor B

Question 14

Please refer to the following short case as you respond to the next 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 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

A circle in a data flow diagram represents:

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

Question 17

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 A and B are true.
D)Neither A nor B is true.

Question 18

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.

Question 19

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 A and B are true.
D)Neither A nor B is true.

Question 20

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 the above

Question 21

Please refer to the following case as you answer the next 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 22

Please refer to the following case as you answer the next 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 23

Please refer to the data flow diagram below in answering the next 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 the above statements are true.

Question 24

Refer to the Level Zero data flow diagram below and the CWM case in responding to the next 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 the above is likely to be the name of Process 1.0.

Question 25

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 26

Please refer to the following case as you answer the next 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 data flow diagram below in answering the next 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 28

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 29

Please refer to the data flow diagram below in answering the next 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 30

Refer to the Level Zero data flow diagram below and the CWM case in responding to the next 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 the above statements are true.

Question 31

Please refer to the following case as you answer the next 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 32

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 A and B.
D)Neither A nor B.

Question 33

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 34

Please refer to the following case as you answer the next 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 35

Please refer to the data flow diagram below in answering the next 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 36

Refer to the Level Zero data flow diagram below and the CWM case in responding to the next 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 A and B are true.
D)Neither A nor B is true.

Question 37

Refer to the Level Zero data flow diagram below and the CWM case in responding to the next 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 A and B are true.
D)Neither A nor B is true.

Question 38

Please refer to the following case as you answer the next 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 39

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 40

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 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. The database is likely to contain all of the following tables except:

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

Question 42

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 43

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 the above

Question 44

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 45

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 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. 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 the above

Question 47

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

Question 48

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 49

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 A and B
D)Neither A nor B

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

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 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. 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 the above.

Question 53

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 54

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 55

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 the above.

Question 56

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 57

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

Question 58

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 59

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 60

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 61

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 62

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.)