CS507 ASSIGNMENT 2 SOLUTION FALL 2017
Objective:
- The purpose of this assignment is to give your hands-on practice. It is expected that students will solve the assignment themselves. The following rules will apply during the evaluation of 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.
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.
Scenario:
- accounting degree
- The Best of accounting degree
- 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.
Question No.2:
List down the type of attributes in appropriate column of below table.
- Multi value attributes
- Derived attributes
- Composite attributes
Question No.3:
Design Entity Relationship Diagram (ERD), showing proper relationship among the entities.
Note: If you have any query regarding assignment, then email at CS507@vu.edu.pk.
DOWNLOAD ASSIGNMENT SOLUTION
Download CS507 Assignment Solution by Clicking the Download Button Below in just single ClickDownload
You can Also Download Midterm Solved Past Papers referenceby Moaaz and Waqar Sidhu, Final term Solved Past Papers reference by Moaaz and WaqarSidhu, GDB Solutions, Assignment Solutions, and Solved Quizzes files, PPTSlides, Handouts, Final term Short Notes, Mid Term Short Notes and NTS Guidelines.