CS403 Assignment No. 2 Announced

Assignment No. 02 

Semester Spring 2011

Database Management Systems-CS403

Total Marks: 15

Due Date: 25/04/2011

Objective: To learn and understand basic concepts of ER Diagram. 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: The assignment is submitted after due date. The submitted assignment does not open or file is corrupt. The assignment is copied (from other student or copy from handouts). The assignment is in the format other than MS Word (doc). 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

Q Draw an E-R diagram for each of the following situations: A University has many departments whereas each department belongs to that particular university. That university has also many buildings whereas each building belongs to that particular university. The University also has many employees whereas each employee belongs to that particular university. Every employee has only one parking space whereas each parking space belongs to only one employee. Department offers many study programs whereas each programs offered by only a single department. 7.5 Marks In a shopping Store there are many supervisors whereas each supervisor belongs to one store. Product belongs to a single vendor whereas vendor provides so many products. Product belongs to a single category whereas category has many products. A category belongs to a single shelf in a store whereas a shelf may have more than one categories’ products.7.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

Mgt111 GDB solution

According to Laswell, politics is “who gets what, how, when and where.” Suppose you are Secretary of XYZ Ministry. You want to set up a new department of security in your organization to protect employees. This cover’s ‘what’ portion of Laswell’s definition of politics. Please explain ‘how’ organizational politics can be used in this case? Why politics is essential to setup a new department?

::::::::::::::::::

Solution:

Harold Lasswell defined values as desired goals and power as the ability to participate in decisions, and he conceived political power as the ability to produce intended effects on other people. In our particular scenario the secretary of XYZ Ministry wants a new department for the employees of the Ministry. To achieve this goal the Secretary must establish the fact that this new department is a need for the employees. Lasswell also maintained that power is held by the elite so the decision and work to establish the department must come through the secretary and after its completion the employees should be informed of it.