Convert the data model you constructed for Garden Glory in part B at the end of Chapter...

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 IE Crow’s Foot E-R diagram 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.

Reference figures in below: