FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Design an appropriate set of normalized relation to represent the Material Supply Details. Decompose the following relation to First Normal Form (INF), Second Normal Form

Design an appropriate set of normalized relation to represent the Material Supply


Details. Decompose the following relation to First Normal Form (INF), Second Normal Form (2NF) and Third Normal Form (3NF).


Material (Material Id. Material Name,Units Of Measure, Standard Cost, Vendor Id, Vendor Name, Tel No,Email,Unit price, Terms Code, Terms) 


Based on Shipment relation below briefly explain THREE (3) different types of anomalies that occur in this unnormalized table.  


Shipment relation 


Shipment (ShipmentID, ShipmentDate, Expected Arrival Date, Origin, destination, ship#, Captianld, Captain Name, Item#, Type, description, weight, quantity)

Step by Step Solution

★★★★★

3.52 Rating (159 Votes )

There are 3 Steps involved in it

Step: 1

To design an appropriate set of normalized relations to represent the Material Supply chain we need to decompose the given relation into smaller more ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Information Systems

Accounting Information Systems

Authors: Ulric J. Gelinas, Richard B. Dull

10th edition

9781305176218, 113393594X, 1305176219, 978-1133935940

More Books

Students also viewed these Databases questions

Question

★★★★★
Table 4-5 shows a shipping manifest. Your assignment is as follows: a. Draw a relational schema and diagram the functional dependencies in the relation. b. In what normal form is this relation? c....

Answered: 1 week ago

Question

★★★★★
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...

Answered: 1 week ago

Question

★★★★★
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

Answered: 1 week ago

Question

★★★★★
Lacoste t-shirts come with an average price of $ 120 a piece, at their factory outlet with a std. deviation of $ 17. But at the Seasonal Sale (Discount) outlets of these t- shirts, it was also...

Answered: 1 week ago

Question

★★★★★
A dry gas containing 10.0% NH 3 by volume is contacted with water at 10C and 1 atm in a single-stage bubble contactor. The effluent liquid and gas streams may be considered to be in equilibrium with...

Answered: 1 week ago

Question

★★★★★
Describe social media, how they are used, and their relations to integrated marketing communications? LO.1

Answered: 1 week ago

Question

★★★★★
Habit Survey Interview three people who have changed a bad habit into a healthy habit. How did they achieve their success? How long did it take? Did they ever have a relapse? If so, what did they...

Answered: 1 week ago

Question

★★★★★
Green Gadgets Inc. is trying to decide whether to cut its expected dividends for next year from $8 per share to $5 per share in order to have more money to invest in new projects. If it does not cut...

Answered: 1 week ago

Question

★★★★★
Karen Peters bought their neighbor's farm for $400 000.00 down and payments of $57 100.00 at the end of every six months for 7 years. What is the purchase price of the farm if the semi-annual...

Answered: 1 week ago

Question

★★★★★
Regulators, in protecting the public interest, are examining Wincox Insurance Company's financial statements. These regulators impose requirements on Wincox's financial statements because of which...

Answered: 1 week ago

Question

★★★★★
Conduct research on New York City's large soda ban. Pretend you work at the Paradise City attorney's office. Draft a law that restricts the sale of large sugary drinks in Paradise City . Make sure to...

Answered: 1 week ago

Question

★★★★★
we look at how companies use CRM, SCM, and ERP to gain a competitive advantage and run more efficiently. Find an industry/business or company currently using one of those technologies (CRM, SCM,...

Answered: 1 week ago

Question

★★★★★
1. What are the practices that Xerox used in its TQM implementation? Discuss. 2. What are some barriers that you think Xerox has faced during TQM implementation? Relate them. 3. Does TQM...

Answered: 1 week ago

Question

★★★★★
An automobile manufacturer based in Lexington, Kentucky, wants to move production jobs from Japan to Mexico so that it can be more responsive to changing demands in its North American markets. Which...

Answered: 1 week ago

Question

★★★★★
Two weeks after they were told about the city's proposal to demolish the neighborhood playground and build a parking lot, Diana approached Tony as they were heading to another neighborhood...

Answered: 1 week ago

Question

★★★★★
#3. Test to see if there is a significant difference between the age of the participant and the age of the partner. Use a paired-sample t-test and an alpha level of 1%. How would you interpret the...

Answered: 1 week ago

Question

★★★★★
6. If collectability of the revenue is highly uncertain, an appropriate method that should be used to recognize revenue would be: (Points : 2) the percentage-of-completion method at the point of sale...

Answered: 1 week ago

Question

★★★★★
Should we separate the debt and equity features of convertible debt? Team 1: Pro separation: Present arguments in favor of separating the debt and equity features of convertible debt. Team 2: Against...

Answered: 1 week ago

Question

★★★★★
The following is a list of six control plans from this chapter or from Chapters 9 and 10. Control Plans A. Review shipped not billed sales orders B. Turnaround documents C. Deposit slip file D....

Answered: 1 week ago

Question

★★★★★
Control Plans A. Reconcile bank account B. Match invoice, PO, and receipt C. Tickler file of open POs and receiving reports D. Batch sequence check E. Procedures for rejected inputs F. Independent...

Answered: 1 week ago

Question

★★★★★
Describe how the GL/ BR process focuses more on information functions than operational functions. Contrast the GL/ BR with another business process (payroll, AP/ CD, B/ AR/ CR, and so on) to...

Answered: 1 week ago

Question

★★★★★
Green Corporation's assets are valued at $920,000 after payment of all corporate debts, except for $134,000 of taxes payable on net gains it recognized on the liquidation. Bruno, an individual and...

Answered: 1 week ago

Question

★★★★★
Rejoice, Inc., a private foundation, has existed for 10 years. Rejoice held undistributed income of $160,000 at the end of its 2015 tax year. Of this amount, $90,000 was distributed in 2016, and...

Answered: 1 week ago

Question

★★★★★
Rivera underpaid her income tax by $45,000. The IRS can prove that $40,000 of the underpayment was due to fraud. a. Determine Rivera's civil fraud penalty. b. Rivera pays the penalty five years after...

Answered: 1 week ago

Previous Question Next Question