CS403 assignment # 1 solution and Comment due date 17 Nov 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).

Assignment

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.