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 / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

How to Add New Discussion in Study Group ? Step By Step Guide Click Here.

Database Management System (CS403)

Assignment No.2

                                           Total Marks:    10

 

 

Deadline

Your assignment must be uploaded before or on Tuesday 27th Nov 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 a most commonly used semantic data model for graphical representation of conceptual database design i.e. Entity Relationship Data model. 
  2. Giving the idea of entities and their attributes and the relationship between them.
  3. Providing an understanding of types of relationships i.e. in how many ways an entity interact with other entity in real world.

 

Important Note:

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.

Hints:

  1. Every data store in DFD must correspond to at least one entity in the ERD.
  2. There should be processes in DFD which create, modify and delete instances of the entities in the ERD.
  3. For every relationship in ERD there should be a process in DFD which uses it.

 

Task Description:

In this assignment you will focus on the tasks given below:

 

  1. You have to identify as many Entities as you can for this system.
  2. You have to find out all possible Attributes of these Entities.
  3. You will have to find the Relationship among those Entities.
  4. Identify all the cardinalities existing between the entities and also show their dependencies.
  5. You will make a final comprehensive ER-diagram consisting of all Entities, Attributes and their relationships along with their respective Primary Keys.

 

You have to perform all these steps given above in your solution file.

 

Note:

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: 

 

  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 your first comprehensive design, so you have to work very keenly and with concentration. This design requires your full attention as this conceptual design will be transformed into a relational model in next assignment. Any mistake in this conceptual design can cause you much burden afterwards.

 

 

Case Study

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

 

 

+ 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: 9779

.

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

Attachments:

Replies to This Discussion

Please Discuss here about this assignment.Thanks

Our main purpose here discussion not just Solution

plzzzzzzzzzzz     Cs403 assignment no 2 ka solution upload kar dain 

You will make a final comprehensive ER-diagram consisting of all Entities, Attributes and their relationships along with their respective Primary Keys.

kindly clear me about the primary key in this daigram

Shazia ap nay assignment bnai hy?

hi yha py i think stck mang has vend ho ga jha tk mjy lgta ha stack mang vend ko supply krta ha my be em wrong ap confrm kr do plz?

waaah

  esi me ko b bana den word file me

Very good attempt...  I think 18/20  ;) 

plzz discuss the solution
entities ke bare me btaye koi
kon kon si entities ban sakti hen?
customer
salesman
inventory
vendor
accountant
stock manager
ye sab sahi hen? kam hen? ya ziyada hen?
in ke attributes b share karen plz

bhaiya jee inventory ki entity kis liy..? owner ki entity bi bany gi...aur baki I think sahi han

attributes kudi sy hi banaty jy apni smj sy...jasy customer ki ...cust_name, cust_id,order_no...etc aur jin entities ka relation banaen un ki primary key zaroor banaen...jasy agar customer and salesman ka relation ha to customer ma cust_id and order_no ko primary key aur in ka salesman ky sat relation ha to salesman ki entity ma order_no primary key....best of luck :)

kaya hum product ko as a entities ly skty hain..?????

RSS

Latest Activity

khurram us salam replied to + M.Tariq Malik's discussion ACC501 GDB Fall 2019 Solution & Discussion in the group ACC501 Business Finance
33 minutes ago
khurram us salam joined + M.Tariq Malik's group
34 minutes ago
+ ՏhehαrZααD + replied to + ՏhehαrZααD +'s discussion Assalamu Alaikum
1 hour ago
+ ! ! ! ! ! Blu Moon replied to + "αяsαℓ " Ќąƶµяɨ •"'s discussion Happy Marriage to "Zee" & " Nomi weds Noor"....!
1 hour ago
+ ! ! ! ! ! ! ! ! ! AG liked + Iuuoɔǝut +'s discussion After and Before Marriage situations
1 hour ago
+ ! ! ! ! ! ! ! ! ! AG liked + Iuuoɔǝut +'s discussion Rules for Happy Marriage Life
1 hour ago
+ ! ! ! ! ! ! ! ! ! AG liked +***piya o ry piya***+'s discussion eng201
1 hour ago
+ ! ! ! ! ! ! ! ! ! AG liked 彡JK彡 ❤️'s discussion جسکی سنو وہی فرشتہ
1 hour ago
+ ! ! ! ! ! ! ! ! ! AG liked + ! ❤INNOCENT❤'s discussion Faqeer
1 hour ago
+++"MinShah"+++ updated their profile
1 hour ago
abdul bari updated their profile
1 hour ago
Zain Arshad replied to + M.Tariq Malik's discussion ENG201 Business and Technical English Writing Assignment No 01 Fall 2019 Solution & Discussion in the group ENG201 Business and Technical English Writing
2 hours ago
+ "αяsαℓ " Ќąƶµяɨ •" replied to + "αяsαℓ " Ќąƶµяɨ •"'s discussion Happy Marriage to "Zee" & " Nomi weds Noor"....!
2 hours ago
+ "αяsαℓ " Ќąƶµяɨ •" replied to + "αяsαℓ " Ќąƶµяɨ •"'s discussion Happy Marriage to "Zee" & " Nomi weds Noor"....!
2 hours ago
+ "αяsαℓ " Ќąƶµяɨ •" and Isha Chuhdary are now friends
2 hours ago
Waseem Aziz added a discussion to the group MGMT627 Project Management
2 hours ago
Waseem Aziz added a discussion to the group STA630 Research Methods
2 hours ago
Waseem Aziz joined + M.Tariq Malik's group
2 hours ago
Zain Arshad replied to + M.Tariq Malik's discussion ENG201 Business and Technical English Writing Assignment No 01 Fall 2019 Solution & Discussion in the group ENG201 Business and Technical English Writing
2 hours ago
Profile IconZain Arshad, Misha Rajpoot and Nimra zahid joined + M.Tariq Malik's group
2 hours ago

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

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