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

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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