Identify various entities and the relationships

Assignment Help Basic Computer Science
Reference no: EM131193488

Tommy and Tom (TT) Inc. sells hundreds of products and uses over 10,000 components in its products.  The company knows precisely what parts are needed for each product.  They maintain a list of suppliers who supply one or more of the components.  Each supplier is evaluated on price/unit, quality, and reliability for each part it supplies  (implies, a supplier can supply more than one part but the supplier is evaluated for each part separately).   Each supplier is then ranked (that is, if there are 5 suppliers then each supplier will be ranked Number 1 to 5. One implies highest preference). The new system that the management is considering will require suppliers to update their lead-time, and minimum and maximum order quantity.  For each part there is a re-order level.  If the number of units falls below that re-order level then a new purchase order is released to a supplier based on the rank.  The system maintains when an order was placed, expected delivery date, and actual delivery date.   On receipt, parts are evaluated again for quality. A batch can be rejected if the quality is bad.   If the parts supplied is certified "OK" then a supplier is a paid immediately through electronic money transfer.

TASK:

  • Identify various entities and the relationships and draw the E-R diagram. Convert the E-R diagram into tables (relational model). 
  • What if an order can be supplied in small quantities at various times (that is, a large order can be split into many small orders).  How does your E-R diagram and table structure change?

Reference no: EM131193488

Questions Cloud

Business decision support systems : Write a 2 to 3 page essay describing how business decision support systems have evolved over the past several decades as computer and data capabilities have grown. The rubric for this assignment can be viewed when clicking on the assignment link.
Compute the stress and the angle of twist : A 3.00 in-diameter steel bar has a flat milled on one side, as shown in Figure P3-29. If the shaft is 44.0 in long and carries a torque of 10 600 lb•in, compute the stress and the angle of twist.
Discuss the deployment services situations : Please briefly discuss the deployment services situations; what initial facts would best determine what situation should be used? If you were deploying on 150 computers, which would you use? Please give a detailed explanation of everything you wou..
How important is to have proper diet in nutritional support : Conclusions and recommendations. You must express your own opinion how important is to have a proper diet in the Nutritional Support for elder patients.
Identify various entities and the relationships : Identify various entities and the relationships and draw the E-R diagram. Convert the E-R diagram into tables (relational model).  What if an order can be supplied in small quantities at various times (that is, a large order can be split into many ..
Do you think that what the participants did was wrong : Do you think that what the participants did was wrong? Does it mean that they are "evil"? According to the text, "ordinary" people are more likely than not to follow an authority figure. Does this seem believable? Why or why not?
Improve multimedia search experiences : Assess current multimedia document search techniques and suggest three techniques to improve multimedia search experiences. Explain why you chose to recommend each of the techniques you suggested. paragraph and references
What a baker does and discuss business activities : HA2042ACCOUNTING INFORMATION SYSTEMS Assignment. Define business processes - What a Baker does? Discuss the business activities/processes of the organisation to show your understanding about the business
Determine as effective and other as an ineffective leader : In a 2-page paper, elaborate on two leaders: one which you determine as effective and the other as an ineffective leader. These individuals do not need to be in healthcare. What are their similarities and differences? Additionally, discuss your le..

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Show the risk mitigation strategy

Each member selects one of the highest risks. Explain why these are considered high risk, and explain their potential effect on the project and outline a risk mitigation strategy for the each of the selected high risks.

  What happens and why that behavior is a problem

What kinds of problems can arise when two hosts on the same Ethernet share the same hardware address? Describe what happens and why that behavior is a problem.

  Describe the graphical coordinate system in java

How do you specify a particular color to be used as fill when using the Graphics class?

  List the binary values in register a and the carry flip-flop

The carry flip-flop is initially reset to 0. List the binary values in register A and the carry flip-flop after each shift.

  Write a range query function for a b-tree in pseudo code

Write a range Query function for a B-tree in pseudo code. (See Exercise 3 of Chapter 19 .) Assume that only the key values are needed (as opposed to the entire data record).

  How can the operating point be determined

Over the range 0-175 ft3/min, where Qis in ft3/min and hA is in ft, a fluid system curve is given by hr = 3.52Q2: How can the operating point be determined?

  Monetizing web portals

How do these sites currently make money from this client base?

  Job specifications include for type of position

What should the titles of the jobs be and what should the job specifications include for each type of position? How should they advertise these positions? Justify your choices.

  Determining z-transform and fourier transform

Consider the finite length sequencx(n)=D(n) + 0.5D (n-5). Determine z-transform and fourier transform of x(n). Determine N-point DFT of x(n) for N=50,10 and 5.

  Prove a linear-time lower bound for the maxflow problem

Show that, for any values of V and E, any maxflow algorithm might have to examine every edge in some network with V vertices and E edges.

  Write an application that plays guess the number

(Guess the Number) Write an application that plays "guess the number" as follows":  Your program chooses the number to be guessed by selecting a random integer in the range 1 to 1000.  The application displays the prompt 'Guess a number between 1 and..

  Define a more suitable similarity metric that can be used

Define a more suitable similarity metric that can be used for clustering data records that contain categorical data.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd