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


+ Link For Assignments, GDBs & Online Quizzes Solution


+ Link For Past Papers, Solved MCQs, Short Notes & More

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. 


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.


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


+ 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

Entity Names:
Entities with attributes:

Node_id, Node_role, protocol_id

Protocol_id, Protocol_name, protocol_version

Packet_id, Node_id, Sequence_number, RTT, data_contents, data_size, Header_id, Route_id

Header_ID, header_size, source_IP, destination_IP

Route_id, Number_hops, route_weight

For ER-Diagram plz view last semester's 2nd sol.

Gulnaz... you are indeed very helpful! thanks alot dear for sharing your ideas :)

ER_Diagram of assignment Fall 2013


Dear Fellows you can create ER_Diagram by these simple steps.
1. open MS Visio 2013
2. Select Blank Drawing then Create
3.More Shapes -> Software and Database -> Database -> Crow's Foot Database Notation and UML Database Notation.

Best of luck. Remember me in your prayers

Thanks for sharing sis 

Thanks for helping. But dear this is in table formate. Where is E-R model? as discussed in lectures. Can u please provide that one? waiting for good response from you and all the members.

Spring 2014 Assignment No. 02, Entities: 

thnx gulnaz

Dear Students Don’t wait for solution post your problems here and discuss ... after discussion a perfect solution will come in a result. So, Start it now, replies here give your comments according to your knowledge and understandings....

Definition - What does Entity-Relationship Diagram (ERD) mean?

An entity-relationship diagram (ERD) is a data modeling technique that graphically illustrates an information system’s entities and the relationships between those entities. An ERD is a conceptual and representational model of data used to represent the entity framework infrastructure.

The elements of an ERD are:


Steps involved in creating an ERD include:

Identifying and defining the entities
Determining all interactions between the entities
Analyzing the nature of interactions/determining the cardinality of the relationships
Creating the ERD


Latest Activity

+ ! ! ! ! ! ! maho+++ liked + ! ! ! ! ! ! ! ! ! ! ! ! ! ! !'s discussion Hamesha sath rehne ki aadat kuch nahin hoti
6 minutes ago
+ ! ! ! ! ! ! maho+++ replied to + ! ! ! ! ! ! ! ! ! ! ! ! ! ! !'s discussion Hamesha sath rehne ki aadat kuch nahin hoti
7 minutes ago
+ ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! posted a discussion
19 minutes ago
abdul ghafoor replied to + M.Tariq Malik's discussion PSY101 Introduction to Psychology Assignment No 01 Fall 2019 Solution & Discussion in the group PSY101 Introduction to Psychology
23 minutes ago
+ ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! replied to ٹمبکٹو's discussion محبّت اور دل - عشق مجازی
25 minutes ago
+ Iuuoɔǝut + posted discussions
37 minutes ago
+ Iuuoɔǝut + replied to ٹمبکٹو's discussion محبّت اور دل - عشق مجازی
40 minutes ago
+ Iuuoɔǝut + replied to + "J ɨ y ą ⋆'s discussion Mohabat
45 minutes ago
+ Iuuoɔǝut + replied to + "J ɨ y ą ⋆'s discussion Hona chahy tha.......
47 minutes ago
+ ! ! ! ! ! MySterIouS replied to ٹمبکٹو's discussion محبّت اور دل - عشق مجازی
1 hour ago
+ "J ɨ y ą ⋆ replied to + M.Tariq Malik's discussion CS402 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 15-11-2019 in the group CS402 Theory of Automata
1 hour ago
+ "J ɨ y ą ⋆ joined + M.Tariq Malik's group
1 hour ago
+ "J ɨ y ą ⋆ posted discussions
1 hour ago
+ "J ɨ y ą ⋆ liked + ! ! ! ! ! ! BLaiRe ! !+'s blog post ***NooR E KeyAnAT******HaPpy BiRtH DaY
2 hours ago
+ "J ɨ y ą ⋆ liked +¢αяєℓєѕѕ gιяℓ's blog post Now No One Can Break me.........!
2 hours ago
+ "J ɨ y ą ⋆ liked + ! ! ! ! ! ! maho+++'s blog post muhabat k nam pegham
2 hours ago
+ "J ɨ y ą ⋆ liked + ! ! ! ! ! ! ! Ayesha +++'s blog post some suggestions of Hazrat Muhammad (PBUH)
2 hours ago
+ "J ɨ y ą ⋆ liked + ! ! ! ! ! ! maho+++'s blog post Muhammad Mustafa Aye Bahar Andar Bahar Aaye
2 hours ago
+ "J ɨ y ą ⋆ liked + ! ! ! ! ! MySterIouS's blog post + Beginning +
2 hours ago
+ "J ɨ y ą ⋆ liked + ! ! ! ! ! MySterIouS's blog post + Attitude +
2 hours ago

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

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