Scribd
Upload
8 views1 page

hw2 Spring25

This document outlines Homework 2 for CS 353 Spring 2025, due on February 20. It consists of three questions: creating an E/R diagram for a research center's database, translating that diagram into a relational model, and drawing an E/R diagram based on a given relational schema. The assignment emphasizes the relationships between researchers, students, projects, and departments within the research center.

Uploaded by

mehmetanil3361
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
8 views1 page

hw2 Spring25

This document outlines Homework 2 for CS 353 Spring 2025, due on February 20. It consists of three questions: creating an E/R diagram for a research center's database, translating that diagram into a relational model, and drawing an E/R diagram based on a given relational schema. The assignment emphasizes the relationships between researchers, students, projects, and departments within the research center.

Uploaded by

mehmetanil3361
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

CS 353 Spring 2025

Homework 2
Due: February 20, Thursday till midnight
You will use the Moodle course page for submission of this assignment

Q.1 [60 pts] Draw an E/R diagram for the conceptual design of a database system for a
research center. The following information should be captured in your design (use draw.io
or another diagramming tool):
Research projects conducted in the center are identified by a unique project number, and
the starting date, ending date, and the budget of the projects are also recorded. Researchers
of the center are associated with a unique id, together with a name, phone number, and
expertise level. The center also employs students who have a unique id, a name, and a
major field. Each research project is coordinated by one researcher, and one or more
researchers can be working on a project. A researcher is allowed to coordinate and/or work
on several projects. Students can also work on research projects. A student is allowed to
work on only one project. The work of the students in a project is supervised by a
researcher, starting from a certain date. The research center has a number of departments,
each with a unique department number and a department name. Each department is directed
by a researcher, and a number of students may be employed in a department. A student is
assigned to exactly one department.

Q.2 [25 pts] Translate the E/R diagram of the previous question into the relational model
(i.e., give the relation schemas for each case specifying the table names, together with the
attributes, and primary key and foreign key constraints).

Q.3 [15 pts] Consider the following relational schema:


R(X, Y)
S(Z, W, X)
X is a foreign key referencing R

Draw the corresponding E/R diagram.

You might also like