Instructions$1.$ Create a normalized database for a fictitious manufacturing company named Big Bird Houses LLCthat has been in business since January $1,2021.$ The company sells different types of birdhouses,chicken coops, and bird feeders.Requirements for database$1$a$.$ Name the database BBH$\_$Team$\_$TeamMemberName $($for the TeamMemberName use the lastname of one of the members of your team$).$b$.$ Create structures $($Create Tables$)$ in the database consisting of normalized tables with meaningfultable names,meaningful attribute names, appropriate datatypes, appropriate primary keys, and appropriateforeign keys $/$ relationships that provide for the storing of the following:$$ Table to hold customer information$$ Table to hold the order information for each order$$ Table with information of the actual line items on each order$$ Table to hold the company$$s employee information$$ Table with information on the packaging of orders by employees$$ Table to hold the inventory items sold by the company$$ Table to hold Information on the company shipping the order to the customer$$ Table information on the actual shipment to the customerc. Populate the tables with data $($Insert Records$)$ from January $01,2021$ to present. For this step, makeup realisticcomplete data assuming:$20$ active employees and $5$ former employees$6$ customers with $3$ sales orders per customer each year. Customers will purchase one tomultiple items on each order$20$ variety of inventory items for sale.$$ Packaging of orders based on the sale orders$3$ shipping companies to ship out the orders to the customers$$ Shipment information based on the completion of packed orders$2.$ Create a script file named BBH$\_$Team$\_$TeamMemberName $($for the TeamMemberName use the last

name of one of the members of your team$).$ When executed, this script file is to create a copy ofthe database $($including all the rows of data$)$ as described in direction $13.$ Use your database to write queries to answer the questions shown below. For each one of thesequestions paste into a Word document the question, the code written, and the results returned:$1.$ List the top three customers who have spent the most money with the company?$2.$ Which year did the company sell the most chicken coops?$3.$ What items in inventory need reordering?$4.$ What is the most expensive item presently in inventory?$5.$ List employees who have never packed an order$6.$ List orders where the status is still pending$7.$ What are the names of the employees who work in the customer service department?$8.$ What are the names of former employees, and when were they let go$?9.$ List the total count sold for each sold: Birdhouses, Chicken Coops, and Bird feeders$\mathrm{.}10.$ Count the total shipments that have been completed by each shipper and sort by shipper name$4.$ Save the Word document produced in step $3$ with a name of BBH$\_$Team$\_$TeamMemberName $($for theTeamMemberName use the last name of one of the members of your team$)\mathrm{.}5.$ Upload and submit the BBH$\_$Team$\_$TeamMemberName Word document and theBBH$\_$TeamMemberName.SQL file before the due date. NOTE: Each member of the group is to uploadand submit a copy

can someone help me do this is my final project and I don't know how to do it please