Re: Functional dependencies
Date: Mon, 05 Jan 2004 15:48:21 +0100
Message-ID: <btbtel$ohd$00$1_at_news.t-online.com>
You first need to break this down into to managable Entities,
perhaps one each for Equipment, Manafacturer, Buyer, Department as these
are real world entities,
Each of these entities will possibly have a unique value, (key) For
example Equip ID for the 'unit of' equipment.
A functional dependency is a constraint between two sets of attributes
from the database. From the above suggested Entities and their
attributes we could identify the following FDs
the Equip ID determines the EquipmentModel
the ManufacturerID determines the ManufacturerName
the BuyerName determines the BuyerPhone,
Burim wrote:
> Please can you help me!
> In this relation:
>
> Equipment(EquipID, EquipmentModel, ManufacturerID, ManufacturerName,
> DateInstallation, BuyerName, BuyerPhone, DepartmentInstallation,
> AddressDepartmentInstallation)
>
> to show functional dependencies.
>
>
>
Received on Mon Jan 05 2004 - 15:48:21 CET