Question

Need to find the partial and transitive dependencies of the following fields:

cust_code = code that identifies a customer

cus_lname = customer last name

cus_areacode = area code of the 7 digit phone number of a customer

cus_initial = customer initials

cus_balance = balance to be paid by the customer

cus_phone = 7 digit phone number

cus_fname = customer first name

inv_number = number representing an invoice

inv_date = date of the invoice

line_number = an invoice contains many items of sale; each sale is written as a line in an invoice with a number that identifies the particular sale line

line_units = number of units bought of the particular product in that line

P_code = product code

line_price = each line represents a product number of units, hence the line's total price

P_QOH = Quantity On Hand (for stock purposes)

P_discount = product specific discount

v_code = vendor code

p_price = price of the product

p_min = minimum number of units to be in stock (for ordering purpose)

p_description = description of the product

p_indate = when the product came in last time

v_code = vendor code

v_contact = contact info of vendor

v_phone = vendor phone number

v_order = last vendor order number

v_state = state of vendor

v_areacode = area code of vendor

Answer 1

cust_code , cus_lname, cus_initial , cus_fname

Cust code---->cus_areacode

cust_code--->cus_balance

cust_code------->cus_phone

cust code determines, lname,fname,initial therefore parital dependency exits

cust code determines cus_areacode,custbalance,customer phone therefore parital dependency exits between custcode to all other customer related attributes.

inv_number is a primary which determines the following attributes ,

thus inv_date ,line_number and line_units are partially dependent on inv_number

Transitive dependency exits betwen line_number and line_units because nonprimary key determines another attribute.Here line number is non primary key.

P_code determines P_discount,p_price ,p_description so they are partially dependent on p code

p_code--> P_Qoh, p_min, p_indate //partial dependency

p_code-->line_price //partial dependency

V_code determines v_contact, V_phone, V_state, V-area code //partial dependency

Transitive dependencyexists between V_order and line number ,line units, lineprice

v_code

p_price

p_min

p_description = description of the product

p_indate =