Consider the schema R = (A, B, C, D, E, G) and the set F of functional dependencies: AB → CD
B → D
DE → B
DEG → AB
AC → DE
R is not in BCNF for many reasons, one of which arises from the functional
dependency AB → CD. Explain why AB → CD shows that R is not in BCNF and then
use the BCNF decomposition algorithm starting with AB → CD to generate a BCNF
decomposition of R. Once that is done, determine whether your result is or is not
dependency preserving, and explain your reasoning.

Determine the time of the day and month of the year at which the peak sensible cooling load occurs for a top floor, north-eastern corner room of an office building in durban for the following conditions: floor area: 8 x 8 x 3 m east and north walls: 115 mm face brick (outside), 20 mm air space, 115 mm ordinary brick (inside) with 15 mm plaster roof construction: suspended plasterboard ceiling, 450 mm air space, 150 mm concrete, 75mm screed, waterproofing no heat transfer across other surfaces window area 3x 1,5 m high in north wall only. ordinary glass with venetian blinds. lights and occupants : from 07: 00 to 18: 00 average light density: 25 w/m2 number of occupants : 5 seated, light office work room temperature 24°c