You are to develop a database as mentioned above that will store textbooks including the price for each textbook using MSMS or MS Azure $($if necessary$).$ Follow the instructions below to create it$.$

Open MSMS$.$

Create a blank database in the MSMS and name it as BookStore.

Create a new table named textBook that contains these fields$/$attributes:

$\backslash$table$[[$Field name,Data type,Constraints$],[$bookID$,$autonumber,Justify your own solution here:$],[$Title$,$text,Justify your own solution here:$],[$Author$,$text,Justify your own solution here:$],[$Publisher$,$text,Justify your own solution here:$],[$Year$\_$Published,int,Justify your own solution here:$],[$Price$,$currency,Justify your own solution here:$],[$Hardcopy$,$boolean,Justify your own solution here:$],[$eCopy$,$boolean,Justify your own solution here:$]]$

Retain primary key fields name as ID$.$

Enter these data into textBook table:

$\begin{array}{cc}\text{F}\text{i}\text{e}\text{l}\text{d}\text{N}\text{a}\text{m}\text{e}& \text{D}\text{a}\text{t}\text{a}\\ \text{b}\text{o}\text{o}\text{k}\text{I}\text{D}& 1\\ \text{T}\text{i}\text{t}\text{l}\text{e}& \text{J}\text{a}\text{v}\text{a}\text{S}\text{o}\text{f}\text{t}\text{w}\text{a}\text{r}\text{e}\text{S}\text{o}\text{l}\text{u}\text{t}\text{i}\text{o}\text{n}\text{s}\\ \text{A}\text{u}\text{t}\text{h}\text{o}\text{r}& \text{L}\text{e}\text{w}\text{i}\text{s}\text{L}\text{o}\text{f}\text{t}\text{u}\text{s}\\ \text{P}\text{u}\text{b}\text{l}\text{i}\text{s}\text{h}\text{e}\text{r}& \text{P}\text{e}\text{a}\text{r}\text{s}\text{o}\text{n}\\ Yea{r}_P\text{u}\text{b}\text{l}\text{i}\text{s}\text{h}\text{e}\text{d}& 2024\\ \text{p}\text{r}\text{i}\text{c}\text{e}& 135\mathrm{.}25\\ \text{H}\text{a}\text{r}\text{d}\text{c}\text{o}\text{p}\text{y}& Y\end{array}$