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

  Explain issues to convert relationship for new cardinality

Using example of vehicles and drivers, explain issues to convert relationship for new cardinality including new relationships and attributes for the tables.

  Converting user form into 1nf and 2nf

Complete database exercise by converting user form located the evaluation procedures section of the syllabus into 1NF and 2NF.

  Use three-sphere model for systems management

Use the three-sphere model for systems management and brainstorm issues related to the change based on the business, technology, and organization spheres.

  Importance have button that takes you back to main page

What is the importance to have a button that takes you back to the main page on each web page? How does dead end or orphan pages affect the continuity of a website?

  Calculate canonical cover for set of functional dependencies

Calculate a canonical cover for above set of functional dependencies (show each step of your derivation with an explanation).

  Explain meaning of expression acid transaction

What is lock granularity? Explain the use of BEGIN, COMMIT, and ROLLBACK TRANSACTION statements. Explain the meaning of expression ACID transaction.

  Convert er diagram into relational schema

Suppose we are to design a registrar's database to store information about students, courses, the courses students have taken. Convert the E/R diagram into a relational schema.

  Write names-e-mail addresses for all customers from table

Show all the data in each of the four tables. Do not show foreign key columns. Write names and e-mail addresses for all customers who have had a stove repair that cost more than $50.

  Write program that models an employee

Write a program that models an employee. An employee has an employee number, a name, an address, and a hire date. A name consists of a first name and a last name.

  Creating erd containing order and customer entity

Create ERD containing Order and Customer entity types connected by 1-M relationship from Customer to Order. Select suiatble relationship name using your common knowledge of intersection.

  Database modeling and design

Database Modeling and Design: A complete table diagram. Transform model to tables, include all attributes and keys.

  Application important part of security model for databases

Using Internet as the research tool for extra information not presented in text, describe why application roles are important part of the security model for databases.

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