Assignment 2 https://www.24hours.pk/ is an onlineshopping website, which facilitate customers with hassle free buying of discountproducts over internet.

Customers can buy any kind of products such as mobiles,electronics, clothes etc. Customers can pay bill online very easily. A briefdescription of the website is as follows:To sign up into https://www.

24hours.pk/, a new customer hasto register himself/herself for online shopping. The customer provideshis/her first-name, last-name, mobile no, email id, home address, city, andpassword in sign up form. Now customer can sign in providing his/hercredentials. 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 oneproducts. Customer can pay the bill online by filling a shipment voucher byproviding his full name, contact number, address, city, and payment mode (cashor credit card). Customer can pay more thanone bill from his bank account. Now, by keepingthe above scenario, you are required to: Q1. Identify the entities and therelated attributes.                Answer:Detail of theentity and its attributes are given below:ü www.

Best services for writing your paper according to Trustpilot

Premium Partner
From $18.00 per page
4,8 / 5
4,80
Writers Experience
4,80
Delivery
4,90
Support
4,70
Price
Recommended Service
From $13.90 per page
4,6 / 5
4,70
Writers Experience
4,70
Delivery
4,60
Support
4,60
Price
From $20.00 per page
4,5 / 5
4,80
Writers Experience
4,50
Delivery
4,40
Support
4,10
Price
* All Partners were chosen among 50+ writing services by our Customer Satisfaction Team

24hours.pkis a entity.ü shipment voucher are alsoentity and its attributes are full name, contact number, address,ü Customers are entity anddetails 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 orcredit card.ü Bank is also entity and itscredit card number is attribute.ü Products for examplemobile, 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 inappropriate 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.