Database Design and Development

Database Design and Development
1

Contents
INTRODUCTION...........................................................................................................................3
Activity-1.........................................................................................................................................3
Activity-2.........................................................................................................................................8
Activity-3.......................................................................................................................................15
Activity-4.......................................................................................................................................17
CONCLUSION..............................................................................................................................19
REFERENCES..............................................................................................................................20
2

INTRODUCTION
Database design is a type of process which mainly producing detailed information about the
data model. It contain all necessary logical as well as physical design as per choice while
considerations of multiple storage parameter. In order to generate detailed design and understand
the concept which help for establishing a relationship between different entities. The database
design must conform the particular standards which surely handle the large data anomalies. It is
nearly possible to construct a proper design of Mahrud Bees database. Furthermore, it will
discuss about the normal form which frequently accessed data or information. However, it will
develop the database tables, constraints, indexes, forms, Macros and other consideration of
security measurements.
Activity-1
Produce the design for complex relational database based on the response to client. Discuss
about third normal form.
A complex normalization relational database has performed the different functionality. It
needs to understand that how they interact with each other. It is mainly including the different
elements such as entities which established relation with another one (Arabshahi, Gharaei-
Moghaddam and Tavakkolizadeh, 2020). Entity relationship diagram is consists of entities and
their attributes, primary key, foreign key and normalization technique. In this way, it can be
performed different technique that support for handling overall process of Mehrud Bees database
system.
Figure 1 Entity relationship Diagram
3

Entity relationship is based on the model that mainly describe the entire structure of database. It
is mainly used for representing multiple field and their attributes. This type of ER model is
consider as blueprint of database that can be implemented as DB. In another words, Entity
relationship diagram shows the relationship of entity set that stored in database.
 Entity: It is based on the component and object of data which can represent as relational
between one or more database tables.
 Attributes: it is described the property of each entity where shows as significant values
within database.
Data Dictionary
It is a set of files that consists of various metadata which mainly used within database. It
has been recorded the objects and also establish the relationship with other one. Data dictionary
is the most crucial part in term of data collection because they can store information about
multiple entities, primary key and attributes.
Entities Attributes Relationship
Queen Queen_id (PK)
Queen_name
Bee_id (FK)
One to one
Bee Bee_id (PK)
Bee_name
Bee_produced
Supplier_id (FK)
One to many
Payment Payment_id (PK)
Payment_date
Order_id (FK)
One to one
Order Order_id (PK)
Order_date
Product_id (FK)
Customer_id (FK)
Quantity
Price
Many to many
Staff Staff_id (PK) One to many
4