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

  Explain techniques for distributed data placement

Create a diagram using Visio, Microsoft Paint, or other graphical creation utility of your choosing to illustrate the diagrams supporting your conclusion. Note: The graphically depicted solution is not included in the required page length.

  Explain the concept of physical data independence

Explain the concept of physical data independence and its importance in database systems,  List four significant differences between a file-processing system and a DBMS.

  Describe binary lock function

Describe relationships with example. Also illustrate degree of relationship for that example. What do you mean by locks. Write dow a binary lock function.

  Relationship of primis to back-end systems at mcgraw-hill

Assess whether the prototyping would have helped the Primis team. Justify why or why not. Conclude why it was important to consider the relationship of Primis to back-end systems at McGraw-Hill

  Statements for the subsequent queries of the database

Write the statements for the subsequent queries of the database - Find Beth' s home state.

  Problem 1suppose you have a relation schema about teaching

problem 1suppose you have a relation schema about teaching classes that has the following attributes class instructor

  Show the names of the customers for whom we have invoices

Show the names of the customers for whom we have invoices.  Show the CUS_CODE of the customers for whom we DO NOT have invoices. Show the names of the customers for whom we DO NOT have invoices.

  Transform the table into one or more tables in bcnf

Transform this table into one or more tables in BCNF. State the primary keys, candidate keys, foreign keys, and referential integrity constraints.

  Rea properties

This assignment aims to improve your design and programming skills in database systems. In particular, it requires you to exercise programming skills in SQL and PL/SQL under Oracle PL/SQL Developer or SQL*Plus tool.

  You have been hired as the banks director of data security

a large bank has a headquarters location plus several branches in each city in a particular region of the country. as

  Object-oriented databases

Object-oriented databases, Write a paper that describes the topic in detail. Include a discussion on the following subject areas

  Specify the foreign keys for schema

First, specify the foreign keys for this schema, stating any assumptions you make. Next, populate the relations with a few example tuples.

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