Create  normalized database for a fictitious manufacturing company named TreeTopBirdHouses that has been in business since January 1, 2015. 

Requirements for database1 : 

 a. Name the database TTBH_Team_TeamMemberName (for the TeamMemberName use the last name of one of the members of your team). 

b. Create structures in the database consisting of normalized tables with meaningful table names, meaningful attribute names, appropriate datatypes, appropriate primary keys, and appropriate foreign keys / relationships that provide for the storing of the following types of data: 

Employee

 Customer 

Supplier 

Sales - The Company sells birdhouses, bat houses, and bird feeders. 

Purchases - The materials used to build birdhouses, bat houses, and bird feeders.

 Inventory - The items ready to sell and the materials used to build items the company sells Packing - Getting ready to Ship 

Shipping 

Shippers 

c. Populate the tables with data from January 01, 2016 to present. For this step, make up realistic complete data assuming 15 active employees, 5 former employees, 25 customers, 15 suppliers, 20 sales orders from customers each year, 10 purchases from suppliers each year, inventory of a variety of items ready for sale, inventory of material used to build products, and data on at least 10 shippers. 

 2. Create  script file named TTBH_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 one copy of the database (including all the rows of data) as described in direction 1 

3. Use your database and write queries to answer the questions shown below. For each one of these questions paste into a Word document the question, the code written, and the results returned: 

a. Who are the five best customers? 

b. Which year did the company sell the most birdhouses? 

c. What items in inventory are in need of reorder? 

d. What are the names of the employees that get packages ready for shipment? 

e. Which employee is payed the most? 

f. What are the names of employees that work in the accounting department? 

g. What are the names of former employees, and when were they let go? 

h. What is the best-selling item?

 i. What items do not sell well? 

4. Save the Word document produced in step 3 with a name of TTBH_Team_TeamMemberName (for the TeamMemberName use the last name of one of the members of your team).