Database Management - Queen Anne Curiosity Shop Chapter 4. Please use the data model diagram below to answer the following questions. Thank you!

300 PART 2 Database Design The Queen AnneI Curiosity Shop the end of Chapter 5. If you have not already done so, complete the Queen Anne Curiosity Shop project at A. Convert this data model to a database design. Specify tables, primary keys, and for cign keys. Using Figure 6-43 as a guide. specify column properties. B. Describe how you have represented weak entities, if any exist. C. Describe how you have represented supertype and subtype cntities, ?fany exist. D. Create a visual representation of your database design as a Crow's Foot E-R diagram similar to the one in Figure 6-39. E. Document your minimum cardinality enforcement using referential integrity ac- tions for required parents, if any, and the form in Figure 629(b) for required chil- dren, if any. 300 PART 2 Database Design The Queen AnneI Curiosity Shop the end of Chapter 5. If you have not already done so, complete the Queen Anne Curiosity Shop project at A. Convert this data model to a database design. Specify tables, primary keys, and for cign keys. Using Figure 6-43 as a guide. specify column properties. B. Describe how you have represented weak entities, if any exist. C. Describe how you have represented supertype and subtype cntities, ?fany exist. D. Create a visual representation of your database design as a Crow's Foot E-R diagram similar to the one in Figure 6-39. E. Document your minimum cardinality enforcement using referential integrity ac- tions for required parents, if any, and the form in Figure 629(b) for required chil- dren, if any