1. Consider the relation DiskDrive(SerialNum,Manufacturer,Model,Batch,Capacity,Retailer). Each tuple in the relation contains information about a disk drive with...
Question:
1. Consider the relation
DiskDrive(SerialNum,Manufacturer,Model,Batch,Capacity,Retailer).
Each tuple in the relation 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 tuple ('1978619', 'Western Digital', 'A2235X', '765234', 500, 'CompUSA') specifies that Western Digital made a disk drive with serial number 1978619 and model number A2235X, released in batch 765234. It is 500GB and is sold by CompUSA. Write each of the following dependencies as a functional dependency:
a. The manufacturer and serial number together uniquely identify the drive.
b. A model number is registered by a manufacturer and therefore can’t be used by another manufacturer.
c. All disk drives in a batch are the same model.
d. All disk drives of a certain model of a particular manufacturer have the same listed capacity.
2.
a. Give a complete 2NF decomposition for the disk drive relation of problem 1.
b. If the relation from 1a. is not in give a complete 3NF decomposition