MTH202 Assignment Questions
|MTH202 Assignment No 1 Questions Fall 2017|
MTH202 Assignment No 1 Solution Fall 2017
You can see the Sample Page Preview of MTH202 Assignment No 1 Solution File below. You can download Solution file from Download Button given below.
MTH202 Assignment Solution Sample Preview
|MTH202 Assignment Solution Sample Preview|
MTH202 Assignment Download Link
If MTH202 Assignment Solution was helpful. Please Share it with your friends. You can also like our Facebook Page or Subscribe Us below for Updates. Thank You.
CS507 Assignment Scenario:
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:
Question no 1:
Identify the entities and the related attributes. (5 Marks)
Question no 2:
List down the type of attributes in appropriate column of below table. (5 Marks)
Multi value attributes Derived attributes Composite attributes
Question no 3:
Design Entity Relationship Diagram (ERD), showing proper relationship among the entities. (10 Marks)