Design $4$ new database tables that represent suppliers, catalog items, item images, and item suppliers.The four tables need to be related such that a catalog item can have one or more item images, a catalog item can have one or more item suppliers, a supplier can supply one or more items.The supplier entity must have name, street address, city, state, zip, phone number, and a unique ID as a primary key.The catalog item entity must have name, UPC code, color, weight, and a unique ID as a primary key.The item image entity must have an image filename, image description, a primary image flag, the catalog item foreign key, and a unique ID as a primary key.The item supplier entity must have a catalog item foreign key, the supplier foreign key, primary supplier flag, and a unique ID as a primary key.Populate your tables with $2$ suppliers and $5$ catalog items.Each supplier should supply $3$ of the $5$ catalog items $($so there will be overlap$).$Each item must have a primary supplier.Selecting DataSelect from each of your tables individuallySelect from your four tables using a multi$-$table join to return all records for all catalog items, images, and suppliers.Select from your three tables using a multi$-$table join to return all catalog items and only primary images, and suppliers.Turn in your table structures, insert statements, queries, and all query results.