CS507 Assignment No 2 Solution Fall 2017

CS507 Assignment No 2 Fall 2017

Dear Students, Here you can read or Download CS507 -Information Systems Assignment No 2 Solution and Discussion of Semester Fall 2017. Assignment Due Date is 26 January, 2018. CS507 Assignment Solution File in .docx format has been added. We are here to facilitate your learning and we do not appreciate the idea of copying or replicating solutions.

CS507 Assignment Objective:

The purpose of this assignment is to give you hands on practice. It is expected that students will solve the assignment themselves. The following rules will apply during the evaluation of assignment.

Recommended : CS402 GDB No 1 Solution Fall 2017

CS507 Assignment Uploading instructions:

Your assignment should be in .doc /.docx format.
Save your assignment with your ID (e.g. bc000000000.doc).
No assignment will be accepted through email.

Recommended : MGT603 GDB No 1 Solution Fall 2017

CS507 Assignment Rules for Marking:

It should be cleared that your assignment will not get any credit if:

The assignment is submitted after due date.
The submitted assignment does not open, execute or file is corrupted.
Cheating from any source (internet, handouts or from any other student) will result in zero.

Recommended : CS304 GDB No 1 Solution Fall 2017

CS507 Assignment Scenario:

(15 Marks)

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.

Tasks:

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)