Your Lab Assignment Here is your lab assignment 1. Create a data dictionary for Magnet Supply Company Order System using the data dictionary example in the textbook as the format. 2. Create a relational diagram for Magnet Supply Company Order System 3. Execute SQL select commands (see "Getting Started" lab) and answer the following questions: (answer the question but also provide SQL and result) a. How many different job codes are available? b. What is the job code for Linda Fickes? C. What is/are the name(s) of the vendor(s) location in PA? d. What is the order quantity in stock for product 4002? e. What is the zipcode for customer 1001? f. What is the sale price for product 4010? Please prepare your answers in a document and submit it in Canvas. Remember to (1) answer the question (2) provide the SQL used to answer the question (3) provide the entire data display for the execution of the SQL command and (4) provide the "row(s) affected" message from the execution of the SQL command. Always be sure to include a heading in any document with your name, a brief descriptive title and a date Your Lab Assignment Here is your lab assignment 1. Create a data dictionary for Magnet Supply Company Order System using the data dictionary example in the textbook as the format. 2. Create a relational diagram for Magnet Supply Company Order System 3. Execute SQL select commands (see "Getting Started" lab) and answer the following questions: (answer the question but also provide SQL and result) a. How many different job codes are available? b. What is the job code for Linda Fickes? C. What is/are the name(s) of the vendor(s) location in PA? d. What is the order quantity in stock for product 4002? e. What is the zipcode for customer 1001? f. What is the sale price for product 4010? Please prepare your answers in a document and submit it in Canvas. Remember to (1) answer the question (2) provide the SQL used to answer the question (3) provide the entire data display for the execution of the SQL command and (4) provide the "row(s) affected" message from the execution of the SQL command. Always be sure to include a heading in any document with your name, a brief descriptive title and a date