CS 403 2nd idea Solution

CS 403 2nd Idea Solution

Entity-Relationship Diagrams (ERD)

Data models are tools used in analysis to describe the data requirements and assumptions in the system from a top-down perspective. They also set the stage for the design of databases later on in the SDLC.

There are three basic elements in ER models:

1) Entities are the "things" about which we seek information.

2) Attributes are the data we collect about the entities.

3) Relationships provide the structure needed to draw information from multiple entities.

a. In an Organization each of Corporation division is of many departments.

Each of the departments has many employees 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.

Solution:

b. 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

Solution:

c. 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.

Solution: