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

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

.

+ 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

Lets Discuss Students ... 

Entity Relationship Diagram (ERD)

Also called an entity-relationship (ER) diagram, a graphical representation of entities and their relationships to each other, typically used in computing in regard to the organization of data within databases or information systems. An entity is a piece of data-an object or concept about which data is stored.


A relationship is how the data is shared between entities. There are ypes of relationships between entities:

. One-to-One
One instance of an entity (A) is associated with one other instance of another entity (B). For example, in a database of employees, each employee name (A) is associated with only one social security number (B).One-to-Many
One instance of an entity (A) is associated with zero, one or many instances of another entity (B), but for one instance of entity B there is only one instance of entity A. For example, for a company with all employees working in one building, the building name (A) is associated with many different employees (B), but those employees all share the same singular association with entity 

. Many-to-Many
One instance of an entity (A) is associated with one, zero or many instances of another entity (B), and one instance of entity B is associated with one, zero or many instances of entity A. For example, for a company in which all of its employees work on multiple projects, each instance of an employee (A) is associated with many instances of a project (B), and at the same time, each instance of a project (B) has multiple employees (A) associated with it. 

ER diagram

Attachments:

thnkx 

plz sent me cs403 2nd assingment soulation

maham sis

is ke complete solution to upload karo

Thanks For Sharing 

final solution upload kr doo plzzzzzzzzzzzzzzzzzzz

Case Study itni boring...ooper se guzr gai...

main na wo pari he nai bas qustion dakhy thy 

Ushna abi to aj 21 ha last 26 ha abi se mun latka lia 

Definition - What does Cardinality mean?

In the context of databases, cardinality refers to the uniqueness of data values contained in a column. High cardinality means that the column contains a large percentage of totally unique values. Low cardinality means that the column contains a lot of “repeats” in its data range.

It is not common, but cardinality also sometimes refers to the relationships between tables. Cardinality between tables can be one-to-one, many-to-one, or many-to-many.

RSS

Latest Activity

彡JK彡 ❤️ replied to + "αяsαℓ " Ќąƶµяɨ •"'s discussion Muhabato me li gaye kasmain
3 minutes ago
彡JK彡 ❤️ replied to + M.Tariq Malik's discussion غیر پھر غیر، درگزر کر دے - کون روکے زبان اپنوں کی
8 minutes ago
彡JK彡 ❤️ replied to 彡JK彡 ❤️'s discussion ............. ایک تلخ حقیقت..........
11 minutes ago
彡JK彡 ❤️ replied to 彡JK彡 ❤️'s discussion ............. ایک تلخ حقیقت..........
12 minutes ago
彡JK彡 ❤️ replied to +¢αяєℓєѕѕ gιяℓ's discussion Jin sey Mohabbat Ho.....
14 minutes ago
彡JK彡 ❤️ replied to + "Jɨyą's discussion Tou ho jay shairiiii XD XD
16 minutes ago
彡JK彡 ❤️ replied to +¢αяєℓєѕѕ gιяℓ's discussion xD.........................پرانی محبوبہ کے نام
23 minutes ago
彡JK彡 ❤️ replied to + ! ! nO pAnGa's discussion Read this out Loud !!!!!!!!!
26 minutes ago
彡JK彡 ❤️ replied to + Iuuoɔǝut+'s discussion STORY OF BLIND LOVE
48 minutes ago
彡JK彡 ❤️ replied to 彡JK彡 ❤️'s discussion Dedicated To All Fake IDs............ :p:p
1 hour ago
彡JK彡 ❤️ replied to 彡JK彡 ❤️'s discussion Dedicated To All Fake IDs............ :p:p
1 hour ago
Laravel replied to Whispering Soul's discussion "Izat" do trfa chez hai..
1 hour ago
Laravel replied to + Iuuoɔǝut+'s discussion STORY OF BLIND LOVE
1 hour ago
彡JK彡 ❤️ replied to + M.Tariq Malik's discussion Follow the Main Forum & Study Groups New Added Discussions at Your Mail Address
1 hour ago
+ ! ! ! ! ᎠixieᎠuຮt꧂ replied to +¢αяєℓєѕѕ gιяℓ's discussion xD.........................پرانی محبوبہ کے نام
1 hour ago
+ ! ! ! ! ᎠixieᎠuຮt꧂ liked + Iuuoɔǝut+'s blog post The End Is Not Near, But If An 'Insect Apocalypse' Ever Happens, How Would We Know?
2 hours ago
+ ! ! ! ! ᎠixieᎠuຮt꧂ liked moniba hussain's blog post love
2 hours ago
+ ! ! ! ! ᎠixieᎠuຮt꧂ liked moniba hussain's blog post fun
2 hours ago
+ ! ! ! ! ᎠixieᎠuຮt꧂ liked +¢αяєℓєѕѕ gιяℓ's discussion zevar Mard Pr Haram hai xD
2 hours ago
+ ! ! ! ! ᎠixieᎠuຮt꧂ liked +¢αяєℓєѕѕ gιяℓ's discussion xD.........................پرانی محبوبہ کے نام
2 hours ago

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

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