Thursday
April 17, 2014

Homework Help: System Analysis &Design

Posted by Lapri on Monday, April 27, 2009 at 12:38pm.

What should my entities be?



Consider the following situation.

A manufacture of computers receives orders from customers through its sales office. Each order can have several products in it (different types of computers, lap tops, monitors, and other stuff). The producer checks the content of the order with the inventory list. If the required quantities exit, sends a confirmation to the customer with the price, delivery time and all the other details based on which the customer puts the confirmed order. If the required products are not available in the inventory, then sales department asks from the production planning about the availability time and based on that will give the information to the customer. If the confirmed order is received and part or all of the products are not in the inventory, then production planning will calculate the requirements of targeted production by using the Bill of Material and a Material Requirement Planning Software and prepares the orders for the required products. This order will go to the purchasing department who will actually purchase the product by selecting the proper supplier. The related information from different steps will be communicated to the accounting department for payments and to the warehouse.
a. Draw a context diagram for this situation
b. Draw a DFD for this situation (go to the lowest level as you deem necessary.
c. Draw the structure chart based on your DFD. Make sure that you consider all the issues related to structure charts such as type of structure chart, cohesion, couplings fan-in, fan-out and other issues.
d. Identify all the entities required for your problem and draw the related ERD. Make sure that your entities match your DFD.
e. Take one of the processes in your level zero DFD (level next to the context diagram) and develop a complete pseudocode for that process that shows the input, output and process
f. Identify all the user interfaces for this problem. For the inputs explain where the input is coming from, in what form and what do you do with it when entered into the system. For outputs, explain what goes into the output, where it is coming from and what format you will need to use, and where this output is going to.
g. Using ACCESS, develop your database and make at least two of your interfaces, one input and one output in ACCESS (create a FORM for input and a REPORT for the output with all the elements required such as macros, help system, and connections. This should match exactly to what you say about these two interfaces in item f above. .
h. Insert at least two records for each of your tables to make sure your table works.

Answer this Question

First Name:
School Subject:
Answer:

Related Questions

Math - Each day Danny prepares pies for dessert.He slices each pie into 8 ...
Math - Im having trouble getting the correct answer to this question. Could ...
Account - Updraft Systems, Inc., makes paragliders for sale through specialty ...
English - While you're working in a sales office, the office manager says that ...
MARKETING - Select a company that has good strategy for developing a ...
computer tech - you are starting up a new business and have just rented an ...
Technology~bobpursley - 25. Briefly explain the difference between product ...
Accounting - Struggling answering this. - Updraft Systems, Inc., makes ...
System Analyst and Design - Terrier News Situation: Terrier News is a monthly ...
ICT ( please answer as soon as possible.its urgent - multiple questions: 1- ...

Search
Members