
Questions
1. A table is to contain information about employees, including their qualifications
and the dates on which the qualifications were acquired. Comment on the relative
merits of the following table structures:
Employee1 (employeeNo, qualification, dateAcquired)
Employee2 (employeeNo, qual1, date1, qual2, date2, qual3, date3)
(2 min)
2. A table is to hold the dates of birth, death, and accession to the throne of the kings
and queens of England. Define two table types for this data, one using a single date
attribute type, the other using three date attribute types. Compare the merits of the two
table structures. (5 min)
3. A fixture table contains details ...