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. a)What are the candidate keys for the table? State why they are candidate keys. b)What normal form is the Warehouse table in? Justify your answer by referring to specific dependencies for the table. (c) It is suggested that the Warehouse table be split into two tables. One table is to have attributes Size, Colour and the other to have attributes Location, Size. Explain briefly any advantages or disadvantages of this suggestion
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
a)What are the candidate keys for the table? State why they are candidate keys.
b)What normal form is the Warehouse table in? Justify your answer by referring to specific dependencies for the table.
(c) It is suggested that the Warehouse table be split into two tables. One table is to have attributes Size, Colour and the other to have attributes Location, Size. Explain briefly any advantages or disadvantages of this suggestion.
Step by step
Solved in 2 steps
