Considering the SCS Relational schema and given information, write a complete transaction for purchasing

the following item. $(10$ points$)$

Assume we have the following information:

A store S$5$ sold to two different product to $,$'Tina$($customer id: $1-2-333)$ on February $8,2024$

$$ product id of $6$x$6,$ sales price of $$150,$ and quantity $3$

$$ product id of $5$X$3,$ sales price of $$500,$ and quantity $1$

By checking the current state of the database you know the last sales transaction id is T$0002$

Question $1$: Name tables are involved in this transaction?

Question $2$: What types of SQL command are we need to write?

Question $4$: Do we need to have joins in our queries?

Question $3$: What should be the order of execution of our SQLs

Question $4$: what is transaction SQL codes?