Answer the Washington State Patrol Case Questions in Chapter 4 if you have note already...

Answer the Washington State Patrol Case Questions in Chapter 4 if you have note already done so. Design a database for your data model from Chapter 4. Your design should include a specification of tables and (using Figures 2-26 and 5-28 as guides) column properties, as well as primary, candidate, and foreign keys. Create visual representation of your database design as an IE Crow’s Foot E-R diagram similar to the one in Figure 5-27. Document your referential integrity constraint enforcement in the format shown in Figure 5-29.