Assignment 2

https://www.24hours.pk/ is an online
shopping website, which facilitate customers with hassle free buying of discount
products over internet. Customers can buy any kind of products such as mobiles,
electronics, clothes etc. Customers can pay bill online very easily. A brief
description of the website is as follows:

To sign up into https://www.24hours.pk/, a new customer has
to register himself/herself for online shopping. The customer provides
his/her first-name, last-name, mobile no, email id, home address, city, and
password in sign up form. Now customer can sign in providing his/her
credentials. The customer can purchase any product such as mobiles,
electronics, and clothes etc. Each product has its product id and product name,
product description, and product price. A customer can purchase more than one
products. Customer can pay the bill online by filling a shipment voucher by
providing his full name, contact number, address, city, and payment mode (cash
or credit card). Customer can pay more than
one bill from his bank account.

Now, by keeping
the above scenario, you are required to:

Q1. Identify the entities and the
related attributes.                

Answer:

Detail of the
entity and its attributes are given below:

ü 
www.24hours.pk
is a entity.

ü 
shipment voucher are also
entity and its attributes are full name, contact number, address,

ü 
Customers are entity and
details of attributes like first name, last name, cell number, email address,
home address, city, and password in sign up form are the attributes of it.

ü 
Payment mode cash or
credit card.

ü 
Bank is also entity and its
credit card number is attribute.

ü 
Products for example
mobile, electronics and clothes are entities and its attributes are product id,
product name, product description, and product price.

Q2. List down the type of attributes in
appropriate column of below table.

Answer:

Multi value attributes

Derived attributes

Composite attributes

Password

Mobile no

Product price

Email id

Name of
product

Product id

Credit card #
XXXXXXX

Entity Relationship Diagram (ERD)
 

Products (clothes, mobiles,
electronics)

Q3. Design Entity Relationship Diagram (ERD),
showing proper relationship among the entities.