Question

Question: Draw the ER diagram of your database design in Crow’s Foot 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

CROW's Foot Entity entity with no attributes 2 entity with attribute fields Entity attributes field with Columns 9 Entity attributes field with columns and variable number of rows.

ERD Cardinality one t N Many one 3. H. One (and only 4) of Zer or ane S K one or many 6 zero or of many

4 Relationships is one to one EH H in ) One to me many of fuous of ӘСО + ins to know fuous

ER Diagram In Crow's Foot Notation University Thesis has Xulid HI has keywordspo H Type * Tid Akid Has subject has has th + Language HL Id SID Institutes * Ild supervisor # * Thesis Id Tid *LL Id * uid * I-Id Title Author Abstract No-of-Pages Supmission date Has author of & Sup. Id Persons HH superrise 11 * Pid