This website uses cookies to ensure you have the best experience. Learn more

Dbm Tal Distributors Ch. 6 (Page 220)

784 words - 4 pages

DbM TAL Distributors Ch. 6 (Page 220)
Use DBDL notation for your answers. Draw one E-R diagram using your choice of drawing, copy or snip and add to Word document
Rep (RepNum, LastName, FirstName, Street, City, State, PostalCode, Commision, Rate)
Customer (CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum(FK))
Orders (OrderNum, OrderDate, CustomerNum(FK))
OrderLine (OrderNum(FK), ItemNum(FK), NumOrdered, QuotedPrice) – only identifies through oters and item entity
Item (ItemNum, Description, OnHand, Category, Storehouse, Price)
Question 1. Indicate the changes you need to make to the design of the TAL Distributors database to support the ...view middle of the document...

Indicate the changes you need to make to the design of the TAL Distributors database in the event User View 3 requirements are changed as follows:
a. For an item, store the item’s number, description, category, and price
b. In addition, for each storehouse in which the item is located, store the number of the storehouse, description of the storehouse, and the number of units of the item stored in the storehouse

Rep (RepNum, LastName, FirstName, Street, City, State, PostalCode, Commision, Rate)
Customer (CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum(FK))
Orders (OrderNum, OrderDate, CustomerNum(FK))
OrderLine (OrderNum(FK), ItemNum(FK), NumOrdered, QuotedPrice)
Item (ItemNum, Description, OnHand, Category, Price, StoreHouseNum(FK))
StoreHouse (StoreHouseNum, ItemNum(FK), Description, NumUnitsStored)

Question 4. Indicate the changes you need to make to the design of the TAL Distributors database to support the following situation:
a. The region where customers are located is divided into territories
b. For each territory, store the territory number and territory name
c. Each rep is assigned to a single territory
d. Each customer is also assigned to a single territory which must be the same as the territory to which the customer’s rep is assigned

Rep (RepNum, LastName, FirstName, Street, City, State, PostalCode, Commision, Rate, TerritoryNum(FK))
Customer (CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum(FK), TerritoryNum(FK))
Orders (OrderNum, OrderDate, CustomerNum(FK))
OrderLine (OrderNum(FK), ItemNum(FK), NumOrdered, QuotedPrice)
Item (ItemNum, Description, OnHand, Category, Storehouse, Price)
Territory...

Other assignments on Dbm Tal Distributors Ch. 6 (Page 220)

, 8K/0n6jK Essay

3130 words - 13 pages Success: · Section 4.1: Understanding the Importance of Revising and Editing · Section 4.2: Major Issues in Revising: Unity and Coherence · Section 4.3: Major Issues in Revising: Being Clear and Concise||| Reading|Read Ch. 6 of Wordsmith.||| Participation|Participate in class discussion. Make six substantive posts on three days each week.||15| Discussion Questions|Respond to weekly discussion questions. Respond to two of the posted weekly

Good Essay

4437 words - 18 pages (Cth) s 5. Chapters are indicated by 'ch' followed by a space and the chapter number. 6 James Edelman and Elise Bant, Unjust Enrichment in Australia (Oxford University Press, 2006) ch 4. Multiple pinpoint references are separated by a comma. Consecutive pinpoint references are separated by a dash. 7 Fair Trading (Reinstatement of Regulations) Act 2008 (Tas) ss 4(2)(a)–(b), (4), 5(b). For further information on pinpoint references

Syllabus

3192 words - 13 pages research questions and hypotheses. 2.3 Identify dependent and independent variables in business research. Reading Read Ch. 5 of Business Research Methods. Reading Read Ch. 6 of Business Research Methods. Reading Read Ch. 11 of Business Research Methods. Reading Review Ch. 3 of Business Research Methods. Participation Participate in class discussion. 10-2-12 3 Discussion Questions Respond to weekly discussion questions. 10-2-12 1

Barilla Spa Case

1295 words - 6 pages Case Report Barilla SpA ------------------------------------------------- Table of contents Table of Contents | | | Section | TITLE | PAGE | | | | | | | | | 1 EXECUTIVE SUMMARY | 3 | | | | | * | | * 2 CHALLENGES OF A LEAN SUPPLY CHAIN | 4 | | | 3 PRACTICAL STEPS FOR BARILLA SPA | 5 | | | 4 CONCLUSION

Lincoln Electric

1028 words - 5 pages ​…………………………....page 4  …       A new era​…………………………………………...page 5  …       Conclusion​………………………………………….page 6  …       References​………………………………………....page 6  …         page 1/6    Raphaël  ROBIN    Introduction       A picture of John C. Lincoln    "The Welding Experts"     Created  in  1895  by  John  C.  Lincoln  ​   a  capital  investment  of  $200​   Lincoln  with ,  the Electric  Company  is  today  a

Home Away From Home

2601 words - 11 pages inequalities in real-world applications. Course Assignments 1. Readings • Read Ch. 2 of the text. 5. Nongraded Activities and Preparation • Complete the Week Two Self-Check on MyMathLab® after completing your Week Two individual assignment. Results from this self-check help to generate your study plan. Refer to the University of Phoenix Material: Using MyMathLab® for more information. 6. Individual Assignment

Mgt/449

2076 words - 9 pages of continuous improvement in strategic planning. | | | | |Explain how to use customer satisfaction measurements to enhance quality planning. | | | |Readings |Read Ch. 3, 6, & 7 of Quality Management for Organizational Excellence. | | | |Participation

Bus220 Final Exam

1011 words - 5 pages 27/30 correct BIS 220 Final Exam 1) Two information systems that support the entire organization are A. enterprise resource planning systems and dashboards B. transaction processing systems and office automation systems C. enterprise resource planning systems and transaction processing systems D. expert systems and office automation systems Answer: C 2) _______ is the direct use of information systems by employees in their work

The Power Of Influence And Team Work

5372 words - 22 pages direct marketing organization there is no brick and mortar location they can go in order to apply. Many now have websites but it’s likely that many people have never heard of the company. These companies only sell via word of mouth not with billboards, not with television ads and not with full page newspaper clippings. So how do businesses like these recruit new representatives? The same way they sell their product direct sales. Many of the

Customer Stisfaction

8502 words - 35 pages delivering, value to customers, and for managing customer relationships in ways that benefit the organization and its stake holders. e. improving the quality of life for consumers Answer: d Page: 6 Level of difficulty: Medium 4. Marketing management is ________. a. managing the marketing process b. monitoring the profitability of the companies products and services c. selecting target markets d. developing marketing

Thesis

4522 words - 19 pages machine utilization of 63% is quite low. Most manufacturers strive for at least an 85% machine utilization. If we could determine the cause(s) of this poor utilization, we might find a key to a dramatic increase in capacity. 6. Chase Manhattan Bank, Ch. 8, page 339 This very advanced and challenging scheduling problem can be solved most expeditiously using linear programming, preferably integer programming. Let F denote the number of full-time

Similar Documents

Oregon Bottle Bill Essay

978 words - 4 pages often recovered from solid waste and then returned for their refund value by someone else. Specific Provisions of the Law ♦ The deposit/refund applies to all beer and carbonated soft drink containers; ♦ Containers must be labeled with their minimum refund value. Most containers carry a $.05 refund value; ♦ Retailers must provide customers with a full refund for redeemed containers; ♦ Distributors must provide retailers with a refund for redeemed

Written Assignment

2236 words - 9 pages for each statement, indicate the response that best captures your behavior: 1, almost always; 2, often; 3, occasionally; 4, rarely; 5, never. _3__When I communicate with a person from another culture, I make an effort to keep an open mind and accept ambiguity in our interactions. (Ch. 6) _2__When engaging in intercultural communication, I listen carefully to what the other person is saying and adjust my communication to that person and our

Stuff Essay

1051 words - 5 pages and prepare personal financial statements. Identify cash management products and services. Complete a personal cash flow statement. Materials READING: Read Ch. 2 of Personal finance - Money Management Strategy and Skills: Putting Your Financial House in Order. READING: Read Ch. 4 of Personal finance - Managing Your Cash and Savings: Cash Management Strategies. WEB LINK: Toolwire® Student Resources Page TOOLWIRE: Toolwire

History 309 Essay

698 words - 3 pages Objectives: WEEK ONE SUBMITTED ____________________________________________________________________________________ WEEK TWO **Individual Assignment** 2.     Resources: Ch. 6–10 of Colonial America and MyHistoryLab  Write a 350- to 700-word essay response to each of the following questions:   Question 1: How was trade in the New World a source of revenue for monarchies and for the colonies? Question 2: What are