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

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More

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).

+ How to Follow the New Added Discussions at Your Mail Address?

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

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?


See Your Saved Posts Timeline

Views: 12529

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

+ Click Here To Join (Our facebook study Group)

Replies to This Discussion

Use a Data Flow Diagram (DFD) to show the relationships among the business processes within an organization to:

 

  • external systems,
  • external organizations,
  • customers,
  • other business processes.

 

Method

 

Data flow diagrams are used to describe how the system transforms information.  They define how information is processed and stored and identify how the information flows through the processes.

 

When building a data flow diagram, the following items should be considered:

 

  • where does the data that passes through the system come from and where does it go,

 

  • what happens to the data once it enters the system (i.e., the inputs) and before it leaves the system (i.e., the outputs),

 

  • what delays occur between the inputs and outputs (i.e., identifying the need for data stores).

 

            Components of a Data Flow Diagram

 

STEPS TO DRAW A DATA FLOW DIAGRAM

 

Steps

 

  • Start from the context diagram.  Identify the parent process and the external entities with their net inputs and outputs.

 

  • Place the external entities on the diagram.  Draw the boundary. 

 

  • Identify the data flows needed to generate the net inputs and outputs to the external entities.

 

  • Identify the business processes to perform the work needed to generate the input and output data flows.

 

  • Connect the data flows from the external entities to the processes.

 

  • Identify the data stores.

 

  • Connect the processes and data stores with data flows.

 

  • Apply the Process Model Paradigm to verify that the diagram addresses the processing needs of all external entities.

 

 

  • Continue to decompose to the nth level DFD.  Draw all DFDs at one level before moving to the next level of decomposing detail.  You should decompose horizontally first to a sufficient nth level to ensure that the processes are partitioned correctly; then you can begin to decompose vertically.

 

Tips and Hints

 

Consider creating a data access model to document the processes that create, update, and delete data in the system.

 

As an alternative to functional decomposition, consider using a bottom-up approach when the details about the system are well known.

 

When analyzing the business system under study in terms of its response to events (for example, user interaction with windowed systems), consider the following:

aoa. upload the detailed solution ASAP

thanx in advance...

tariq bhai plz upload the solution......

goto www.vu.edu.pk and you will find a big image of "Microsoft for All". You can download all the microsoft softwares for free with 2 years license as VU is helping it's students to use the licensed softwares for free.

hey buddies koe tou upload kardo solution ........... its very tough to make these kind of assignments

CS403

Attachments:

plz complete it

Welcome

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.

kiya hamain ye  3 diagram banani ha 

ya 1 hi mn sb explain krna ha 




no 5 tak bana len 6 b 5 me cover ho jata he

yar complete solution send kro plz plzzzzzzzzzzzzzzzzz

hey

can you plz attach complete sol in microsoft word file 

RSS

Latest Activity

Profile Icon+ "αяsαℓ " Ќąƶµяɨ •" and Purple Work joined + M.Tariq Malik's group
1 hour ago
Azhar Sagar liked Azhar Sagar's discussion quiz main kese 10/10 mark la saktay hain cheating ka asan tareeqa
1 hour ago
Azhar Sagar liked Azhar Sagar's discussion Subscribe my youtube channel for assignment solution and final year project help
1 hour ago
M IDREES replied to + M.Tariq Malik's discussion CS403 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 13-11-2019 in the group CS403 Database Management Systems
1 hour ago
Azhar Sagar posted discussions
1 hour ago
M IDREES replied to + M.Tariq Malik's discussion CS403 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 13-11-2019 in the group CS403 Database Management Systems
1 hour ago
M IDREES replied to + M.Tariq Malik's discussion CS403 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 13-11-2019 in the group CS403 Database Management Systems
1 hour ago
M IDREES joined + M.Tariq Malik's group
1 hour ago
M IDREES replied to + M.Tariq Malik's discussion CS502 Fundamentals of Algorithms Assignment No 01 Fall 2019 Solution & Discussion in the group CS502 Fundamentals of Algorithms
1 hour ago
Profile IconM IDREES, Abdul Ghaffar and Umair ali joined + M.Tariq Malik's group
1 hour ago
+ AiM replied to 彡Tweety彡 ❤️'s discussion .... Mera Pakistan... :x:p
1 hour ago
Siddiq khan kakar joined + M.Tariq Malik's group
1 hour ago
+ M.Tariq Malik replied to +¢αяєℓєѕѕ gιяℓ's discussion CS202 - Fundamentals of Front End Development Assignments No. 1 Due Date Nov 14, 2019 in the group CS202 Fundamentals of Front End Development
2 hours ago
+ M.Tariq Malik replied to +¢αяєℓєѕѕ gιяℓ's discussion CS202 - Fundamentals of Front End Development Assignments No. 1 Due Date Nov 14, 2019 in the group CS202 Fundamentals of Front End Development
2 hours ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion MGT211 GDB Fall 2019 Solution & Discussion in the group MGT211 Introduction To Business
2 hours ago
Mian Ali added a discussion to the group MCM520 Contemporary Mass Media
2 hours ago
Mian Ali joined + M.Tariq Malik's group
2 hours ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion EDU302 Human Development and Learning Assignment No 01 Fall 2019 Solution & Discussion in the group EDU302 Human Development and Learning
2 hours ago
Mian Ali joined + M.Tariq Malik's group
2 hours ago
+ M.Tariq Malik replied to + M.Tariq Malik's discussion CS508 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 12-11-2019 in the group CS508 Modern Programming Languages
2 hours ago

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

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