Functional Dependency - Examples - Cars

Cars

Suppose one is designing a system to track vehicles and the capacity of their engines. Each vehicle has a unique vehicle identification number (VIN). One would write VINEngineCapacity because it would be inappropriate for a vehicle's engine to have more than one capacity. (Assuming, in this case, that vehicles only have one engine.) However, EngineCapacityVIN, is incorrect because there could be many vehicles with the same engine capacity.

This functional dependency may suggest that the attribute EngineCapacity be placed in a relation with candidate key VIN. However, that may not always be appropriate. For example, if that functional dependency occurs as a result of the transitive functional dependencies VIN → VehicleModel and VehicleModel → EngineCapacity then that would not result in a normalized relation.

Read more about this topic:  Functional Dependency, Examples

Other articles related to "cars, car":

Olsen Gang - Norwegian Films
... the main sponsor by looking at the villain's cars, the security cars, the police cars, the gang's car, and so on ... the main sponsor of the film series, supplying the films with civilian cars parked on the sidewalks, Crowns as taxis, Toyota Cressida as police cars, Hiace as ...
2007 24 Hours Of Le Mans - Race - Night
... A third safety car period was caused by the Creation Autosportif entry, which ran into the tire barriers at the Porsche Curves and needed to be extracted ... when it briefly stopped at the pit entrance during the caution period, blocking other cars attempting to make their own pit stops ... the night continued and the race neared its halfway point, many cars suffered mechanical failures, putting them out of the race ...
Uber (company)
... Uber drivers have cars such as Lincoln Town Cars, Cadillac Escalades, BMW 7 Series, and Mercedes-Benz S550 sedans ... Cars are reserved by sending a text message or by using a mobile app ... Using the apps, customers can track their reserved car's location ...
Scottish Aviation - Cars
... Between 1964 and 1966 Scottish Aviation designed a small battery-electric car, the Scottish Aviation Scamp, of which twelve pre-production examples ...

Famous quotes containing the word cars:

    When, at rare intervals, some thought visits one, as perchance he is walking on a railroad, then, indeed, the cars go by without his hearing them. But soon, by some inexorable law, our life goes by and the cars return.
    Henry David Thoreau (1817–1862)

    Billboards, billboards, drink this, eat that, use all manner of things, everyone, the best, the cheapest, the purest and most satisfying of all their available counterparts. Red lights flicker on every horizon, airplanes beware; cars flash by, more lights. Workers repair the gas main. Signs, signs, lights, lights, streets, streets.
    Neal Cassady (1926–1968)

    The startings and arrivals of the cars are now the epochs in the village day.
    Henry David Thoreau (1817–1862)