Convert this data model to a database design. Specify tables, primary keys, and foreign keys. Using figure 6-43 as a guide, specify column properties

Data model

Figure 6-43

OFFICER Driven By Personal_Number Officer_Signature DRIVER Last_Name First_Name Address City State Zip_Code Driver_Licence Driver_Licence_State Birth_Date Height Weight Eye Colour Driver_Signature Issues VEHICLE Vehicle Licence State Color Year Make Type VIN Registerd_Owner_Name Address Has VIOLATIONS: Violation_Description - Contains VIOLATION_TICKET Violation_Month Violation_Day Violation_Year Violation_Time Dist Detach Location_Miles Location_Direction Location Route