Question

note: I asked the database code by posting another question.

Question: Draw the ER diagram of your database design in Chen’s notation.

.

RULES OF DATABASE

Each thesis has the following mandatory attributes: thesis no (numeric), title, abstract, author,

year, type (one of Master, Doctorate, Specialization in Medicine, and Proficiency in Art),

university, institute, number of pages, language (Turkish, English, etc.), and submission date,

A person can be author of more than one theses (for example, a person can prepare a Master

thesis, later s/he can prepare a Doctorate thesis),

A thesis can have only one author (unlike scientific papers, there is no co-authorship in theses),

A thesis must have at least one supervisor,

A thesis must have at most two supervisors (one supervisor, and one co-supervisor),

A person can supervise many theses,

A university can have many institutes,

An institute can be part of only one university,

A thesis can be associated with one ore more subject topics (users select from a list of subject

topics; they do not enter subject topics freely),

. A thesis can be given zero or more keywords (unlike subject topics, users enter keywords freely),

A thesis can be written in only one of several languages.

Answer 1