$(3\%)$ Draw an example diagram to briefly explain the snowflake schema

$(4\%)$ Give an example to explain the transaction states $-$ partially committed and committed.Q$8$

$($a$)(3\%)$ Draw an example diagram to briefly explain the snowflake schema

$($b$)(4\%)$ Give an example to explain the transaction states $-$ partially committed and committed.