Customer ( CustomerRef , CustomerFirstName , CustomerSurname , CustomerAddress ,

Question

Customer (CustomerRef , CustomerFirstName , CustomerSurname , CustomerAddress , CustomerTel)

OrderItemNo(OderItemNo, OderNo, PartNo, OrderQty)

Orders (OrderNo, CustomerRef, OrderDate)

PartTypes (PartTypeCode, PartTypeDescription)

PurchaseOder(PONo , PODate , PartNo , POQty)

Supplier(SupplierRef, SupplierName, SupplierAddress, SupplierContact, SupplierTel)

Part(PartNo, PartName, PartUnit, SupplierRef, StockLevel, MinStockLevel, CosttPrice, SalePrice, Location, PartType)

Q : write the function dependances.

Explanation / Answer

Here are all the function dependencies listed:

customerRef -> customerFirstName, customerRef -> CustomerSurname , customerRef -> customerAddress, customerRef -> cutomerTel
OrderItemNo -> orderNo, OrderItemNo ->PartNo , OrderItemNo -> orderQty
orderNo -> CustomerRef, orderNo -> OrderDate
PartTypeCode -> PartTypeDescription
PONo -> PODate , PONo -> PartNo , PONo ->POQty
SupplierRef->SupplierName, SupplierRef->SupplierAddress,SupplierRef->SupplierContact, SupplierRef->SupplierTel
PartNo->PartName,PartNo->PartUnit,PartNo->SupplierRef,PartNo->StockLevel,PartNo->MinStockLevel,PartNo->CosttPrice,PartNo->SalePrice,PartNo->Location,PartNo->PartType

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

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