We have been working very hard since 2009 to facilitate in your learning Read More. We can't keep up without your support. Donate Now.

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

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

Looking for Something at Site? Search Below

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


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


Views: 13250

Attachments:

Replies to This Discussion

Entity Names:
Entities with attributes:

NODE_INFO
Node_id, Node_role, protocol_id

PROTOCOL_INFO
Protocol_id, Protocol_name, protocol_version

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

HEADER_INFO
Header_ID, header_size, source_IP, destination_IP

ROUTE_INFO
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

Attachments:

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:

Entities
Relationships
Attributes

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

RSS

HELP SUPPORT

This is a member-supported website. Your contribution is greatly appreciated!

Latest Activity

+M.Tariq Malik's 3 discussions were featured
10 seconds ago
+M.Tariq Malik added a discussion to the group CS712 Distributed DBMS
48 seconds ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion STA301 Final Term Papers Spring 2020 & Past Solved Papers, MCQs for Exam Preparation in the group STA301 Statistics and Probability
7 minutes ago
gull hassan joined +M.Tariq Malik's group
8 minutes ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion BIF501 Current Final Term Papers Spring 2020 & Solved MCQs, Short Notes, Solved Past Papers, Solved Online Quizzes, E-Books, FAQs, Short Questions Answers & More in the group BIF501 Bioinformatics II
8 minutes ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion MTH101 Current Final Term Papers Spring 2020 & Solved MCQs, Short Notes, Solved Past Papers, Solved Online Quizzes, E-Books, FAQs, Short Questions Answers & More in the group MTH101 Calculus And Analytical Geometry
9 minutes ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion STA641 Current Final Term Papers Spring 2020 & Solved MCQs, Short Notes, Solved Past Papers, Solved Online Quizzes, E-Books, FAQs, Short Questions Answers & More in the group STA641 - Statistical Packages and its Applications
10 minutes ago
+M.Tariq Malik replied to +M.Tariq Malik's discussion STA641 Current Final Term Papers Spring 2020 & Solved MCQs, Short Notes, Solved Past Papers, Solved Online Quizzes, E-Books, FAQs, Short Questions Answers & More in the group STA641 - Statistical Packages and its Applications
10 minutes ago

Today Top Members 

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

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

.