Question: DiskDrive ( serialNumber , manufacturer, model, batch, capacity, retailer ) . Each tuple in the rela 8 on DiskDrive contains informa 8 on about a
DiskDriveserialNumber manufacturer, model, batch, capacity, retailer
Each tuple in the relaon DiskDrive contains informaon about a disk drive with a unique serialNumber, made by a manufacturer, with a parcular model, released in a certain batch, which has a certain storage capacity, and is sold by a certain retailer. For example, the tuple DiskDrive WesternDigital, AX BestBuy specifies that WesternDigital made a disk drive with serial number model number AX in batch with GB that is sold by BestBuy.
Write each of the following dependencies as an FD:
a The manufacturer and serial number uniquely idenfies the disk drive and its features
b A model number is registered by a manufacturer and hence cant be used by another manufacturer.
c All disk drives in a parcular batch are the same model.
d All disk drives of a parcular model of a parcular 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
