ables : Customer ( CustomerRef , CustomerFirstName , CustomerSurname , CustomerA

Question

ables :

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 : Identify the candidate key(s) of based on the Functional Dependencies. You need to use the concept of attribute closure to identify the key(s). Intermediate steps in this process should be detailed.

Explanation / Answer

Candidate key refers to the uniqueness which is formed by taking a column or mroe than one columns in a table.

Here in this table

Customer

CustomerRef and CustomerFirstName

OrderItemNo

OderItemNo and OderNo

Orders

OrderNo and CustomerRef

PartTypes

PartTypeCode

PurchaseOder

PONo and PODate and PartNo

Supplier

SupplierRef and SupplierName

Part

PartNo and SupplierRef

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

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