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
What are data models? Explain it detail? Entity relationship model Rectangles Ellipse Diamonds Lines Relational model Relational model use a collection

Describe entity referential integrity and integrity. Give an example of each. Entity Integrity Rule - If there is a attribute A of relation R is a prime attribute of R then A

UNION If R1 and R2 are two union compatible relations then R3 = R1 ∪ R2 is the relation having tuples that are either in R1 or in R2 or in both. In case, R3 will have tuples

Define the terms   i) DDL   ii) DML   DDL: Data base schema is specified by a set of definitions expressed by a special   language known as a data def

what would go in order patient#, patient name, patien address, surgeon#, surgeon name, surgery date, surgery type, drug admin

Describe the capabilities offered via MySQL client APIs? . • Checking for errors. . • Connecting to the MySQL server, selecting a database, disconnecting from the server

What is Cross Product? Simply Cross product is Binary Operator

Define the concept of generalization A generalization is relationship between specific kind of thing and general thing. It is also known as "is-a-kind-of" relationship. Inher

Key to represent relationship amongs tables is called ? A Key that represent the relationship between tables is called Foreign Key.

What is the difference between link and reference? The fundamental difference between links and references is that links are symmetrical on the other hand references refer only