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

Assignment No. 02
Semester Spring 2010
Database Management Systems-CS403

 

Total Marks: 20

 

Due Date: 12/05/2010

 

Objective:

To learn and understand basic concepts of different levels of Data Flow Diagrams (DFD’s).

Instructions:

Please read the following instructions carefully before solving & submitting assignment:

It should be clear that your assignment will not get any credit (zero marks) if:

 

o        The assignment is submitted after due date.

o        The submitted assignment does not open or file corrupt.

o        The assignment is copied (from other student or copy from handouts).

o        Student ID is not mentioned in the assignment File or name of file is other than student ID.

 

For any query about the assignment, contact at cs403@vu.edu.pk

 

GOOD LUCK

 

 

 

Q Draw an E-R diagram for each of the following situations:

 

  1. Each of Corporation division is composed of many departments. Each of the departments has many employees assigned to it, but each employee works for only one department. The attributes of EMPLOYEE include NAME, ADDRESS, BIRTHDATE and the attributes of DEPARTMENT are DEPT_NO and DEPT_NAME.   5 Marks

 

  1. During some period of time, a customer can rent many videos from the Video Store. Each of the VideoStore’s can be rented to many customers during that period of time.    5 Marks

 

  1. An Airline can be assigned to fly many flights, but each flight is flown by only one airline.                 5 Marks

 

  1. An employee may have earned many degrees, and each degree may have been earned by many employees.       5 Marks 

 

Guidelines / Instructions

It is required to draw Entity Relationship Diagrams for each of the upper situations using Chen’s notation. A sample can be found at http://en.wikipedia.org/wiki/Entity-relationship_model . It is also required to clearly mention that either the relationship is One-to-One, One-to-Many or Many-to-Many. Figures can be drawn using MS Visio, Erwin or MS Word.

Upload Instructions:

Please view the document related to assignment submission process provided to you by the Virtual University to upload the assignment.

 

Please Discuss Here about this assignment.Thanks

                                                                                                                           

 

 

 

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

.

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

Latest Activity

+ M.Tariq Malik replied to + !! SARAH's discussion Beauty Of Fear !!
10 seconds ago
+ M.Tariq Malik liked + !! SARAH's discussion Beauty Of Fear !!
54 seconds ago
+ M.Tariq Malik replied to + ! ✨ ░S░I░N░G░E░R's discussion Pride for Pakistan (Gold Medal in World Beach Games' 90kg Category)
3 minutes ago
+ M.Tariq Malik liked + ! ✨ ░S░I░N░G░E░R's discussion Pride for Pakistan (Gold Medal in World Beach Games' 90kg Category)
4 minutes ago
+ M.Tariq Malik replied to + Iuuoɔǝut+'s discussion Mantoo Speaks...
4 minutes ago
+ M.Tariq Malik liked + Iuuoɔǝut+'s discussion Mantoo Speaks...
5 minutes ago
+ ! ✨ ░S░I░N░G░E░R posted a discussion
6 minutes ago
+ M.Tariq Malik replied to Whispering Soul's discussion شاہی جوڑے کی رکشہ میں آمد
6 minutes ago
+ M.Tariq Malik liked Whispering Soul's discussion شاہی جوڑے کی رکشہ میں آمد
7 minutes ago
+ M.Tariq Malik liked + "αяsαℓ " Ќąƶµяɨ •"'s blog post نظر لگنا کیا ہے اور بُری نظر انسان کے جسم پر کیسے اثر انداز ہوتی ہے
12 minutes ago
+ "αяsαℓ " Ќąƶµяɨ •" posted a blog post
17 minutes ago
+ ! ! (MmM) MuStAfA MaDaNi ! updated their profile
26 minutes ago
+ Iuuoɔǝut+ replied to 彡JK彡 ❤️'s discussion ............ A public service message...........
33 minutes ago
+ "αяsαℓ " Ќąƶµяɨ •" left a comment for asim ur rehman
48 minutes ago
+ "αяsαℓ " Ќąƶµяɨ •" left a comment for MALIK G
49 minutes ago
+ "αяsαℓ " Ќąƶµяɨ •" left a comment for IBS
50 minutes ago
+ Iuuoɔǝut+ posted discussions
1 hour ago
+ Iuuoɔǝut+ replied to + Iuuoɔǝut+'s discussion How Can You Get Secured of Being Banned On Ning
1 hour ago
Asmat replied to + M.Tariq Malik's discussion VU Students Reserves The Right to Delete Any Profile On the Site
1 hour ago

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

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