Question: Consider the relation DISK _ DRIVE ( Serial _ number, Manufacturer, Model, Batch, Capacity, Retailer ) . Each tuple in the relation DISK _ DRIVE

Consider the relation DISK_DRIVE(Serial_number, Manufacturer, Model, Batch, Capacity, Retailer). Each tuple in the relation DISK_DRIVE contains information about a disk drive with a unique Serial_number, 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 tupleDisk_drive(1978619,WesternDigital,A2235X,765234,500,CompUSA)specifies that WesternDigital made a disk drive with serial number 1978619and model number A2235X, released in batch 765234; it is 500GB 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 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 Programming Questions!