4. This exercise asks you to convert business statements into dependencies 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 tuple Disk-drive (1978619", "WesternDigital, A2235X', 765234, 500, "CompUSA') specifies that WesternDigital made a disk drive with serial number 1978619 and model number A2235X, released in batch 765234; it is 500GB and sold by CompUSA. Write each of the following dependencies as an FD a) The manufacturer and serial number uniquely identifies 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 particular batch are the same model d) All disk drives of a certain model of a particular manufacturer have exactly the same capacity. 5. Consider the following relation CAR_SALE (Car id, Option_type, Option_listprice, Sale_date, Option discountedprice) This relation refers to options installed in cars (e.g., cruise control) that were sold at a dealership and the list and discounted prices of the options. If CarlD ? Sale date Option_type-Option_listprice CarID, Option type- Option discountedprice Argue using the generalized definition of the 3NF that this relation is not in 3NF. Then argue from your knowledge of 2NF, why it is not even in 2NF