Sponsored Links

Results 1 to 2 of 2

Thread: CS403 Database Management System VU Assignment No 1 Fall semester 3rd November 2012

  1. #1
    Senior Member
    Join Date
    Oct 2012

    Icon51 CS403 Database Management System VU Assignment No 1 Fall semester 3rd November 2012

    Sponsored Links

    CS403 Database Management System VU Assignment No 1 Fall semester 3rd November 2012

    Sponsored Links


    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.

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

  2. #2
    Administrator Vuhelper's Avatar Users Flag!
    Join Date
    Apr 2011

    Idea Solution

    We have to identify External Entities, which I think are:-
    Sales Person of Best Mart
    Shop Owner
    Databases are:-
    Items/ Product Info
    Customer Accounts
    Another thing we missed are:
    The Data Storage will contain following:
    1. Item Master
    2. Customer Master
    3. User Master (this way I will create type which will tell me user types, such as
    salesman, owners, administrator etc.
    4. Vendor Master
    5. Sales Data
    Remember at the end of line it ask for the report generation, which is only
    possible if you have sales data table where you will store the sales information.
    Here are samples of context level of dfd. and 0 level dfd
    Please make changes and made it as u understand it.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 11
    Last Post: 12-29-2011, 10:17 PM
  2. Replies: 0
    Last Post: 12-23-2011, 03:33 PM
  3. Replies: 19
    Last Post: 11-22-2011, 07:57 PM
  4. Replies: 1
    Last Post: 11-04-2010, 07:21 PM
  5. Replies: 0
    Last Post: 10-25-2010, 02:37 PM

Visitors found this page by searching for:

cs403 assignment#1 solutions

cs403 current assignment nov 2012

database management systems-cs403 assignment 1

cs403 assignment no 2 solution fall 2012

cs403 assignment solution fall 2012

CS403 Assignment 1 Fall 2012

cs403 assignment 2 solution fall 2012

cs403 assignment#1 solutions fall 2012

answers of all assignment of dbms of salesmen order

cs 403 assignment no 3 solution fall 2012

Database Management System (CS403) Assignment No.1

cs403 - database management systems assignment 1 nov 12

a complete physical database for “Trade Management System”

cs403 1st assignmennt solution 14 november 2012

cs403 assignment solution

CS403 Assignment solution 2 fall 2012


vu solved 1st assignment of cs403 fall 2012

assignment no 1 solution cs403 12-11-2012

cs403 assignment 2 fall 2012

cs403 1st assignment

cs403 assignment 1 solution 2012

cs403 assignment no 2 fall 2012

cs403 assignment 1 solution fall 2012

cs 403 assignment #1 solution of fall

SEO Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
-: Vuhelp Disclaimer :-
None of the files shown here are hosted or transmitted by this server. The links are provided solely by this site's users. The administrator's or staff of Vuhelp.net cannot be held responsible for what its users post, or any other actions of its users. You may not use this site to distribute or download any material when you do not have the legal rights to do so. It is your own responsibility to adhere to these terms. If you have any doubts about legality of content or you have any suspicions, feel free to contact us.
Online Education | JhelumSoft