Please answer the following

In this relation, a tuple describes a visit of a patient to a doctor along with a treatment code and daily charge. Assume that diagnosis is determined (uniquely) for each patient by a doctor. Assume that each treatment code has a fixed charge (regardless of patient). Is this relation in 2NF? Justify your answer and decompose if necessary. Then argue whether further normalization to 3NF is necessary, and if so, perform it. Problem #2: Consider the following relation: CAR_SALE (CarlD, Option type, option., Listprice, Sale date, Discounted price) This relation refers to options installed on cars (e.g.- cruise control) that were sold at a dealership and the list and discounted prices for the options. If CarlD rightarrow Sale date and Option type rightarrow Option. Listprice, and CarlD, Option type rightarrow Discounted price, 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 in 2NF. Problem #3: Consider the relation: BOOK (Book Name, Author, Edition, Year) with the data: a. Based on a common-sense understanding of the above data, what are the possible candidate keys of this relation? b. Does the above have one or more functional dependency (do not list FDs by applying derivation rules)? If so, what is it? Show how you will remove it by decomposition. c. Does the resulting relation have an MVD? If so, what is it? d. What will the final decomposition look like