Question 3
Zenner Collections is an auction house specialising in antiques. They classify items by geographic area and historical eras. Geographic areas (such as a country) are grouped into regions such as south-east Asia, north Africa etc.
Historical eras each have one or more reference books associated with them. A reference book may be used for more than one historical era.
a) Draw an entity relationship diagram to reflect the information you have been given (you NEED NOT include attributes in the diagram).
b) Identify all the primary and foreign keys for this diagram.
c) Zenner Collections have decided they need to classify antique firearms (such as muskets) with extra attributes to take account of licensing issues and extra insurance when handling them. Describe how features of the Extended Entity-Relationship (EER) might be used to be able to take account of this requirement.
Students succeed in their courses by connecting and communicating with an expert until they receive help on their questions
Consult our trusted tutors.