Study the scenario and complete the question$($s$)$ that follow:

Eduvos Library Management System

Eduvos has a private library comprising of a large number of books. The institute aims to keep information on each of the books in a catalogue. In particular, the higher education institution would like to know which authors own each book and record the first name

end surname of each new author when a new book is purchased. A unique ID identifies each author. When a new book is purchased, the title, price, date purchased, and the number of pages is recorded. Furthermore, a unique ID is assigned to every book purchased. The books are classified by topic and use a topic ID When searching the catalogue. More than one copy of certain books is kept because of their investment value.

BOOK

#$*$ booklD

$*$ bookTitle

$*$ bookPrice

$*$ bookPurchaseDate

$*$ bookPages

AUTHORS$/$BOOK

TOPIC

#$*$ topiclD

$*$ topic Name

o topicDescr

AUTHOR

#$*$ authorlD

$*$ authorName

$*$ authorSurname

Question $2$

Use the scenario to answer the following questions:

$2\mathrm{.}1$ Create a relational model by creating the five $(5)$ tables shown in the ERD, taking into consideration mandatory attributes, primary and foreign key constraints.

$2\mathrm{.}2$ Store at least five $(5)$ relevant records into each table created in $2\mathrm{.}1.$

$2\mathrm{.}3$ Obtain the identify of topic, name with corresponding title, date of purchase and number of pages of stored books. Display the result on your query in the format below.

TOPICID

TOPICNAME

BOOKTITLE

BOOKPURCHASEDATE

BOOKPAGES

$2\mathrm{.}4$ Create a view named "BooksDetails" to display the title, prices of books as well as name and surname of their respective authors. Remember to display your output as shown in the sample figure below by using column alias where necessary.

Title of Books

Purchase Price

Author First Name

Author Last Name

$2\mathrm{.}5$ Create a stored procedure that will obtain ALL details of books from the books table and display the result $($using a suitable loop where necessary$).$

$2\mathrm{.}6$ Create an index on the on the topic name in the Topic table for efficient search operation.

$2\mathrm{.}7$ Would you associate the tasks performed in $2\mathrm{.}1-2\mathrm{.}5$ as the role of a database administrator? Justify your rationale in support or against your selection.