Prepare a dfd and context diagram for the system

Assignment Help Database Management System
Reference no: EM1371895

Coastal Seafood

Coastal Seafood is a family-owned business that operates on the East Coast. The company already uses both financial and point-of-sale software, but has been unable to find a suitable system to manage its inventory and orders. You are an independent consultant who has been hired to develop an inventory and orders system for the company.

Background

Coastal Seafood purchases a variety of seafood (Cod, Tuna, Tilapia, Crab, etc.) from local fishing boats. The company packs the seafood in ice, and then sells it in parcels. The cost-per-pound of each type of seafood fluctuates on a weekly basis. Coastal Seafood sells bulk orders at cost plus 60 percent. Smaller orders are sold at cost plus 90 percent.

Currently, the company uses a journal to record its purchases and orders. Any employee can add, edit, or strike out a journal entry. When new product arrives, employees must record the type, total weight, and cost as a new journal entry. A spreadsheet is used to keep track of inventory totals. When seafood is bought or sold, employees must update the spreadsheet. When orders are placed, employees must refer to previous journal entries to calculate the selling price, and the spreadsheet to check availability.

As the business continues to grow, this system is becoming less viable. Some of the shortcomings include:

Employees sometimes make clerical mistakes, or forget to record transactions.

When the inventory holds a particular type of seafood that has been purchased at more than one cost, it is difficult to determine the correct selling price for that type of seafood.

The journal entries have to be reconciled with the spreadsheet on a daily basis. This process can take up to one hour to complete.

Requirement:

1. Prepare a context diagram for the system.

2. Prepare a diagram 0 DFD for the system.

Reference no: EM1371895

Questions Cloud

Find the firm forward pe ratio : A corporation requires $500,000,000 to finance a major project in the firm. The company is expected to generate a total of $80,000,000 in earnings next year with the addition of this project.
Create algorithm to prepare daily hotel charge report : Create the algorithm to prepare the daily hotel charge report. Input consists of series of records which contain a room number, customer name, cost of the room, and cost of meals charged to the room.
Calculating the root mean square error : The table below demonstrate the demand for Fidgets over an eight month period. Calculate a four-period moving average forecast for September.
Create algorithm to read arbitrary number of data record : Create the algorithm to read arbitrary number of data records, each containing name, age, and code. Code of 1 will indicate female, a code of 2 will indicate male.
Prepare a dfd and context diagram for the system : Journal entries have to be reconciled with the spreadsheet on a daily basis - Prepare a context diagram for the system and also prepare a diagram 0 DFD for the system
Write non-recursive function-compute n-th fibonacci number : Fibonnacci series 0,1,1,2,3,5,8,13,21,... starts with terms 0 and 1 and has property that each succeeding terms is sum of the two preceding terms. Write the non-recursive function which computes the n'th Fibonacci number.
Calculate growth rate in sales : The following table demonstrate yearly sales information for Landrover, Inc., over the ten-year 1998-2008 period:
Calculate expected market price of stock : Estimate the price of a stock that has a one-period horizon, is expected to pay a dividend of $.20 per share for period,
Diameter bounded minimum spanning tree of graph by prim-s : Modify Prim's or Kruskal's algorithm to determine diameter bounded minimum spanning tree of complete graph. A diameter bounded minimum spanning tree is spanning tree.

Reviews

Write a Review

Database Management System Questions & Answers

  Determine the functional dependencies

Using your knowledge of the college environment, determine the functional dependencies that exist in the following?

  Write benefits of using dbms to manage data in program

Describe briefly what are the main benefits of using DBMS to manage data in program applications involving extensive data access.

  Writing down sql query

Write down the SQL code in order to carrying out the following requests. Display all the data in each of the four tables. Do not display the foreign key columns.

  Practice on topic of normalization

Practice on topic of Normalization

  Find average number of books borrowed per member

Find the average number of books borrowed per member. Take into account that if a member does not borrow any books, then that member does not appear in the borrowed relation at all.

  Produce budget reports for department at university

Consider system which produces budget reports for department at university. For whichever system you select, answer the following design questions. Who will use output?

  Create the following documents for the proposed system

MGMT321 Group Project: Create the following documents for the proposed system and deliver each SDLC documents by the end of each designated module, as shown below

  Advantage storing metadata in tables

What advantage is there in storing metadata in tables? Is Microsoft Access a DBMS? Why or why not? List the several consequences of a poorly designed database.

  Create a database for a home-budgeting application

The first part is to create a database and some tables which will be appropriate for a home-budgeting application. That portion of the assignment should be completed from the MySQL console command line.

  Data modeling and normalization

Data Modeling and Normalization

  Analyzing hard-to-obtain data from two separate databases

You are interested in analyzing some hard-to-obtain data from two separate databases. Each database contains n numerical values.

  Database system development

The database application project (DAP) for this course consists of the creation of a fully functional Microsoft Access database application for a real client.

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