Solutions
Chapter 4
4.1.1
4.1.2
a)
b)
c)
In c we assume that a phone and address can only belong to a single customer (1-
m relationship represented by arrow into customer).
d)
In d we assume that an address can only belong to one customer and a phone can
exist at only one address.
If the multiplicity of above relationships were m-to-n, the entity set becomes
weak and the key ssNo of customers will be needed as part of the composite key
of the entity set.
In c&d, we convert attributes ...


雷达卡




京公网安备 11010802022788号







