subject

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?

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 19:50
Write a car class having two private member variables called tank and speed. write public methods called pumpgas and gofast. the method pumpgas gets an integer for gas that must be pumped. that value needs to be added to tank (no more than 20 gallons). it must return the amount of gas that is purchased ($4 per gallon). the method gofast should increase the speed by 5 each time it is called.write a constructor for the above class that initialized both variables to zero.write a tostring to display both the tank and speed when the car is printed.modify the car class to implement the interface comparable and an interface called carinter having the public methods in carinter.write the main program to create an array of size 5 of type car. create 5 car objects having each location of the array to refer to one of the cars. test the pumpgas, gofast, equals method on the array items. write an enhanced loop to print all the car values (using a tostring written last time).write a generic method to find the minimum of four items. pass int, double, char, string and car objects to test this method.
Answers: 1
question
Computers and Technology, 23.06.2019 06:30
Martha is designing a single-player game. her manager suggests that she plan the design to incorporate future modifications. which principle of game design relates to planning for future modifications?
Answers: 1
question
Computers and Technology, 24.06.2019 12:30
Select all that apply. what two keys listed below should you use to enter data in an excel worksheet? tab backspace enter right arrow
Answers: 2
question
Computers and Technology, 25.06.2019 04:00
Plz there is a problem with my account. i no longer have ! ( hand,ambitious,virtuoso etc.) it's like getting brainliest means nothing. how do i get ranks back?
Answers: 1
You know the right answer?
Suppose the following logical relational data model having one universal relation in 1st normal form...
Questions
Questions on the website: 13722362