![caldonjoshhsms2061](/avatars/44179.jpg)
caldonjoshhsms2061
17.04.2020 •
Business
ABC Ltd plans to computerise its sales ordering and stock control system. A feasibility study hasstrongly suggested that a relational database system be installed. The details of ABC's sales and stock control are as follows:
Customers send in orders for goods. Each order may contain requests for variable quantities of one or more products from ABC's range. ABC keeps a stock file showing for each product the product details and the preferred supplier, the quantity in stock, the reorder level and other details.
ABC delivers those goods that it has in stock in response to the customer order and an invoice is produced for the despatched items. Any items that were not in stock are placed on a back order list and these items are usually re-ordered from the preferred supplier. Occasionally items are ordered from alternative sources.
In response to the invoices that are sent out to ABC's customers, the customers send in payments.Sometimes a payment will be for one invoice, sometimes for part of an invoice and sometimes for several invoices and part-invoices.
Draw an entity-relationship model, stating any assumptions made. Make sure you remove all many-many relationships and replace them with new entity types and relationship types.
Solved
Show answers
More tips
- H Health and Medicine Everything You Wanted to Know About Male Circumcision: Its Goals and Effects...
- L Leisure and Entertainment Couchsurfing: A New Way to Travel...
- G Goods and services Which TV is better - LCD or Plasma?...
- S Sport How to Learn to Pull Up on Monkey Bars?...
- L Leisure and Entertainment Scrapbooking: What is it and Why is it Becoming More Popular?...
- C Computers and Internet Where did torrents.ru move to?...
- B Business and Finance Understanding Cash Flow: What It Is and How It Works...
- C Computers and Internet What Are Peers and Seeds in Torrenting?...
- H Health and Medicine 10 Simple Techniques on How to Boost Your Mood...
- G Goods and services How to Choose the Right High Chair for Your Baby?...
Answers on questions: Business
- B Business What is y=x^3+7x^2+14x+8...
- B Business The table gives a set of price and cross-price elasticities for four commodities, W, X, Y and Z. with respect to price of elasticity of demand for commodity W X Y...
- M Mathematics Write the slope intercept form of the equation of the line through the given points....
- M Mathematics Need help plz this is math. Don’t answer if you don’t know...
- M Mathematics Macy’s is having a one-day 35% off special. If Sandy bought $124.50 worth of items, what would the sales price be after applying the discount of 35% off?...
- G Geography Answer choices : A troposphereB mesosphereC exosphereD thermosphere...
- S Social Studies The god of the Hebrew people was known as Jehoshaphat. True O False...
- S Spanish Alguuen q hable español...
- M Mathematics f(x)=2/3x−1 and g(x)=−4x+6. What transformation occurs from function f to function g? a vertical translation 6 units down a horizontal translation 6 units left a horizontal...
- S Social Studies Elaborate your reasons why you think president duterte is the best....
Ответ:
sedrtyuio
Explanation: