MIS602 Data Modeling and Design: Globe Library Management System

This report provides a comprehensive overview of data modeling and database design for Globe Library, a small community library facing challenges in managing its growing collection and user base. The report includes a relational database diagram and an entity relationship diagram (ERD) to illustrate the relationships between different entities such as library, librarian, member, book item, book, fine, library card, member room, conference room, rack, catalog, book lending, book reservation, barcode reader, account, and author. A data dictionary is presented, defining the attributes of each entity. The report also includes a sample screen form for library book borrowing, demonstrating how the database design supports efficient information retrieval and management. The database design allows for storing and modifying information effectively, ensuring that changes in the sample screen are reflected in the underlying database tables. The system is designed using SQL Server and Visio software, offering flexibility in designing the system. Desklib provides access to this and other solved assignments for students.

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:

5

Data dictionary
Data dictionary define as the centralised system of the metadata, which is about the data,
it is the data content which gives the meaningful description of each data (Hoffer, Venkataraman,
& Topi, (2019).). It helps in developing the understanding about the system, so that user can
easily know what things are included in the RDBMS system.
Entity Attributes
Library Lib_id (Pk), lib_name, lib_address, book_itemID(FK)
Librarian Librarian_id (PK), add_member, librarian_name, add_books,
block_member, book_itemID
Member Member_id(PK), member_name, membership_date, member_phoneNo,
member_address, expiry_date
Book item Book_itemID (PK), price, borrowed, barcode, format, due_date,
date_ofPurchasing
Book book_id(PK), book_name, book_title, book_genre, subject, ISBN,
publisher, book_itemID
Fine Fine_id (PK), amount, book_reservID, book_lendID
Library card Library_cardID, barcode, issued_at, card_no, book_itemID
Member room Meetingroom_id (PK), meetingroom_name, meetingroom_rate,
member_id(FK)
Conference room Conferenceroom_id (PK), conferenceroom_name, conferenceroom_rate,
member_id
Rack Rack_id (PK), rack_no, rack_location, book_itemID
CatLog Catalog_id (PK), book_subject, totalBooks, creationDate, book_title,
book_author, book_publicationDate, book_id
Book lending Book_lendID (PK), due_date, creation_date, issue_date, book_itemID,
acc_id, book_reservID
Book reservation Book_reservID (PK), creation_date, status, book_itemID, acc_id
Barcode reader Barcode_id (PK), registered_at, active, library_cardID
Account Acc_id(PK), acc_password, acc_status, member_id
Author Author_id (PK), author_name, author_address, book_id

Entity relationship diagram
ERD also termed as entity relationship model which usually define the relationship among the
people, places and objects. It shows the connectivity of the entities in a database management
system. Entity set refer as the collection of same entities, all entities have the attributes and
element which carries the data (Medina-Martínez and et.al (2020). Two type of ER diagram are
available one is physical and other one is logical. Physical ER diagram shows the actual
representation of the database system. It actually deals with the transformation of the logical
design information into the schema design, it will further convert into the relational database.
Whereas logical ER diagram refer as information which is arranged in order to fulfil the business
requirements (Pallavi & Jayarekha, (2020)). entities and attributes in such diagram generally lay
out the business needs. It involves the business logic and rules so that information can easily
organised.
Below is the logical ER diagram which shows the relationship among the entities, it
describe the library entities for the globe library along with the attributes.
7

9

11

13

Sample screen form:
Here is the view of the library book borrowing form. Yes the database design allows to store the
information which it shows that all the information are stored in a table format. As to make
changes in the sample screen data suitable changes in the DBMS system can be as the data which
is collected into the original table can only assembled or joined into sample form when user want
to view it (Yasin & Ramli, (2021)). Also if the sample screen is updated then the updates are also
applied to the other tables in the system.
For the sample screen Click on form wizard and to select what need to be in sample screen, thus
selects the fields from book, member, book reservation and from book lending table and then
clicks on next. The select the layout and select the title in this case the title is book information.
CONCLUSION
From the above report it is concluded that designing of database plays a significant role in
efficiently fetching of the information. Database management system enables the organisation to
effectively made change if required and access the information anytime. Above report illustrated
the description about the RDBMS system which is made for the library, it involves the logical
entity relationship diagram by using Visio software. Also the system is made through the SQL
server software which provides the flexibility in designing the system. It further covers the data

dictionary which involves all information so that user can easily develop the understanding and
performs the operation. It lastly concluded with the sample screen view which shows the library
book borrowing view.
REFERENCES
Books and journals
Mardan, A. A. A. (2021). Study of Database Management System Performance and Isolation in
Virtualization Environments.
Pallavi, G. B., & Jayarekha, P. (2020). Secure and efficient multi-tenant database management
system for cloud computing environment. International Journal of Information
Technology. 1-9.
Yasin, S. N. T. M., & Ramli, M. (2021). Development and Use of A Research Database
Management System. Journal of Counseling and Educational Technology. 4(1). 11-16.
Zeb, A. (2018). Security of Relational Database Management System: Threats and Security
Techniques.
Hoffer, J., Venkataraman, R., & Topi, H. (2019). Modern Database Management Global Edition.
Pearson Education Limited.
Medina-Martínez, D. and et.al (2020, November). Formal Verification of a Database
Management System. In 2020 8th International Conference in Software Engineering
Research and Innovation (CONISOFT) (pp. 102-109). IEEE.
15