Data Modeling and Database Design for Globe Library

DATA MODELING AND
DATABASE DESIGN

TABLE OF CONTENTS
INTRODUCTION...........................................................................................................................3
MAIN BODY...................................................................................................................................3
Relational database diagram........................................................................................................3
Entity relationship diagram..........................................................................................................7
Sample screen form:....................................................................................................................9
CONCLUSION................................................................................................................................9
REFERENCES..............................................................................................................................10

INTRODUCTION
Data modelling refer as the process for analysing the objects and their association with the
other data objects. It is mainly required for processing the data which is essential for the efficient
business processes (Mardan, (2021)). Database design define as arranging the data information in
an order so that it can be easily fetched, designer started setting the data into the database.
Organisation develop the database for arranging the data into order, in which the data is stored
into the table format, which can be easily retrieve by performing the operation which is update,
delete, add, modify, insert etc. Globe library is the small community library which is located in
the area of northern suburbs of Adelaide. Following report will cover the designing of relational
model diagram and entity relationship diagram for the globe library a small community library, it
also defines the sample screen for the library.
MAIN BODY
Relational database diagram
RDBMS, is a database management system which stores the data in a table form where the
row and column carries the data. Data store in a table form can easily retrieve whenever it
required. RDBMS involves the functions which manage the security and integrity of the data so
that it can be utilised for betterment.
Advantage of RDBMS
Maintainability: This system provides the easy usability, it enables the database admin to
manage, control and efficiently makes changes in the data. With the help of RDBMS Globe
library can easily backups their data. Automation feature of the RDBMS automate its task, which
makes it easier for performing operation.
Data structure: RDBMS stores the data in a data structure or table format which can be easily
understood by the user and it also enables to arrange the data in an organised manner, so that
without wasting any time it can be retrieve easily (Zeb (2018)).
3

Flexibility: It is the most important factor where the system performs the operational task
without wasting time. Also data updating can also be done at one place.
Below is the RDBMS diagram of the library where it shows the relationship between the tables
which are as follows: