Realize conceptual data and logical modeling

Assignment Help Operation Management

Reference no: EM132122885

Case Study Of conceptual Data and Logical Modeling

Realize a conceptual data and logical modeling for this case study

A Sales Department has a file of products that they provide to their customers. Each type of product has a unique product number, as well as a description, a cost and a price. The number of the product in stock and the number allocated are updated regularly. When the number in stock decreases to the reorder level, the product is reordered in a pre-decided quantity. The other operations of the Departments can be described as follows:

1. They have a file of customers. Each customer is given a unique customer number. This file also contains customer names that consist of their first and last names, and customer addresses composed of street, city and postcode and the customer telephone number. Each customer has a credit limit, which is used to validate their orders.

2. A customer may place zero, one or more orders at a time, and an order is always placed by one customer alone. Each order is identified by a unique order number. Other information as to orders includes the date due, the total price, and the status, that is, an order may be outstanding, partially delivered, or fully delivered and invoiced.

3. An order may involve one or more than one type of products, and a type of products may be involved in more than one order. For each product being ordered in an order, its quantity, total price, and status (i.e., outstanding, partially delivered, or fully delivered) are recorded and updated regularly.

Reference no: EM132122885

Questions Cloud

Is there lesser punishment that would be acceptable to you : Is there a rationale for allowing Marilee Jones to retain her position after this discovery.? Is there a lesser "punishment" that would be acceptable to you?

Would you recommend that developed country eliminate tariff : Select a developed country that has implemented a tariff and a developing country that manufactures products that are affected by that same tariff.

What does it mean to differentiate a service : What does it mean to differentiate a service? How can you use it to increase target market interest?

What are some things that a union representative responsible : What are some things that a union representative responsible for negotiating wages and benefits should want to see placed in a work agreement?

Realize conceptual data and logical modeling : Realize a conceptual data and logical modeling for this case study. A Sales Department has a file of products that they provide to their customers.

How much do you need to invest today : Suppose you need to pay your air-ticket of $2400 for a European trip in 12 months. If you deposit money now, you can earn 7% per annum with a 50% probability.

What recommendations can you make to assist the company : Is Lobo using the lowest-cost combination of workers to produce its targeted output? If not, what recommendations can you make to assist the company?

Software development lifecycle methodology : From an IT perspective, do supply chain network design projects tend to be formal projects following the Software Development Lifecycle (SLDC) methodology

How would you use data from the foreign exchange market : Every week the Federal Reserve announces how quickly the money supply grew in the week ending ten days previously. (There is a ten-day delay because it takes).

User Account

All Pages