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.

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 from lectures (7-13) in order to finalize the tasks of second assignment listed below in task description. 

Reference:

Please refer to the case study given in assignment no. 1 as well as to the solution of assignment 1.

Note: Same case study is also given at the end of this assignment for your convenience.

Task:

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

Draw a comprehensive ER-diagram along with their relationships and cardinalities.

You have to perform all the necessary steps that are included in the above task in your solution file.

 

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

 

Suppose we have a wireless ad hoc network. A wireless ad hoc network is a decentralized type of wireless network. The network is ad hoc because it does not rely on a pre existing infrastructure, such as routers in wired networks or access points in managed (infrastructure) wireless networks. Instead, each node participates in routing by forwarding data for other nodes, so the determination of which nodes forward data is made dynamically on the basis of network connectivity.

Nodes in the ad hoc network has unique id that identify it across the network. Each of the nodes uses a certain protocol.

Various protocols are used including aodv, dsdv, dsr etc. There are various version of a specific protocol. An ad hoc network typically refers to any set of networks where all devices have equal status on a network and are free to associate with any other ad hoc network device in link range.

Nodes in the ad hoc networks send packets to each other. Each packet has two parts namely: header and data. Header information contains source destination address and some other information. Each packet is sent on one of the route based on the source destination address. There can be several hopes around one route. Every route is assigned a weight based on some pre defined rule. 

 

 

 

 

Good Luck

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

.

+ 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

[Image: screen_01.gif]

solution

Tariq bro, i think cardenality b/w Packet and header is not one to many but one to one....

yeah furqan u r rit beauce every packet have single header and vice versa


Thank u r sharing  :)

An entity-relationship diagram is a data modeling technique that creates a graphical representation of the entities, and the relationships between entities, within an information system.

The three main components of an ERD are:

The entity is a person, object, place or event for which data is collected. For example, if you consider the information system for a business, entities would include not only customers, but the customer's address, and orders as well. The entity is represented by a rectangle and labelled with a singular noun.
The relationship is the interaction between the entities. In the example above, the customer places an order, so the word "places" defines the relationship between that instance of a customer and the order or orders that they place. A relationship may be represented by a diamond shape, or more simply, by the line connecting the entities. In either case, verbs are used to label the relationships.
The cardinality defines the relationship between the entities in terms of numbers. An entity may be optional: for example, a sales rep could have no customers or could have one or many customers; or mandatory: for example, there must be at least one product listed in an order. There are several different types of cardinality notation; crow's foot notation, used here, is a common one. In crow's foot notation, a single bar indicates one, a double bar indicates one and only one (for example, a single instance of a product can only be stored in one warehouse), a circle indicates zero, and a crow's foot indicates many. The three main cardinal relationships are: one-to-one, expressed as 1:1; one-to-many, expressed as 1:M; and many-to-many, expressed as M:N.

The steps involved in creating an ERD are:

Identify the entities.
Determine all significant interactions.
Analyze the nature of the interactions.
Draw the ERD.

thanks alot haroon khan....its really helpful for develop  relationships :)

nice but kch smj nhi a rhi es ki

same mjy b

yes mujay bi nahi aai

RSS

Latest Activity

ALEENA liked + ! ! ! ! ! ! ! ! ! ! ! ! ! ! !'s discussion 100 Instructions from the Quran
2 minutes ago
ALI RAZA joined + M.Tariq Malik's group
7 minutes ago
+¢αяєℓєѕѕ gιяℓ replied to +¢αяєℓєѕѕ gιяℓ's discussion My Quiz CS408 Last Date 21.11.2019 in the group CS408 Human Computer Interaction
20 minutes ago
Profile IconTayyaba Talib, ALI RAZA, Husnain Kan and 26 more joined Virtual University of Pakistan
21 minutes ago
+¢αяєℓєѕѕ gιяℓ replied to +¢αяєℓєѕѕ gιяℓ's discussion My Quiz CS408 Last Date 21.11.2019 in the group CS408 Human Computer Interaction
22 minutes ago
arooj liked + M.Tariq Malik's discussion EDU402 Final Term Papers Spring 2019 (24 August ~ 04 September 2019) & All Solved Past Papers, Solved MCQs & Helping Material
23 minutes ago
+¢αяєℓєѕѕ gιяℓ replied to +¢αяєℓєѕѕ gιяℓ's discussion My Quiz CS408 Last Date 21.11.2019 in the group CS408 Human Computer Interaction
23 minutes ago
+¢αяєℓєѕѕ gιяℓ added a discussion to the group CS408 Human Computer Interaction
24 minutes ago
+Mr President updated their profile
45 minutes ago
A_Q added a discussion to the group ENG513 Language Teaching Methods
1 hour ago
ALEENA replied to + M.Tariq Malik's discussion Site Overview | Assignment Solutions | Past Papers Solutions | VU Students Features
1 hour ago
+ !! "AS" !! replied to + !! "AS" !!'s discussion Ghalti...
1 hour ago
ALEENA liked + Iuuoɔǝut +'s discussion MTH401_Mid term Solved (Part I) with refrence
1 hour ago
Shine--Ex-VUStudent liked + !! "AS" !!'s discussion Yaha Har Cheez ..
1 hour ago
Shine--Ex-VUStudent liked +¢αяєℓєѕѕ gιяℓ's discussion Iss tasvir ko Unwan Dein :-P
1 hour ago
ALEENA replied to ٥ دن's discussion Gunahon ki gehrai
1 hour ago
ALEENA replied to + !! "AS" !!'s discussion Ghalti...
1 hour ago
ALEENA replied to Siddiq khan kakar's discussion RIP
1 hour ago
Muhammad Hamza Mehmood liked Faiza's profile
1 hour ago
Profile IconKhan and zuha shah joined + M.Tariq Malik's group
1 hour ago

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

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