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.
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.