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


Dear Students! Share your Assignments / GDBs files as you receive in your LMS, So it can be discussed/solved timely. Files Upload Here.

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: 12531

.

+ 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

plz koi tou solution upload kar de..........

some hints i found are:

 

We have to identify External Entities, which I think are:-

Customer

Sales Person of Best Mart

Shop Owner

Accountant

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.

 

Good Idea Solution

cs403 idea file

Attachments:

nice tariq bahi...

We have to identify External Entities, which I think are:-

 

Customer, Sales Person of Best Mart, Shop Owner ,Accountant

 

Databases are:- Items/ Product Info ,Customer Accounts

 

Another thing we missed are:

 

The Data Storage will contain following:

 

  1. Item Master

 

  1. Customer Master

 

  1. User Master (this way I will create type which will tell me user types, such as salesman, owners, administrator etc.

 

  1. Vendor Master

 

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

 

nice work tariq bhai

block diagram not clear

please clear the diagram

 Fozia Lakho gud & thanks 

what about payment flexibility system ...yh process ho gaaur is ka relation kis kis entity sy bany ga.

debtor and creditor checker system 0 level ma ana chahiyh ya detailed ma

please upload final solution files

RSS

Latest Activity

zuha shah posted a discussion
8 minutes ago
Nabeel Ahmed joined + M.Tariq Malik's group
11 minutes ago
+EniE MeNiE replied to + Iuuoɔǝut +'s discussion بعد مُدت اُسے دیکھا، لوگو
12 minutes ago
+ ! ! ! ! Mehαr Mαh꧂ liked + M.Tariq Malik's discussion PSY101 Introduction to Psychology Assignment No 01 Fall 2019 Solution & Discussion
30 minutes ago
+¢αяєℓєѕѕ gιяℓ posted discussions
37 minutes ago
+ ! ! ! ! Mehαr Mαh꧂ replied to + ! ! ! ! Mehαr Mαh꧂'s discussion Assignment #1 MCM511 Theories of Communication fall 2019 in the group MCM511 Theories of Communication
54 minutes ago
+¢αяєℓєѕѕ gιяℓ replied to +¢αяєℓєѕѕ gιяℓ's discussion Mera tu Mohabbat se aitbar.............:-P
1 hour ago
+ ! ! ! ! Mehαr Mαh꧂ liked + ! ! ! ! Mehαr Mαh꧂'s discussion Assignment #1 MCM511 Theories of Communication fall 2019
1 hour ago
+ Iuuoɔǝut + posted discussions
1 hour ago
彡JK彡 ❤️ replied to Aijaz khan's discussion CS510 Assignment Fall 2019 Need Solution
3 hours ago
彡JK彡 ❤️ liked Aijaz khan's discussion CS510 Assignment Fall 2019 Need Solution
3 hours ago
Aijaz khan posted a discussion
5 hours ago
HaMza Tufail added a discussion to the group CS519 Final Project
7 hours ago
HaMza Tufail joined + M.Tariq Malik's group
7 hours ago
Fatima joined + M.Tariq Malik's group
8 hours ago
Adnan Hafeez replied to MIT's discussion Visual Programing (CS411) Assignment#01 Deadline Date = 18-11-2019 in the group CS411 Visual Programming
8 hours ago
Shine--Ex-VUStudent liked ١ دن's discussion زندگی گزارنے کا فارمولا
8 hours ago
HaMza Tufail added a discussion to the group CS420 Web Development for Portable Devices
9 hours ago
HaMza Tufail updated their profile
9 hours ago
١ دن replied to + Iuuoɔǝut +'s discussion بعد مُدت اُسے دیکھا، لوگو
9 hours ago

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

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