Functional dependency: A column “X” is said to be functionally dependent on another column “Y”, when at any point of time, a value for “X” determines a single value for “Y”. In other words, a column “X” is said to be functionally dependent on another column “Y”, when two tuples agree on attribute “X” values then they should also agree on attribute “Y” values. It is usually represented as “XY”, where the terms “X” and “Y” are composite. It can be said as either “Y” is functionally dependent on “X” or as “X” functionally determines “Y”. Normalization: Normalization refers to the method of representing a database in the terms of relations, which are in the standard normal forms. It is organized in a table manner to reduce data redundancy and data dependency. Third Normal Form (3NF): A table or a relation is said to be in third normal form if and only if it is in second normal form and if the candidate keys are its only determinants.

Question

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(ITEM_ID, DESCRIPTION, ON_HAND, CATEGORY, LOCAITON, PRICE,(INVOICE_NUM, INVOICE_DATE, CUST_ID, FIRST_NAME, LAST_NAME, QUANTITY, QUOTED_PRICE))

Answer 1

Question

Chapter 2, Problem 4TD

Program Plan Intro

Functional dependency:

A column “X” is said to be functionally dependent on another column “Y”, when at any point of time, a value for “X” determines a single value for “Y”.

In other words, a column “X” is said to be functionally dependent on another column “Y”, when two tuples agree on attribute “X” values then they should also agree on attribute “Y” values.

It is usually represented as “XY”, where the terms “X” and “Y” are composite.

It can be said as either “Y” is functionally dependent on “X” or as “X” functionally determines “Y”.

Normalization:

Normalization refers to the method of representing a database in the terms of relations, which are in the standard normal forms.

It is organized in a table manner to reduce data redundancy and data dependency.

Third Normal Form (3NF):

A table or a relation is said to be in third normal form if and only if it is in second normal form and if the candidate keys are its only determinants.

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Students have asked these similar questions

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(ITEM_ID, DESCRIPTION, ON_HAND, CATEGORY, LOCAITON, PRICE,(INVOICE_NUM, INVOICE_DATE, CUST_ID, FIRST_NAME, LAST_NAME, QUANTITY, QUOTED_PRICE))

Determine the functional dependencies that exist in the following table and then convert this table to an equivalent collection of tables that are in third normal form. Office (OFFICE_NUM, OFFICE_NAME, (ADDRESS, SQR_FT, BDRMS, FLOORS, MONTHLY_RENT, OWNER_NUM)

Determine the functional dependencies that exist in the following table and then convert this table to an equivalent collection of tables that are in third normal form. OFFICE (OFFICE_NUM, OFFICE_NAME, (ADDRESS, SQR_FT, BDRMS, FLOORS, MONTHLY_RENT, OWNER_NUM))