Exam 8: Data Flow Diagramming

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

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.

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

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.Any database tables that are in third normal form should:

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

A data flow diagram can be used:

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

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

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?

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

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

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?

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?

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:

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

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?

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.

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?

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.