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
State about the Tables- DBMS Data is stored in columns and rows (much like a spreadsheet -main difference is how data is organised). Every row in a table is known as a record

To delete a particular column in a relation which command is used ? To delete a particular column in a relation ALTER command is used.

Differentiate OO development from structured development. Structured approach of problem solving is based upon the idea of decomposition of system into subsystem. In this appro

describe all the tables you have created. ?get table_name, status, num_rows, user_stats in user_tables system view ?get table_name, constraint_name, constraint_type in user_constr

Multi-Key File Organisation In this part, we will introduce two basic file Organisation schemes that permit records to be accessed by more than one key field, therefore, allowi


DISADVANTAGES OF RDBMS

What are the reasons of bucket overflow? Explain any two methods for solving this problem. Ans:  It is general for file structures to be divided into equal-length partitions, k

A table joined with itself is called ? A table joined with itself is known as self join table. Normal 0 false false false EN-IN X-NONE X-NONE

The insertion of a tuple in the aim of reference does not cause any destruction. Though, insertion of a tuple in the relation in which, we has the foreign key, for instance, in ASS