Question $3(30$ marks$)$

The table below shows some sample data of a database in a restaurant. The OrderID and ltemNo form a composite primary key. The table stores data in one month, in which the prices do not change.

$\backslash$table$[[$OrdertD$,$ItemNo,TableNo,Date,InTime,DishiD,DishName,UnitPrice,Qty$],[1321,1,17,7-8-2024,14$:$30,$A$4,$Shrimp Cocktail,$80,1],[1321,2,17,7-8-2024,14$:$30,$P$3,$Seafood Spaghetti,$118,1],[1328,1,8,7-8-2024,14$:$35,52,$Caesar Salad,$108,1],[1328,2,8,7-8-2024,14$:$35,$M$1,$Lamb Shrank,$168,2],[1342,1,4,7-8-2024,15$:$00,$M$3,$Sirloin Steak,$188,1],[1378,1,17,7-8-2024,17$:$00,$M$1,$Lamb Shrank,$168,1]]$

$($a$)$ To which types of anomalies $($insertion$,$ deletion, modification$)$ is the above table susceptible? Please provide an example for each type of anomaly.

$($b$)$ Draw the dependency diagram of the above table. Label all dependencies $($full$,$ partial, transitive$).$

$($c$)$ Normalize the above table to $3$NF$.$ Give your answer in the form of celational schemas

ENTITY$($Attributel$,$ Attribute?, Attribute $3,...)$

with the primary key attributes underlined.