Exam 7: Data Flow Diagramming

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:

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

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

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?

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?

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 circle in a data flow diagram represents:

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

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.

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?

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.

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:

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:

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

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

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:

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

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

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

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.