Construct an E-R diagram for the modeling of a database

computer science


This assignment must be submitted on Blackboard via the allocated folder.

 Email submission will not be accepted.

 You are advised to make your work clear and well-presented, marks may be reduced for

poor presentation.

 You MUST show all your work.

 Late submission will result in ZERO marks being awarded.

 Identical copy from students or other resources will result in ZERO marks for all involved


 Convert this Assignment to PDF just before submission.



Pg. 02 Question Two

Question One

Construct an E-R diagram for the modeling of a database that contains information on

academic institutions and their researchers. The following should be stored: for each

researcher: ID, name, and date of birth. For each institution: name, location, and year.

For each School: names such as School of Law, School of Business, School of

Computer Science, etc. Each school belongs to exactly one institution. Each researcher

belongs to only one school. For each researcher, information on the highest degree

(BSc, MSc or Ph.D.), and at what school. For each researcher, information about the

research projects (title, start date, and end date). Information about co-authorships, i.e.,

which researchers have co-authered a paper including the title of the paper.

Identify the primary key of each entity, weak entities if any, one-to-one or many-to-

many….etc, and include any assumptions you make.

Related Questions in computer science category

The ready solutions purchased from Library are already used solutions. Please do not submit them directly as it may lead to plagiarism. Once paid, the solution file download link will be sent to your provided email. Please either use them for learning purpose or re-write them in your own language. In case if you haven't get the email, do let us know via chat support.