Questions $($each $1$ point$)$

Use the CREATE TABLE command to create a table for the ORDER$\_$LINE table, with the attributes

displayed in Table $1($see below$).$ Remember that order$\_$num and part$\_$num together comprise this table's

primary key. So$,$ define a composite primary key. Ensure that $(1)$ order$\_$num is a foreign key referencing

the order$\_$num in ORDERS, and $(2)$ part$\_$num is a foreign key referencing the part$\_$num in PART.

Table $1$: Order Line table

Copy the code you used to create the table and paste it here.

Use the INSERT INTO command to populate the table you created in question $1.$ Use the data from the

table above to fill in the values. Copy and paste the code you used to populate the table.

Use the SELECT $*$ command to display the table you created with the data values in them. Copy

and paste your code.

For the questions below, copy and paste your output $($see instructions on page $1).$

Using a MySQL query, list all the rows for the low$-$availability parts. Low availability: If the

number of parts on hand is less than or equal to $25,$ then we consider there is low availability.

Using a MySQL query, list the description of all the parts with either the price greater than

$$400$ or the description contains two words.

Using a MySQL query, list the descriptions of the parts in the warehouses other than $4.$ Write

three queries that can answer this question using the following requirements:

a$.$ Query $1$ should use

b$.$ Query $2$ should use $!=$

c$.$ Query $3$ should use NOT