Database Design

Database Design
1

Contents
INTRODUCTION...........................................................................................................................3
TASK 1............................................................................................................................................3
TASK 2............................................................................................................................................7
CONCLUSION..............................................................................................................................19
REFERENCES..............................................................................................................................20
2

INTRODUCTION
Database is a kind of organized set of or collection of data that has been accessed or stored
electronically within a system. It helps in storing complex data and information in an organized
manner using formal design and different kinds of modelling techniques. A database is
controlled by database management system and use structured query language for writing and
querying data (Jo and et. al., 2016). There are various kinds of databases that can be used by
organizations for development of database and strong data or information in a systematic and
arranged manner. In order to store information or data into database it is important to develop
design of database so that data is organized in an appropriate manner within database. But before
this, it is important to identify requirements of database for business and for this, data modelling
is required to be focused upon. In order to develop a data model, Entity- relationship model a
relational schema can be developed that helps in developing an appropriate model of database so
that all the needs and requirements of business can be fulfilled. This assignment will lay
emphasis upon development of entity relationship diagram as per the information given in ‘The
library’ scenario. Then this entity relationship model will be translated to Relational Schema.
Other than this, in this assignment, business understanding, data understanding, Data
Preparation, Modelling, Evaluation and Deployment will be focused upon.
TASK 1
ER Diagram or an entity relationship model is a high- level data model which is mostly used for
defining data elements and relationship for a particular system. It helps in development of a
conceptual design of database. It can also be said that it helps in development of a design view
which is simple and easy to be understood. It can also be said that ER model is a blueprint of a
database that can be used further for implementation of database (Wang and et. al., 2019). An ER
model consist of three main components that together helps in developing a proper and accurate
ER model. Three main components of ER model are: Entity: attributes, and relationship. Entity
is a data component or an entity which is represented as a rectangle in ER diagram. Each entity
has one or another kind of relationship with each other. Another component is Attribute.
3