Use MySQL and Figures 1-8 through 1-12 in Chapter 1 to complete the 1. Use the appropriate CREATE TABLE commands to create the Alexamara Marina Group tables in the Alexae Marina Group database. The information you need appears in Figure 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 am 5. Add the service category information in Figure 1-11 to the SERVICE CATEGOR FIR ADI CIT STA ZIP using INSERT commands Add the service request information in Figure 1-12 to the SERVICE-REOUEST 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 Aler tively, you might find it simpler to enter a date that does not occur on any other row sa December 31, 2010) for the dates that should be null. Once you have added al lo can change this date to null on any row on which it occurs. To do so in MySOL s lowing command: 6. MARI MARI SLIP UPDATE SERVICE REQUEST SET NEXT SERVICE DATE NULL WHERE NEXT SERVICE DATE'2010-12-31 BONT BOAT OWNEIC MARINA Descipion Nulls Column Marina nuer MARINA NUM CHAR SERVIC CHAR CHAR CHAR CHAR CHAR Maria ADDRESS CITY STATE 2IP 15 CATEGO 15 CATEOO FIGURE 3 database FIGURE 3-29 Table layouts for the Alexamara Marina Group