Question: DiskDrive ( serialNumber , manufacturer, model, batch, capacity, retailer ) . Each tuple in the rela 8 on DiskDrive contains informa 8 on about a

DiskDrive(serialNumber, manufacturer, model, batch, capacity, retailer).
Each tuple in the rela8on DiskDrive contains informa8on about a disk drive with a unique serialNumber, made by a manufacturer, with a par8cular model, released in a certain batch, which has a certain storage capacity, and is sold by a certain retailer. For example, the tuple DiskDrive(1978619, WesternDigital, A2235X,765234,500, BestBuy) specifies that WesternDigital made a disk drive with serial number 1978619, model number A2235X in batch 765235 with 500GB that is sold by BestBuy.
Write each of the following dependencies as an FD:
a. The manufacturer and serial number uniquely iden8fies 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 par8cular batch are the same model.
d. All disk drives of a par8cular model of a par8cular manufacturer have exactly the same capacity.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!