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

  Develop two select commands for each table

Develop two SELECT commands for each table. One of the commands for each table should use a WHERE clause to filter the records being returned.

  Explaining valid host addresses of wan links

Start with LAN on RTA and proceed clockwise. Determine the number that how many total valid host addresses will be wasted on WAN links?

  You are hired by northwind as a database administrator you

you are hired by northwind as a database administrator. you are required to integrate some database script solutions

  Use a two-dimensional array to accumulate the number

Create a form containing labels with each of the questions and a group of radio buttons for each question with the following responses: Always, Usually, Sometimes, Seldom, Never.

  Write summary on relational database theory

Write a two-page executive summary for your boss explaining how a relational data solution can be applied to a current business problem or area for improvement. Assume that your boss knows nothing about relational database theory.

  Diagram and determine the possible iterative steps

Determine the steps in the development of an effective Entity Relationship Model (ERM) Diagram and determine the possible iterative steps / factors that one must consider in this process with consideration of the HR core functions and responsibili..

  Distribution of resource consumption

Compute the activity rates for the Filling Orders and Product Support activity cost pools by filling - Distribution of resource consumption

  What is recovering database via rollforward

What is Recovering a database via rollforward? What is aim of transaction log? What is contained in transaction log?

  Calculate the unadjusted function points

Calculate the unadjusted function points for the problem description of Problem 2.

  Describe the normal forms violated in the design

Describe the normal forms violated in the following design and fix them to the third normal form.

  Design the star schema for any data mart you have identified

Design the star schema for any Data Marts you have identified, ensuring your Dimensions are conformed, primary and foreign keys are clearly labelled, and that your attributes are named using verbose textual descriptions.

  How each influence the design of the logical database model

Your supervisor requested a short memo identifying each of the five W's and the H (Who, What, Where, When, Why, and How) and how each could influence the design of the logical database model. Compose an 600-word e-mail to your supervisor.

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