The requirements for tal distributors have changed

Assignment Help Basic Computer Science
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?

 

Reference no: EM13839806

Questions Cloud

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?

Reviews

Write a Review

 

Basic Computer Science Questions & Answers

  Explaining reasonable values for items in risk register

Suggest reasonable values for the items in the risk register for this asset and threat, and provide justifications for your choices.

  Information system to use for stocks and trading futures

Write down some of the many considerations in selecting right information system to use for trading futures and stocks?

  Describe the inherent design issues across hci environments

Compare and contrast the design and development processes in HCI. Describe legal, societal, and ethical issues in HCI design. Describe the inherent design issues across HCI environments.

  Creating flowchart of data found on employee time cards

Create a flowchart depicting the following situations: The data found on employee time cards are keyed onto a hard disk before they are processed by a computer.

  Write down the vbscript code that employs a do until loop

question 1. write the vbscript code that uses a do until loop to display all of the integer values stored in the array

  The president is doing a good job

Add formats for Age (0-30, 31-50, 51-70, 71+), Party (D = Democrat, R = Republican), and Ques1-Ques4 (1=Strongly Disagree, 2=Disagree, 3=No Opinion, 4=Agree, 5=Strongly Agree)

  Design a program to produce a sales report

Design a program that will read a file of sales records and produce a sales report. Each record in the file contains a customer's ID, name, a sales amount, and a validated GST code.

  Create a document with two vertical frames

create a document with two vertical frames. create a series of links in the left frame. each button should represent a country and the right frame point to a source for that countries stats.

  Design a good device interface standard

Discuss why it is so difficult to design a good device interface standard. Provide a detailed example to support your findings. Include a question that responding students can reply to within your initial post

  Find a number alpha mod 8745437489 is not a primitive root

using a computer, show that 7 is a primitive root mod 8745437489. Find a number alpha mod 8745437489 that is not a primitive root

  You are working for country club

You are working for country club with thousands of members. You have been tasked with designing a database to keep track of the members and their guests.

  Illustrate and draw the transformation for each case

Illustrate and draw the transformation for each case.

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