1.Write a typical table occurrence for the table shown in Fig. 6.10, including examples
of redundant salespersonName values. Using the same data, write table occurrences for
the well-normalised tables of Fig. 6.12, and explain why these tables do not contain
redundant values of salespersonName.(3 min)
2.Derive a set of well-normalised tables for each of the determinancy diagrams in
question 1 of section 6.6. Express each answer both as a determinancy diagram and in
the form of table types with each table identifier underscored.(2 min each)
3.Can the functional dependency between attributes be deduced from a table type if
it is known to ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.