Draw entity relationship diagram, Database Management System

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







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
Related Questions
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?     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

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 we delete data element, which is being used by table fields. No we cant delete data element.

coventions for displaying an ER schema as ER diagram

Example RELATION SCHEMA for STUDENT: STUDENT (Roll No: string, name: string, login: string, age: integer) RELATION INSTANCE

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

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

(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

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