Use MySQL and Figures 1-8 through 1-12 in Chapter 1 to complete the 1. Use the appropriate CREATE TABLE commands Alexamara Marina Group to create the tables in the 8aA table usngG re 3-2 2. Add the marina information in Figure 1-8 to the MARINA table using INSERT 3. Add the owner information in Figure 1-9 to the OWNER table using INSERT 4. Add the slip information in Figure 1-10 to the MARINA_SLIP table using INSERT 5. Add the service category information in Figure 1-11 to the SERVICE CATEGOR Marina Group database. The information you need appears in Figu FIR ADI CIT STA using INSERT commands. 6. Add the service request information in Figure 1-12 to the SERVICE_REQUEST INSERT commands. (Hint: The values for next service dates on some rows are nul a null value, you can use the type of INSERT command illustrated in Example 4.A tively, you might find it simpler to enter a date that does not occur on any other row December 31, 2010) for the dates that should be null. Once you have added al los can change this date to null on any row on which it occurs. To do so in MySQL us lowing command: MARI MARII UPDATE SERVICE REQUEST SET NEXT_SERVICE DATE NULL WHERE NEXT SERVICE DATE '2010-12-31 MARINA Descipton Nulls Column BOAT Marina uer MARINA NUM CHAR No OWNEIC SERVIC CHAR CHAR CHAR CHAR CHAR Marina ADDRESS CITY STATE ZIP 15 CATEGO 15 CATEGO FIGURE 3 database FIGURE 3-29 Table layouts for the Alexamara Marina Group