Entity Relationship Diagram for Database INTRODUCTION 3 TASKS

Database

Table of Contents
INTRODUCTION...........................................................................................................................3
TASKS.............................................................................................................................................3
a). Identify all the entities, complete all the entities with suitable attributes together with
assigned primary key...................................................................................................................3
b). Determine Cardinality, and participation for each related entity, relationships....................4
Relationship :..............................................................................................................................4
c). Construct an Entity Relationship Diagram and mention all the entities and attribute in
proper manner.............................................................................................................................6
d). Based on ERD created convert into the relational schema and also indicate primary key
and foreign key for each relational schema.................................................................................7
e). Produce sample records for each relation that observes the relational integrity rules.........10
f). Produce FIVE SQL queries that can be used to manipulate the data from each relation and
show ALL the results from each of the queries........................................................................13
CONCLUSION..............................................................................................................................16
REFERENCES..............................................................................................................................17

INTRODUCTION
Database management system is basically the collection of data that update, retrieve and
delete or manipulate the information in proper manner. DBMS is a type of software that provide
an interface to database for information retrieval or storage (Truyen and et.al., 2018). This report
will discuss about the entity relationship diagram and find out the specific entities with suitable
attribute. Furthermore, this assignment will describe the ER diagram that convert into the
relational schema. Produce the sample record of each relationship to observe the relational
integrity rules. At last, it will discuss about the SQL queries that can be used to manipulate the
data from each the relation and also shows the results from each queries.
TASKS
a). Identify all the entities, complete all the entities with suitable attributes together with assigned
primary key.
Entity- An entity is a based on the real world object that shows as a entity in the
relational database system.
Attributes- It is the property and characteristic of entity. Each and every attribute has
value drawn from specific domain (Arulraj and Pavlo, 2019).
On the basis of scenario, it would be created an entities and their relationship between
them by using primary and foreign key.
Entities Attributes
Warehouse  warehouse_id (PK)
 warehouse_name
 warehouse_address
 warehouse_telephone
 warehouse_email
 warehouse_person in charge
 model_no (FK)
Product  model_no (PK)
 brand_name
 product_type
 warranty time

 retail price
 customer-id (FK)
 purchased_id (FK)
purchased  purchased_id (PK)
 product quantity
 purchased_date
 purchased_amount
 customer_id (FK)
 warehouse_id (FK)
Order  order_id (PK)
 order_date
 customer_id (FK)
registration  reg_id (PK)
 date
 time
Table : 1
b). Determine Cardinality, and participation for each related entity, relationships
Entity relationship is the important for designing the database system because it helps for
establishing a connection between the entities and determine the suitable according to the
requirement (Felemban and et.al., 2018).
Relationship :
The relationship type are described by the specific set of role and attributes in ER
diagram. On the basis of ER diagram, customer and registration are entities that created a
relationship between them by both entities are contained primary key (Becher and et.al., 2018).
In registration table, reg_id is a primary that contain in the customer table as a foreign
key. In this way, both entities are developed a relationship between them.
i.e. “customer” makes “registration”. In this way, each entities are created a relationship with
another entities shown in table.