Your Do assignmenfor this module is to undertake a subnetting exercise. You must show your work, step by step, on this. You must do all of the exercises listed here. You must do this assignment of your own and your work must be your own. Any use of the work of others will result in a zero for this assignment and a referral to Judicial Affairs 1. You have a small business that is divided into 3 departments Accounting, Sales, and Administration. These departments have the following number of devices (computers printers.ete.). Accounting 31. Sales-28, and Administration-13. Using a class C private network, beet the network so that each department will have their own suboet You must show/explain how you arrived at your conclusion and also show the following All available device adresses for each department, the broadcast adress for each department, and the network address for each department. Also, determine how many 'wasted not able) addresses resulted from your setting enumerate them) 2. After two years, business has boomed. Accounting now has 37 computers, Sales 35, and Administration 24. In addition, you have added a Shipping department and a Production department Shipping has 13 computers and Production has 21. Using a class B private network, rework the heiting for the business with the same information (deliverables) is in problem 1 3. Finally, your company is purchased and merged with a larger company. The new company has the following needs Main office 1211 computers, Muscle branch office017 computers, Indianapolis plant-2014 computers, and the Mt. Vernon distribution center 945 computers. Using a Class A private network, subnet so that each site has its own network to handle its current computer requirements plus a 20% cushion for future growth and provide the same information (deliverables) as in probleme i and 2. NOTE: We will assene, for the purposes of this assignment, that you are using all Cisco equipment and that all equipment has been configured with the incre Cisco IOS command. Accordingly, you may use subnet zero and also the all ones subnet When you have completed this assignment, use the dropbox for this assignment to submit it. Note the deadline on the course calendar To determine the exact name of fields used in the tables for these exercises, refer to Appendix A (Tables for the JustLee Books Database) in the textbook, or use the DESCRIBE tablename command to view the table's structure 1. Display a list of all data contained in the BOOKS table. (1 points) 2. List the title and publication date for each book in the BOOKS table. Use alias "Publication Date" for the Pubdate column header. (1 points) 3. List the customer number and ship state from the ORDERS table for each customer who has placed order(s) with the bookstore. Remove duplicate(s) in the result. (2 points) 4. Create a mailing list from the CUSTOMERS table. The mailing list should display the name, address, city, state, and zip code for each customer. (4 points) a. Each customer's name should be listed in order of first name followed by last name, separated with a space, and have the column header Customer Name". b. The city and state should be listed as one column of output, with the values separated by a comma and the column header "Location". 5. List Order number, Item number, and ISBN for each order from ORDERITEMS table. Include an Item Total column which