Draw entity relationship diagram for the following scenario.

A university has many departments whereas each department belongs to that particular uni. That uni has also many buildings whereas each building belongs to that particular uni . The uni has also many employees whereas each employee belongs to that particular uni. Every employee has only one parking space whereas each parking space belongs to only one employee.

Department offers many study programs whereas each program by only a single department.

 

Posted Date: 3/15/2013 2:30:40 AM | Location : United States

Ask an Expert

Related Discussions:- Draw entity relationship diagram, Assignment Help, Ask Question on Draw entity relationship diagram, Get Answer, Expert's Help, Draw entity relationship diagram Discussions

Write discussion on Draw entity relationship diagram
Your posts are moderated

Write your message here..

Related Questions

Explain transaction manager and their work, Explain Transaction manager and... Explain Transaction manager and their work? Transaction Manager: Ensure the database remains in a constant (correct) state despite system failure, and in which concurrent trans

What is a query tree, What is a query tree?     Ans:  A query tree, as ... What is a query tree?     Ans:  A query tree, as well known as operator graph, is a tree data structure that corresponds to a relational algebra expression. It denotes the inpu

Implement a cache simulator, You are required to program (in a high level l... You are required to program (in a high level language such as C, C++, Java) and implement a cache simulator which will have the following inputs and outputs:- INPUTS

Can you delete data element, Can we delete data element, which is being use... Can we delete data element, which is being used by table fields. No we cant delete data element.

ER model, coventions for displaying an ER schema as ER diagram coventions for displaying an ER schema as ER diagram

Relation schema for student, Example RELATION SCHEMA for STUDENT: STU... Example RELATION SCHEMA for STUDENT: STUDENT (Roll No: string, name: string, login: string, age: integer) RELATION INSTANCE

Lack of standards and experience, Lack of standards and experience: The la... Lack of standards and experience: The lack of standards has considerably limited the potential of distributed DBMSs. As well, there are no tools or methodologies to help users cha

Join relation of two tuples, Consider the join of a relation R with relatio... Consider the join of a relation R with relation S. If R has m tuples and S has n tuples, then the maximum size of join is: If R has m tuples and S has n tuples then maximum siz

Define integrity, (a) Explain briefly the three parts of a relational Model... (a) Explain briefly the three parts of a relational Model. (b) Contrast the following terms with an appropriate example: (i) stored attribute v/s derived attribute (ii) en

Subclassing, In the ER diagram, one example of subclassing is depicted foll... In the ER diagram, one example of subclassing is depicted following the Services entity. The subclasses Item Based and Time Based are created. The entity Services gains the attribu