$2.$Write SQL Statements to Create Tables and Insert Records as shown below, assign a foreign key column and write the auto$-$inerement syntax in the table.

CUSTOMER TABLE

ORDER TABLE

$\backslash$table$[[$CID$,$LName,Frame,Gender,Age$],[1001,$Paul,Meshack,M$,22],[1002,$Aisha,Henry,F$,21],[1003,$Goodluek,Alphonse,M$,20],[1004,$Jane,Morgan,M$,23],[1005,$Adain,Organ,M$,22]]$

$\backslash$table$[[$OID$,$Ordemenmber,CustomerID$],[22,77221,1001],[21,22321,1005],[23,32222,1002],[24,32232,1003],[25,33213,1004]]$