Use the information and build context data flow diagram

Assignment Help Database Management System
Reference no: EM13950196

Use the following narrative to construct the Context Diagram for the Pinnacle Publishing sales and book tracking system

The purpose of the sales and book tracking system is to provide a single central repository of all information about sales leads, books in process, and books for sale. The Sales Department will enter new authors to the system as they gather leads from various sources. In response, the system can produce mailing labels for sending information to authors. As salespeople enter information on their phone calls, the system will generate recall lists to help the salespeople schedule their calls. Management wants to get a sales performance report from the system.

Once a salesperson sells a publishing contract to an author and the author sends in a manuscript, the Production Department will create a book record to track the book through the production process. Each book will be assigned a "shepherd" who will oversee the production process for that book. The system will provide the shepherd with a list of the status of each of his or her books each day. When the shepherd sees that a task has been finished for a book, the shepherd will assign another task and select the technician to complete that task. The system will communicate that assignment to the technician via e-mail.

Technicians will enter updated information to the system as they complete their tasks. The system will also output information daily from the database to a self-service web site where authors can check on the status of their books. As the book comes to press, production people will enter information about promotions being done, ISBN, and other information.

The Sales Department continues to work with authors who have submitted books to sell them various promotional options. The Production Department fulfills those options.

For books that are published, the system needs to pull sales information from several external e-commerce web sites. This information will be used by the Accounting Department to generate royalty reports to use to pay authors.

Example Context Data Flow Diagram

107_dd.png

Reference no: EM13950196

Questions Cloud

What is the total overhead cost incurred by celestial : What is the total overhead cost incurred by Celestial for the year? What is the overhead cost per funeral for the year? Calculate the unit product cost for the year.
What does traceability mean and what is tracing : What does traceability mean? What is tracing? What is allocation? What are drivers? Give an example of a driver. Explain the difference between direct tracing and driver tracing.
Estimate of remaining cash flows will be revised : ACME has hired you to study the feasibility of a new toy that requires a $5 million initial investment. ACME expects annual cash flows of $880,000 for the next 10 years. The discount rate is 10%. a. What is the NPV of the new toy? b. After one year, ..
Give three examples of product cost definitions : Give three examples of product cost definitions. Why do we need different product cost definitions? Identify the three cost elements that determine the cost of making a product (for external reporting).
Use the information and build context data flow diagram : The purpose of the sales and book tracking system is to provide a single central repository of all information about sales leads, books in process, and books for sale. The Sales Department will enter new authors to the system as they gather leads ..
Approximate after-tax cost of debt for new issue of bonds : The coupon rate on a debt issue is 7%. If the yield to maturity on the debt is 11%, what is the after-tax cost of debt in the weighted average cost of capital if the firm's tax rate is 41%? The coupon rate on an issue of debt is 11%. The yield to mat..
Which cost assignment method would most likely be used : Identify which cost assignment method would most likely be used to assign the costs of each activity to the tanning area: direct tracing, driver tracing, or allocation.
Describe how information could reach the public domain : Analyse different techniques (e.g. media, leaflets, newspapers etc.) for disseminating information relating to the issue of elderly care - Evaluate how the different ways in which information relating to elderly care is presented, which can influen..
Project falls in the five-year MACRS class for tax purposes : An asset used in a four-year project falls in the five-year MACRS class (MACRS Table) for tax purposes. The asset has an acquisition cost of $8,500,000 and will be sold for $1,890,000 at the end of the project. If the tax rate is 30 percent, what is ..

Reviews

Write a Review

Database Management System Questions & Answers

  Create an entity-relationship diagram and design

create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices

  What factors will influence how you design the database

The small publishing company you work for wants to create a new database for storing information about all of its author contracts. What factors will influence how you design the database?

  Create a new database and name it orders

Purpose of this hands-on computer exercise is to have you learn how to use Microsoft Access to: create a database table, enter data into the table, create a report based on the data, and print the table and the report.

  Differences between the oracle database sysdba and sysoper

What are the differences between the Oracle database SYSDBA and SYSOPER privileges? Explain OS authentication and how that allows you to connect to the database as SYS without providing a password

  Explain relation schema and set of functional dependencies

Consider relation schema r(A,B,C,D,E, F) and a set of functional dependencies {A BCD,BCDE,BD,DA}. Calculate canonical cover for set of functional dependencies (show each step of your derivation with an explanation).

  Design a data model

Design a data model

  How to test the database management system''s functionality.

Why is this? do you think a cetain type or size of organization is more likely to skip these tests than another

  Design an information system for grades, review &management

Design an information system for grades, review and management to be used by faculty, department administration and students.

  Create a provider database and related reports

Create a provider database and related reports and queries to capture contact information for potential PC componentproviders that might be used to purchase the equipment your specified in your MS Word project - the PC specifications

  Explain the level of normalization

Use Microsoft Access to create the keys and relationships between tables for the Huffman Trucking Driver Log.

  How effective is the sas statistical modeling software

How effective is the SAS statistical modeling software described in this case study? Explain your answer. What concepts in this chapter are illustrated in this case

  Validity of the collected data and include the survey report

Describe the easy and difficult aspects of creating and conducting an online questionnaire. Assess the reliability of the collected data and include the survey report. Assess the validity of the collected data and include the survey report

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd