Reference no: EM13839806
The requirements for TAL distributors have changed. A number and a name now identify each storehouse. Units of each item may be stored in multiple storehouses, and it is important to know precisely how many items are stored in each storehouse. I addition, TAL Distributors needs to know the number view full and anme of each supplier as well as the expected lead time for delivering each item. (Lead time is the amount of time a suppliers, and each supplier can supply many items. Using this information, convert the following unormalized relation to fourth normal form: Item( ItemNum, Description, Category, Price, (StorehouseNum, StorehouseName, OnHand), (SupplierNum, SupplierName, LeadTime))
4. What changes would you need to make to the normalized table to support the following additional requirements:
a. TAL needs to keep track of the price a supplier charges for an item. Different suppliers can charge different prices for the same item.
b. Each storehouse has a manager who is identified by a manager number, a manger last name, and a manager first name.
5. TAL distributors is considering changing its business model so that many sales reps can represent one customer and one sales rep can represent many cutomers. Using this information, convert the following unnormalized relation to fourth normal form.
Customer ( CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, (RepNum, LastName, FirstName, Street, City, State, PostalCode, Comission, Rate))
6. Convert the following unnormailzed relation to fourth normal form using the same requirements as in Question 5 (many sales reps can represent one customer and one sales rep can represent many customers)
Rep (RepNum, LastName, FirstName, Street, City, State, Postalcode,Commission, Rate, (CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit))
7. Is there any difference between the tables you created in Question 5 and 6? Why or Why not?
|
Futures contracts and options contracts
: Futures contracts and options contracts can be used to modify risk. Identify the fundamental distinction between a futures contract and an option contract, and briefly explain the difference in the manner that futures and options modify portfolio ris..
|
|
Short-run if customer’s incomes increases
: Assume that apples are an inferior good. Draw a perfectly competitive market for apples and a firm selling apples in the long run equilibrium where price is $10 and the firm’s equilibrium quantity is 50. EXPLAIN what happens in the short-run if custo..
|
|
Identify all nash equilibria for the road trip game
: Consider a group of 10 friends who are considering going on a road trip (is that still a thing you kids do these days, or do you just sit around and look computers?). In determining whether or not to go, each friend considers both how much they would..
|
|
Define an interest rate swap
: Define an interest rate swap, and briefly describe the obligation of each party involved. Cite and explain two examples of how interest rate swaps could be used by a fixed- income portfolio manager to control risk or improve return.
|
|
The requirements for tal distributors have changed
: The requirements for TAL distributors have changed. A number and a name now identify each storehouse. Units of each item may be stored in multiple storehouses, and it is important to know precisely how many items are stored in each storehouse. I addi..
|
|
What is the pw of the flow
: A set of cash flows begins at $200,000 at the end of year 1. It deceases by 10% at the end of year 2 and so on, until n = 10 years. If the MARR = 8%, what is the PW of the flow? Lucky Linda, a very good Avon salesperson, is averaging $100,000 per yea..
|
|
List two challenges an os faces when passing parameters
: One challenge being that if the amount of parameters could exceed the amount of registers, than you pass the parameters through a block of memory rather than registers, and pass the address of the block of memory through a single register. I honestly..
|
|
Calculate the value of the forward contract for the investor
: Should the investor buy or sell the forward contract to protect the value of the bond against rising interest rates during the holding period? Calculate the value of the forward contract for the investor at the maturity of the forward contract if Van..
|
|
How many must be sold for the publisher to break even
: The publisher of a new book figures fixed cost at $92,000 and variable cost at $2.10 for each book produced. If the book is sold to distributors for $15 each, how many must be sold for the publisher to break even?
|