Fall 2016_CS403_1

Semester:      Fall 2016

Assignment No. 01 Semester: Fall 2016 CS403 – Database Management Systems

Total Marks: 15 Due Date: 17/11/2016

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 clear 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. ·         Your assignment is copied from internet, handouts or from any other student

      (Strict disciplinary action will be taken in this case).

Question:     (15 Marks) Suppose, we want to start an online shopping store where customers can buy any item(s) of his/her choice from the available items on the store using debit/credit card. The online shopping store should provide the following features to its customers. Search item from the store Manage shopping list Place order using his/her debit/credit card After placement of the order, system should verify the debit/credit card information and deliver the item(s) to customer after verification. Now, you are required to identify different processes, sub-processes (if any) and data store(s) from the given scenario and draw context level data flow diagram and Level 1 data flow diagram for this store. NOTE: Do not put any query on MDB about this assignment, if you have any query then email at cs403@vu.edu.pk. Deadline: Your assignment must be uploaded/submitted on or before 17th November 2016.