Question: Consider the relation DISK _ DRIVE ( Serial _ number, Manufacturer, Model, Batch, Capacity, Retailer ) . Each tuple in the relation DISK _ DRIVE
Consider the relation DISKDRIVESerialnumber, Manufacturer, Model, Batch, Capacity, Retailer Each tuple in the relation DISKDRIVE contains information about a disk drive with a unique Serialnumber, made by a manufacturer, with a particular model number, released in a certain batch, which has a certain storage capacity and is sold by a certain retailer. For example, the tupleDiskdriveWesternDigitalAXCompUSAspecifies that WesternDigital made a disk drive with serial number and model number AX released in batch ; it is GB and sold by CompUSA. Write each of the following dependencies as an FD: i The manufacturer and serial number uniquely identify the drive. ii A model number is registered by a manufacturer and therefore cant be used by another manufacturer. iii All disk drives in a particular batch are the same model. iv All disk drives of a certain model of a particular manufacturer have exactly the same capacity.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
