This is our final schema for the E$-$commerce Purchasing System:

$1.$ customers

$-$ customer$\_$id $($Primary Key$)$

$-$ name $($VARCHAR$2,$ Not Null$)$

$-$ email $($VARCHAR$2,$ Unique, Not Null$)$

$2.$ customer$\_$details

$-$ detail$\_$id $($Primary Key$)$

$-$ customer$\_$id $($Foreign Key, References customers.customer$\_$id$,$ Not Null$)$

$-$ address $($VVARCHAR$2,$ Not Null$)$

$-$ phone$\_$number $($VARCHAR$2,$ Not Null$)$

$3.$ products

$-$ product$\_$id $($Primary Key$)$

$-$ name $($VARCHAR$2,$ Not Null$)$

$-$ category $($VARCHAR$2,$ Not Null$)$

$-$ price $($DECIMAL$(10,2),$ Not Null$)$

$4.$ orders

$-$ order$\_$id $($Primary Key$)$

$-$ customer$\_$id $($Foreign Key, References customers.customer$\_$id$,$ Not Null$)$

$-$ order$\_$date $($DATE$,$ Not Null$)$

$-$ total$\_$amount $($DECIMAL$(10,2),$ Not Null$)-$ The total cost of the order.

$\backslash (\backslash$cdot $\backslash )$ order$\_$status $($ENUM$(\text{'}$Pending$\text{'},$ 'Shipped', 'Delivered'$),$ Not Null$)$

$5.$ order$\_$items

$-$ order$\_$item$\_$id $($Primary Key$)$

$-$ order$\_$id $($Foreign Key, References orders.order$\_$id$,$ Not Null$)$

$-$ product$\_$id $($Foreign Key, References products.product$\_$id$,$ Not Null$)$

$-$ quantity $($INT$,$ Not Null$)-$ Number of units ordered for this product.

$6.$ payments

$-$ payment$\_$id $($Primary Key$)$

$-$ order$\_$id $($Foreign Key, References orders.order$\_$id$,$ Not Null$)$

$-$ payment$\_$method $($ENUM$(\text{'}$CreditCard$\text{'},$ 'PayPal'$),$ Not Null$)$

$-$ payment$\_$status $($ENUM$(\text{'}$Completed$\text{'},$ 'Pending', 'Failed'$),$ Not Null$)$

$-$ payment$\_$date $($DATE$,$ Not Null$)$ Figure $1$: E$-$commerce Purchasing System Scheme

LAB $2$:

$-$ Build the tables in Oracle Live SQL with your account according to the schema.

$-$ Build the relations among the tables.

$-$ Delete, modify or update the tables.

$-$ Delete, modify or update the constraints.

$-$ Insert sample data into tables.