We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>


Looking For Something at vustudents.ning.com? Click Here to Search

 

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.

 

 

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

 

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)

 

 

NOTE:  If you have any query regarding assignment, then email at CS507@vu.edu.pk.


+ Click Here To Join also Our facebook study Group.


+ Prohibited Content On Site + Report a violation + Report an Issue


..How to Join Subject Study Groups & Get Helping Material?..


See Your Saved Posts Timeline

Views: 2760

.

+ http://bit.ly/vucodes (Vu Study Groups By Subject Codes Wise)

Replies to This Discussion

do we just have to make the assignment in words and simply save it with out student ID and simply upload it? because their requirement is to upload in .doc
do we have to do anything special?

Please add proper solution or at-least the proper guidance. 

ye kya ha tariq bhai

Please koi to kuch idea dy

CS-507 Assisgnmnet Solution 

Attachments:

good job

do we just have to make the assignment in words and simply save it with out student ID and simply upload it? because their requirement is to upload in .doc
do we have to do anything special?

Mr Fayyaz hamza you should write hre attributes instead of entities. what yousay, plz cehck the sollution again.!!!

  • Products for example mobile, electronics and clothes are entities and its entities (attributes) are product id, product name, product description, and product price.
  • shipment voucher are also entity and its entities (attributes) are full name, contact number, address, city, and payment mode cash or credit card.

CS-507 Assisgnmnet Solution 

Attachments:

Mr Tariq Malik you should write hre attributes instead of entities. what yousay, plz cehck the sollution again.!!!

  • Products for example mobile, electronics and clothes are entities and its entities (attributes) are product id, product name, product description, and product price.
  • shipment voucher are also entity and its entities (attributes) are full name, contact number, address, city, and payment mode cash or credit card.

please guide..

RSS

© 2019   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service