Suppose the following logical relational data model having one universal relation in 1st normal form: Car(V incode, Model, Colour, Engine, Doors)

All attributes are functionally dependent on V incode attribute (i. e. the V incode is the (only) key of the relation). Moreover, the attribute Doors is functionally dependent on attribute Model (ie. two cars of the same model have to necesarilly have the same number of doors).

a. Is the above relation in 2nd normal form?
b. Is the above relation in 3rd normal form? Why?
c. If not, how the logical relational model should be changed to achieve at least the 3rd normal form?

The total cost of textbooks for the term was collected from 36 students. create a histogram for this data. $140 $160 $160 $165 $180 $220 $235 $240 $250 $260 $280 $285 $285 $285 $290 $300 $300 $305 $310 $310 $315 $315 $320 $320 $330 $340 $345 $350 $355 $360 $360 $380 $395 $420 $460 $460

Which database model is best used for data warehouse and data mining

Assume the existence of a bankaccount class. define a derived class, savingsaccount that contains two instance variables: the first a double, named interestrate, and the second an integer named interesttype. the value of the interesttype variable can be 1 for simple interest and 2 for compound interest. there is also a constructor that accepts two parameters: a double that is used to initialize the interestrate variable, and a string that you may assume will contain either "simple", or "compound", and which should be used to initialize the interesttype variable appropriately. there should also be a pair of functions getinterestrate and getinteresttype that return the values of the corresponding data members (as double and int respectively).