System Analysis &Design

posted by .

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.

  • System Analysis &Design -

    Please repost with the complete data.

  • System Analysis &Design -

    You description was cut off.

    Product (you have to keep track of what you sell and what customers order)

    Order (you have to keep track of orders)

    Customer (not absolutely necessary - you could just enter the Customer information for each order, if you are a small business - but storing Customer info becomes more valuable the more customers you have, the more repeat customers you have, if you want to target customer for promotional offers, etc.).

    How big is the sales office? Is it just 2 people who answer phones? Is it a team of professional sale people? How soon does the system need to be ready? But in general, I imagine that you would keep info on the sale office.

    You probably would also need an Employee entity.

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. Math

    Consider a system of notebook computers for a college math laboratory. The set of computers costs $10,000 and will be salvaged for $2,000 at the end of a 3-year period. Prepare a depreciation schedule using a 150%-declining balance …
  2. Computers

    When setting up a network, you should set up any computers running the Microsoft Vista operating system: first. last. only before any computers running Linux. The order does not matter. aboekhout20: im thinking its either aboekhout20: …
  3. computer tech

    you are starting up a new business and have just rented an office with cubicles and desks already provided. you will have a total of 20 employees including yourself. 5 employees will be mobile users with Office 2007 software, another …
  4. Computers

    Most personal computers are equipped with a version of the Windows operating system, whereas Apple personal computers have a different operating system. Other choices are also available, such as UNIX and Linux. What do the other systems …
  5. ICT ( please answer as soon as possible.its urgent

    multiple questions: 1- Computers are connected to the internet through a)direct connection b)dial up connections through modems c)broadband connection through high speed alternatives to modems d)all of these 2)who is the person responsible …
  6. Math

    Im having trouble getting the correct answer to this question. Could someone help out. Monthly sales of a particular personal computer are expected to decline at the following rate of S'(t) computers per month, where t is time in months …
  7. Math

    Each day Danny prepares pies for dessert.He slices each pie into 8 servings.If Danny bakes 9 pies and 54 customers order a slice,how many slices will be left?
  8. math

    The sales team at an electronics store sold 48 computers last month. The manager at the store wants to encourage the sales team to sell more computers and is going to give all the sales team members a bonus if the number of computers …
  9. Computer Literacy

    2. Which of the following components was a significant development featured in the Macintosh LISA computer?
  10. math

    A store owner receives 12 computers:nine are model A and the rest are model B.if two computers are sold at random,find the probability that one of each model is sold. (base on probability and combinatorial analysis)

More Similar Questions