GARDEN GLORY PROJECT QUESTIONS
Convert the data model you constructed for Garden Glory in part B at the end of Chapter 4 (or an equivalent data model that your instructor provides for you to use) into a relational database design for Garden Glory. Document your database design as follows.
A. Specify tables, primary keys, and foreign keys. Using Figures 5.26 and 5-28 as guides, specify column properties.
B. Describe how you have represented weak entities, if any exist.
C. Describe how you have represented supertype and subtype entities, if any exist.
D. Create a visual representation of your database design as an IL Crow's Foot BA dia-gram similar to the one in Figure 5-27.
E. Document referential integrity constraint enforcement, using Figure 5-29 as a guide.
F. Document any business rules that you think might be important.
G. Describe how you would validate that your design is a good representation of the data model on which it is based.