I was wondering if you would be able to answer my questions? I am determining pa

Question

I was wondering if you would be able to answer my questions? I am determining partial and transitive functional dependencies in a table that consists of Purchase Order ID and Item Code as Primary Keys. I have attributes of Purchase Order Date, Supplier ID, Supplier Name, Item Description, Unit Price, Qty Ordered, and Comment. My question is if I have Comment as an attribute would it be a partial or transitive functional dependency? Also just to verify Unit Price and Qty Ordered would be partial dependents of Item Code? Please and Thank You.

Explanation / Answer

Hi,

Purchase Order ID

PK

Item Code

PK

Purchase Order Date

Supplier ID

Supplier Name

Item Description

Unit Price

Qty Ordered

Comment

So after converting them to Normal Forms we can have:

Purchase Order ID

Purchase Order Date

Item Code

Item Description

Unit Price

Qty Ordered

Comment

Here, the partial dependency

Item code -> Comment

So, the comment attribute will be partial dependency.

Also,

Unit Price, Qty Ordered is Partial dependents on Item Code.

Unit Price, Qty Ordered -> Item Code

Supplier ID

Supplier Name

Please let me know if you need further clarification.

Happy Chegging!

Purchase Order ID

PK

Item Code

PK

Purchase Order Date

Supplier ID

Supplier Name

Item Description

Unit Price

Qty Ordered

Comment

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.