A clothing manufacturer produces woollen jumpers in a variety of sizes and colours. These are stored in a warehouse and each location in the warehouse contains jumpers that are all the same colour and all the same size. Each of the different sizes is available in all the different colours, and each combination of size and colour can be found in only one location in the warehouse. The manufacturer uses a relational database to record information about what is stored in each location in the warehouse. There is a table, Warehouse, with three attributes: Size, Colour, Location. Below are listed four possible functional dependencies for the table. Not all of these hold. For each dependency, state whether it holds or not. Justify the reason for your decision in each case by referring to the description at the start of the question. Location → Size, Colour Location, Size → Colour Colour, Size → Location Colour → Size, Location
A clothing manufacturer produces woollen jumpers in a variety of sizes and colours. These are stored in a warehouse and each location in the warehouse contains jumpers that are all the same colour and all the same size. Each of the different sizes is available in all the different colours, and each combination of size and colour can be found in only one location in the warehouse. The manufacturer uses a relational
Below are listed four possible functional dependencies for the table. Not all of these hold. For each dependency, state whether it holds or not. Justify the reason for your decision in each case by referring to the description at the start of the question.
Location → Size,
Colour Location,
Size → Colour Colour,
Size → Location Colour → Size, Location
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
