Assignment No. 02 Semester Fall2010 Database Management Systems-CS403 2010

[Xpert]

Q Draw an E-R diagram for each of the following situations:

1. In an Organization each of Corporation division is composed of many departments. Each of the departments has many employees assigned to it, but each employee works for only one department. The attributes of EMPLOYEE include NAME, ADDRESS, BIRTHDATE and the attributes of DEPARTMENT are DEPT_NO and DEPT_NAME. 5 Marks
   

1. A university have many colleges where as each college belongs to only that university. Each college is offering many degrees where as each degree is offered by only single college in that university. One college can have many students but one student can only be registered in one college. One student can have study many courses where as many courses can be taught by many students. 5 Marks
   

1. A bank can have many branches where as each branch belongs to one bank. Each branch can approve many loans where as each loan can be approved by single branch 5 Marks
   

Solution will be uploaded soon.

[Xpert]

find the attachment for solution