Coastal seafoodcoastal seafood is a family-owned business

Assignment Help Database Management System

Reference no: EM13370062

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: EM13370062

Questions Cloud

Followers want their leaders to lead by example setting the : followers want their leaders to lead by example setting the standards and enforcing the same standards that will make

Joe fast started a mobile snack food service on january 2 : joe fast started a mobile snack food service on january 2 2006 investing 15000 cash depositing in a bank account in the

Task 1send a business email to your lecturer with the : task 1send a business email to your lecturer with the questions as an attachment. the attachment needs to be a

Write a program that uses the following arrays empid an : write a program that uses the following arrays empid an array of seven long integers to hold employee identification

Coastal seafoodcoastal seafood is a family-owned business : coastal seafoodcoastal seafood is a family-owned business that operates on the east coast. the company already uses

You have a bevel gear and shaft and you have to find the : you have a bevel gear and shaft and you have to find the maximum load that can be applied on it. what type of

Part-1suppose that the firm uses three inputs to produce : part-1suppose that the firm uses three inputs to produce its output capital k labor l and materials m.nbsp the firms

One of the problems of storing data in a matrix a : one of the problems of storing data in a matrix a two-dimensional cartesian structure is that if not all of the

Part-11 generalize the basic approaches we used for making : part-11 generalize the basic approaches we used for making the best out of best effort service for real-time

User Account

All Pages