Determine the functional dependencies

Assignment Help Basic Computer Science
Reference no: EM13922101

Give an example of a column A and a column B such that B is functionally dependent  on A. Give an example of a column C and a column D such that D is not fictionally dependent on C.

1. Using your knowledge of TAL Distributors, determine the functional dependencies that exist in the following table. After determining the functional dependencies, convert this table to an equivalent collection of tables that are in third normal form.

Item (ItemNum, Description, OnHand, Category, Price, (OrderNum, OrderDate, CustomerNum, CustomerName, RepNum, LastName, FirstName, NumOrdered, QuotedPrice))

2. List the functional dependencies in the following table that concern invoicing ( an application TAL Distributors is considering adding to its database). subject to the specified conditions. For a given invoice ( identified by the invoicenum), there will be a single customer. The customer's number, name, and complete address appear on the invoice, as does the date. Also, there may be several different items appearing on the invoice. For each item that appears, display the item number, description, price and number shipped. Each customer that orders a particular item pays the same price. Convert this table to an equivalent collection of tables that are in third normal form.

Invoice (invoiceNum, Customerum, LastName, FirstName, Street, City, State, PostalCode, Date, (ItemNum, Description, Price, NumShipped.))

3. 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 name 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: EM13922101

Questions Cloud

What can company do to induce juan to purchase more clothing : The Johnson Company is the sole producer of clothing. What can the company do to induce Juan to purchase more clothing? Show graphically. (The graph does not have to be exact.)
Departments that perform a single functional task : managers are responsible for departments that perform a single functional task and have employees with similar training and skills.
Discuss the operations of an insurance company : This week we discuss the operations of an insurance company. As stated before, the primary technique for risk management is transferring the risk, usually to an insurance company. Ask the risk manager of your company who provides the property insuran..
Financial ratios-identify some of financial strengths : Financial ratios help us identify some of the financial strengths and weaknesses of a company. Identify four ratios we can use and explain why they are important. Provide an example of each ratio used.
Determine the functional dependencies : Using your knowledge of TAL Distributors, determine the functional dependencies that exist in the following table. After determining the functional dependencies, convert this table to an equivalent collection of tables that are in third normal for..
Discuss kurt lewin change process model : What are two reasons that Maxene gives for thinking it is important for different learning styles to be recognized? How does identifying the intended outcomes of a training shape the training itself? Discuss Kurt Lewin's change process model and how ..
Market risk premium-required return on genetics stock : Wendy purchased 800 shares of Robotics Stock at $3 per share on 1/1/09. Wendy sold the shares on 12/31/09 for $3.45. Genetics stock has a beta of 1.3, the risk-free rate of return is 3%, and the market risk premium is 8%. The required return on Genet..
Trading, profit and loss account for the year ended 30 june : Trading, profit and loss account for the year ended 30 June 2000. Hire purchase debtors account, Repossessions account.
Straight fromprograms or software packages : Show all of your work and reasoning. In particular, when there arecalculations involved, you must show how you come up with your answerswith critical work and/or necessary tables. Answers that come straight fromprograms or software packages will n..

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Identifies the cost of computer

identifies the cost of computer components to configure a computer system (including all peripheral devices where needed) for use in one of the following four situations:

  Input devices

Compare how the gestures data is generated and represented for interpretation in each of the following input devices. In your comparison, consider the data formats (radio waves, electrical signal, sound, etc.), device drivers, operating systems suppo..

  Cores on computer systems

Assignment : Cores on Computer Systems:  Differentiate between multiprocessor systems and many-core systems in terms of power efficiency, cost benefit analysis, instructions processing efficiency, and packaging form factors.

  Prepare an annual budget in an excel spreadsheet

Prepare working solutions in Excel that will manage the annual budget

  Write a research paper in relation to a software design

Research paper in relation to a Software Design related topic

  Describe the forest, domain, ou, and trust configuration

Describe the forest, domain, OU, and trust configuration for Bluesky. Include a chart or diagram of the current configuration. Currently Bluesky has a single domain and default OU structure.

  Construct a truth table for the boolean expression

Construct a truth table for the Boolean expressions ABC + A'B'C' ABC + AB'C' + A'B'C' A(BC' + B'C)

  Evaluate the cost of materials

Evaluate the cost of materials

  The marie simulator

Depending on how comfortable you are with using the MARIE simulator after reading

  What is the main advantage of using master pages

What is the main advantage of using master pages. Explain the purpose and advantage of using styles.

  Describe the three fundamental models of distributed systems

Explain the two approaches to packet delivery by the network layer in Distributed Systems. Describe the three fundamental models of Distributed Systems

  Distinguish between caching and buffering

Distinguish between caching and buffering The failure model defines the ways in which failure may occur in order to provide an understanding of the effects of failure. Give one type of failure with a brief description of the failure

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