Assignment No 1; CS-403; Fall 2012; submission date 09 Nov, 2012

[Anonymous]

Database Management System (CS403)
Assignment No.1
Total Marks: 10
Deadline
Your assignment must be uploaded before or on 9th November 2012.
Rules for Marking
It should be clear that your assignment will not get any credit if:
1. The assignment is submitted after due date
2. The assignment is copied
Objectives
The objectives of this assignment are,
1. Giving the idea of the most common tool used for designing database systems i.e. Data Flow Diagram. It is used to design systems graphically and expresses different details of system in different DFD levels.
2. To become familiar with the flow of data between different processes and to hide complexities in any given system.

Assignment
Introduction:

In this course we are going to develop a complete physical database for “Trade Management System” that will computerize all the necessary Trade Management processes for a small business shop, BEST Mart. For this we will divide this whole project in small 4 to 5 assignment chunks and will try to cover every phase of database development life cycle from scratch to execution. Scenario for the Trade Management System is given below.
There exists a BEST Mart- a shopping centre, whose owner wants to computerize his business by developing Trade Management System. For this, owner hires a Database Administrator and put up a real world scenario and requirements as given below:
Trade Management System permits users to proficiently initiate and evaluate the process of requirement for the BEST Mart. Procedure begins when a client comes to BEST Mart, selects the cart and place the things in cart and goes towards salesman. The salesman examines the code of each selected item. On entry system will display invoice with some details like name of the product, its related magnitude/quantity and total sales line items along with total bill. After placing order, client will ahead to accountant counter to pay bill.
Trade Management System will support both types of customers, Registered and Non-Register. For Registered customers it is necessary for system to check whether he/she is on credit bases or not. For non-registered customers, it must have to be registered only by
©Virtual University of Pakistan 2
the Owner of the BEST Mart. Information about number of creditors and debtors are
known by the accounts department.
System will show flexibility in a sense that it should accept all payment methods i.e.
cash, credit and cash with credit.
Same is the scenario with Administrator/Owner of BEST Mart to purchase items from
different vendors on cash, credit or combination of two. The stock department and Sale
department will need to generate reports about stock status sale in different time span.
Task Description:
This Assignment is starting phase and in this assignment you will focus only on the
tasks given below:
1. You are required to identify all the processes in the system.
2. You are required to mention all the data stores in which data is stored.
3. Find out all the external entities interacting with the system
4. Create a Context level DFD
5. Create a level zero DFD
6. Create a detailed DFD of every process if needed
You have to perform all these steps give above in your solution file.

Note:
Use all concepts you have studied so far and techniques discussed particularly
in lecture 5 and 6 regarding this assignment.
Drawing Final Data Flow Model:
You can use any tool for drawing like MS Office or Visio.
Important things to consider:
1. As happens in real world that everyone visualize a problem in different way so the
solutions of all students should be according to their own thinking not taken from
some source.
2. As this is preliminary phase of our system so it is recommended that you identify
as much processes and their relationships as you can (some of them may be
eliminated in coming assignments).

[+ M.Tariq Malik]

Please Discuss here about this assignment.Thanks

[+ M.Tariq Malik]

 Syed Faizan ul Hassan gud keep it up 

Note @ All: You don’t need to go any other site for this assignment/GDB/Online Quiz solution, Because All discussed data of our members in this discussion are going from here to other sites. You can judge this at other sites yourself. So don’t waste your precious time with different links.

[Sadia Imtiaz]

kya kisi ne notice kia k iss assignment mein due date 9th november mention hai and outside mention hai k yeh 12 november tak submit ker sakte hain  kya koi bata sakta hai k isski sahi due date kya hai??

[zain ul abdeen]

please give me the hint about this assignment

[+ M.Tariq Malik]

Dear Fellows,

All of you are requested, Please post Only One Discussion For Current Assignment/GDB/Online Quiz and everyone reply/share/discussed his/her data on that same discussion, so that all members get solution & discuss easily on Current Assignment/GDB/Online Quiz.

So please don’t post two or more discussions for one Current Assignment/GDB/Online Quiz, hope you’ll understand and cooperate with us.

Our main purpose here discussion not just Solution.

[Awais]

is k bary main knowlede dain k in k process ko likh k us k mutabik diagram bnana hai kya?

1. You are required to identify all the processes in the system.
2. You are required to mention all the data stores in which data is stored.
3. Find out all the external entities interacting with the system

[ραяι]

Ajeeb si Assignment he or koi rply b nae kar raha

[+ M.Tariq Malik]

@ All please ap thora thora b is assignment ku discuss karo tu ya solve hu jahay gi 

[+ Khalid Pervez (MBA+MCS ) +]

hmm

[Aamnah Ghafoor]

kiniiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii koji assignment h ufffffffffffffff........................

[Naveed Akbar]

agli b sari aisi he honi hen yar :D:D

[Aamnah Ghafoor]

qqqqqqqqqq?????

pehly kon sa sari bookx ki achi hoti hain

sub ak jesi chun chun k banaty hain...