Q$2.$A: Write down SQL statement for creating table LIBRARY having following attributes:

$(3$ marks$)$

i$)$ BOOK$\_$ID $-$ an integer, primary key of the table

ii$)$ BOOK$\_$TITLE $-$ a string

iii$)$ AUTHOR$-$a string

iv$)$QTY $-$ an integer

v$)$ PRICE $-$ a real number