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 and 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.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.

$(10$

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

$(10$

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

$(2$ Marks$)$

TOPICID

TOPICNAME

BOOKTITLE

$500$ Normalization

Advanced Database Management Systems

BOOKPURCHASEDATE BOOKPAGES

$15-$JAN$-22$