The materials manager at Tricky Pee Furniture Company maintains a list of suppliers for each of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The materials manager at Tricky Pee Furniture Company maintains a list of suppliers for each of the material items purchased by the company from outside vendors. Table 4-7 shows the essential data required for this application. Tricky Pee Furniture Company Attribute Name Sample Value Material ID 3792 Material Name Hinges 3" locking Unit of Measure each Standard Cost $5.00 Vendor ID V300 Vendor Name Apex Hardware Unit Price $4.75 Terms Code 1 Terms COD a. Draw a dependency diagram for this data. You may assume the following: Each material item has one or more suppliers. Each supplier may supply one or more items or may not supply any items. • The unit price for a material item may vary from one vendor to another. • The terms code for a supplier uniquely identifies the terms of the sale (e.g., code 2 means 10 percent net. b. Decompose this diagram into a set of diagrams in 3NF. c. Draw an ERD diagram of the above situation. d. Create the tables and populate the tables with sample data. [PLEASE I WANT THE ANSWER IN RED ONLY] The materials manager at Tricky Pee Furniture Company maintains a list of suppliers for each of the material items purchased by the company from outside vendors. Table 4-7 shows the essential data required for this application. Tricky Pee Furniture Company Attribute Name Sample Value Material ID 3792 Material Name Hinges 3" locking Unit of Measure each Standard Cost $5.00 Vendor ID V300 Vendor Name Apex Hardware Unit Price $4.75 Terms Code 1 Terms COD a. Draw a dependency diagram for this data. You may assume the following: Each material item has one or more suppliers. Each supplier may supply one or more items or may not supply any items. • The unit price for a material item may vary from one vendor to another. • The terms code for a supplier uniquely identifies the terms of the sale (e.g., code 2 means 10 percent net. b. Decompose this diagram into a set of diagrams in 3NF. c. Draw an ERD diagram of the above situation. d. Create the tables and populate the tables with sample data. [PLEASE I WANT THE ANSWER IN RED ONLY]
Expert Answer:
Answer rating: 100% (QA)
aDependency Diagram b Decomposed diagram c ERD diagra... View the full answer
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date:
Students also viewed these databases questions
-
Each of the following independent situations has one or more control activity weaknesses. 1. Board Riders Ltd. is a small snowboarding club that offers specialized coaching for snowboarders who want...
-
The materials manager at Pine Valley Furniture Company maintains a list of suppliers for each of the material items purchased by the company from outside vendors. Table 4-7 shows the essential data...
-
Each of the following independent situations has one or more internal control weaknesses: 1. Board Riders is a small snowboarding club that offers specialized coaching for teenagers who want to...
-
A square duct, 30 cm by 30 cm, is maintained at a constant temperature of 30oC and an airstream of 50oC and 1 atm is forced across it with a velocity of 6 m/s. Calculate the heat gained by the duct....
-
In the article "A Multifactorial Intervention Program Reduces the Duration of Delirium, Length of Hospitalization, and Mortality in Delirious Patients" (Journal of the American Geriatrics Society,...
-
What kind of structure, controls, and culture would you be likely to find in (a) a small manufacturing company, (b) a chain store, (c) a high-tech company, and (d) a Big Four accounting firm?
-
Define demand-side and supply-side policies. Are there any ways in which such policies are incompatible?
-
Prepare journal entries to record the following transactions involving the short- term securities investments of Krum Co., all of which occurred during year 2013. a. On August 1, paid $450,000 cash...
-
What is one fundamental right under the U.S. Constitution, the Bill of Rights, or a U.S. Supreme Court case. What does it mean? Where can it be found? What are the limitations of that right? Please...
-
Morgan Dance Inc. provides ballet, tap, and jazz dancing instruction to promising young dancers. Morgan began operations in January 2012 and is preparing its monthly financial statements. The...
-
Suppose the risk-free rate of returns is 7% , the average rate of return on the stock market is 11% . If a mutual fund has a beta of 1.3 , what is the value of its required rate of return? What is...
-
What is inheritance in object-oriented programming and why is it useful? 2) How can we tell if inheritance is being used when we look at Java code? 3) What methods or data is being inherited in...
-
Sivin Even manufactures diapers. The company incurs average variable costs of 60. Sivin Even has annual fixed costs of 702,000. The company currently sells an average of 10,000 units and has...
-
Explain how the use of an antimicrobial drug can alter the phenotype of the population of cells to one that is resistant. provide examples
-
Camille has just bought a week old puppy and is monitoring its weight. At one week old it weighs 500 grams. Each week its weight increases by 40%. Give the equation for the dogs weight in terms of...
-
Make a list of 5 topics, peoples, events, or ideas that you believe a teacher must cover in order to effectively teach the American Revolution. Find 1 primary source and 1 secondary source for each...
-
If the return on asset (ROA) is 10%, the pre-tax cost of debt is 8%, and the corporate tax rate is 20%. What will the return on equity (ROE) be if the capital structure is 100% equity and 0% debt
-
Nitrogen monoxide reacts with hydrogen as follows: 2NO(g)+ H2(g) N2O(g) + H2O(g) The rate law is [H2]/ t = k[NO]2[H2], where k is 1.10 107 L2/(mol2s) at 826oC. A vessel contains NO and H2 at...
-
Describe a relational DBMS (RDBMS), its underlying data model, its data storage structures, and how data relationships are established.
-
What are the special guidelines for naming relationships?
-
The following attributes form a relation that includes information about individual computers, their vendors, software packages running on the computers, computer users, and user authorizations....
-
For each of the following transactions, state the type of error being made. (a) Payment to A Johnson for 45 missed out of accounts. (b) Returns inwards from F Ressmeyer of 43 entered in both accounts...
-
For Morris Ltd, the following machinery is purchased: Depreciation is to be charged at 20% on cost based on the value of machinery at the end of year. No depreciation is provided in the year of...
-
For each of the following transactions, state the type of error being made. (a) Carriage inwards of 45 entered in both accounts as 67. (b) Purchases on credit of 32 from S Nutt was debited to Nutts...
Study smarter with the SolutionInn App