CSc 4710/6710 Database Systems
Fall 2011
HW 6
Due: November 1, 2011 (Tuesday)
Solve problems 7.17 (page 235) and 7.34 (page 242-243) of EN textbook.

pages 235, 242, and 243 of EN textbook

Fig 7.5 is as follows:

{
Address_phone({
               Phone(Area_code,
                     Phone_number)
              },
              Address(Street_address(Number,
                                     Street,
                                     Apartment_number),
              City,
              State,
              Zip))
}

Note that in this figure the {x} notation is used for a multi-valued attribute and a(a1,...,an) is used for composite attribute. Complex attributes are a mixture of multi-valued and composite attributes.