We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>
Your assignment must be uploaded before or on Tuesday 27th Nov 2012.
It should be clear that your assignment will not get any credit if:
The objectives of this assignment are,
This Assignment is the continuation of First Assignment. Take same case study given in Assignment 1 (also provided at the end of this assignment), apply the techniques and methods given in lectures and by utilizing the solution of first assignment uploaded on LMS in the form of DFD in order to finalize the tasks of second assignment listed below in task description. Some hints are provided below to link DFD with ERD which can be helpful in your design process.
In this assignment you will focus on the tasks given below:
You have to perform all these steps given above in your solution file.
Use all concepts you have studied so far and techniques in order to identify Entities, attributes and their relationships of the given case study discussed particularly from 7 to 14 regarding ER data model.
Drawing Final ER Data Model:
You can use any tool for drawing like MS Office or Visio.
Important things to consider:
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 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.
+ Click Here To Join also Our facebook study Group.+ How to Join Subject Study Groups & Get Helping Material? + How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?
.+ 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?)
yahn per jo attribute mention kiay han unki jagah per kya aiy ga
This is the Spring 2012 Assignment. The current assignment is exactly like this, you only have to change it as per current scenario. Rest will remain same...
Hope it helps...
cs403 ka full solution de do aj extended day ha plzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz koi to de do
oper five different and right solutions diye huay hain... koi aik choose kr kay changes kr lien
plz anyone help and upload complete solution plzzzzzzzzzzzzzzzzz
nice discussion @parifozu
umer bhai aap ka takriban fittye moun.
Can anyone help me out regarding the use of SQL server management express on win 7?
I am not able to create database on it? error 262
what should I do?