Please help me with the following problem in SQLiteStudio

Problem Statement $-$ Metal Holdings Inc

You have been assigned the task of creating a simple relational database using SQLite database by the owner of $$Metal Holdings$$ who is in the business of selling industrial metals to customers $($mostly wholesale suppliers$)$ who buy from the company.

Your goal is to design and build a database that would be responsible for:

Managing a product table containing all metals which at a minimum should provide information such as name, description and price of each metal sold by the company.

Manage a list of customers who would be purchasing metals from the company. The owner is interested in name, location, contact as well as whether the customer is a retail or wholesale buyer.

Manage and maintain a complete inventory of all orders shipped by the company to customers.

The owner wants to maintain the following information about each order at a minimum, but not limited to:

Date of the Order

Shipping information such as date and status

Product purchased and Quantity ordered

Customer Information

Each customer can purchase $1-$to$-$many products $($metals$)$ in a single order.

Problem Statement $-$ Metal Holdings Inc

You have been assigned the task of creating a simple relational database using SQLite database by the owner of $$Metal Holdings$$ who is in the business of selling industrial metals to customers $($mostly wholesale suppliers$)$ who buy from the company.

The following is a list of metals sold by the company:

Copper

Aluminium

Silver

Steel

Bronze

Brass

Lead

Nickel

Titanium

Magnesium

Task

Each student should name the SQLite database as $\_$MetalHoldings

E$.$g$.$ JensonJacob$\_$MetalHoldings

Each student should design and build at a minimum $3$ tables for this exercise using SQLite Studio.

Each table should cover the mandatory minimum problem definition requirements defined in slide #$5$

Each of the identified tables should have the relevant column information that covers the requirements in Slide #$5$

The tables should have the relevant database constraints including

Primary Key

Foreign Key

Not Null

Unique

Each of the tables created should have sample data $(2$ rows minimum$)$ except the metals data which needs to match requirements in slide #$2.$

The metals identified in Slide #$7$ should exist in an identified table

Once the SQLite database is complete, upload the SQLite database to Blackboard for grading.

Refer to rubrics for grading.

Please show me how complete this excersize in SQLiteStudio $3,$ I am using version $3\mathrm{.}4\mathrm{.}4$