Question

Develop a conceptual ER diagram for the above database description, using appropriate syntaxes, and showing cardinalities and key attributes.

Consider the partial description for a UNIVERSITY database below:

A university is organized into colleges, and each college has a unique name, a main office and phone, and a particular faculty member who is dean of the college. Each college administers a number of academic departments. Each department has a unique name, a unique code number, a main office and phone, a certain number of students (each with a student id, name, and address), and a particular faculty member who chairs the department. We keep track of the start date when that faculty member began chairing the department. Faculties are employed by the academic department. Each faculty has a unique identifier, name, office, phone, rank, and employment starts date. We also record the faculty’s years of service, which is derived from the employment start date.

Answer 1

ER diagram of a university database::

rectangles are used to identify entity

diamonds are used to identify relationship

eclipses are used to identify attributes

double eclipses are used to identify multi value attributes

cardinalities are also mentioned there

primary keys are mentioned using eclipses with underline